Installing PHP with MySQL (Apache)

[BChico]

So im trying to get PHP to work with mysql. When i try to connect using php, i get an error asking for a missing file "php_mysql.dll"

So i copied that file from /php/ext to /php as well as /system32.

Still getting the same problem, any ideas?

This is running on XP.

 

[jfall]

Do you have the php_mysql library uncommented from php.ini?

 

[BChico]

Yes i do...took out the ":"

 

[Appledrop]

Shrug. i have a book upstairs called sams teach yourself php mysql and apache.. it has all this info for setting it up etc, and is a very good book soz cant be bothered to go and get it and to copy it all out haha. :l

 

[BChico]

^^

 

[n0cmonkey]

Is php having problems connecting to it or Apache? Or both?

 

[BChico]

PHP and apache work fine, i get an error when i start the apache service about locating this "php_mysql.dll" file.

 

[imported_Phil]

Start-> Run -> regsvr32 <location of php_mysql.dll>

Does that work?

 

[BChico]

No it didnt, what was that trying to do?

 

[n0cmonkey]

There's a package out there that combines all three of these into one install. Triad something or other I think. It's made for people like you.

The regsvr32 registered your dll.

Paste the relevant parts of your httpd.conf.

 

[razor2025]

use FoxServ

 

[BChico]

...being whiny

 

[imported_Phil]

Originally posted by: BChico
"It's made for people like you. "

Haha....riiiight....sorry i went to college for an engineering degree and not a community mid-way school to learn web apps.

Well anyway ill figure it out myself, cause obvisously no one here knows why it wont work either.

Paste the relevant parts of your httpd.conf.

Do you want our help?

 

[n0cmonkey]

Originally posted by: BChico
"It's made for people like you. "

Haha....riiiight....sorry i went to college for an engineering degree and not a community mid-way school to learn web apps.

Well anyway ill figure it out myself, cause obvisously no one here knows why it wont work either.

You're being difficult. You have not provided us with the information we need to troubleshoot the problem. You have not given us errors, you're vague about where the problem is (see my first post in this thread), you are not answering the questions we ask. In short, you DON'T KNOW HOW TO THINK. Give back that piece of paper you think makes you intelligent, apologize, destroy your computer and go live in the woods kid.

Troubleshooting is something I learned without college. :beer:

 

[Firus]

Please save yourself the trouble and download XAMPP from Xampp. It installs and runs out of the box with mysql, php, apache, SSL, perl...unless you want to install it yourself to figure it out. But if you just want something that works, download it.

 

[BChico]

Alright, i was a little rash this morning, just frustrated cause its such a stupid problem.

Im using windows, i have had apache, mysql, and php all installed for awhile now. Im using php 5, which is why i need to enable mysql support.

I uncommented the mysql.dll in the php.ini file, and added the c:\php to the PATH. That didnt work so i also moved the file to system32.

Is there anything else i need to do?

I am getting this error:

PHP Startup: Unable to load dynamic library 'c:\php\ext\php_mysql.dll' - The specified procedure could not be found.

I know how to set it up and have done it a few times, i am either forgetting something, or something is screwed up.


Thanks again

 

[kamper]

Is it a clean install of php5? Like with no other previous php installs of any version? It sorta sounds like it's getting the wrong version of the dll.

 

[BChico]

Yeah its a clean install, its looking for the my_sql.dll...and it exists in that directory so i dont know whats the problem

 

[n0cmonkey]

Post the relevant parts of your httpd.conf.

 

[BChico]

This what you want?

# For PHP 5 :
LoadModule php5_module "c:/php/php5apache2.dll"
AddType application/x-httpd-php .php

# configure the path to php.ini
PHPIniDir "C:/php"

 

[TheLogLady]

Go to your php root directory (c:\php). Copy the libmysql.dll that's in there. Paste that copy into your c:\windows\system32 directory.

Reference:one | two

Hope this helps.

 

[BChico]

Well that worked...wonder why it was asking for the php_mysql.dll and not the libmysql.dll......oh well


Thanks a lot