You may want to consider using php_mysqli.dll instead.

Thank you, thank you, thank you, thank you, thank you, thank you, thank you!!!

I've been looking for this for ages. You've really really helped me. Thanks again.

Greetings all. I am new to using PHP and have successfully installed php and apache, this means of course that the two work with simple things like phpinfo() and other short php scripts. My problem comes when, like most the others here, I try to set up mysql. I have copied .dll files to all sorts of folders, uncommented lines and it still isnt working. There are however two things that I have noticed.
1. the ext folder that everyone is referring to did not install with the php installer i used. I ended up just creating an empty file called ext which of course didnt work
2. in my phpinfo() script i find no occurance of MySql, not even in the path that is listed, but under set path on a command line i do see it there.

Any help would be greatly appreciated.

I am using Apache2.0.52, PHP5 and mysql4.0.21..when i run this program:

<?php
// Connecting, selecting database
$link = mysql_connect('localhost', '***', '***')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('my_database') or die('Could not select database');

// Performing SQL query
$query = 'SELECT * FROM my_table';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";

// Free resultset
mysql_free_result($result);

// Closing connection
mysql_close($link);
?>

i get this error:
Fatal error: Call to undefined function mysql_connect() in C:\Apache2\htdocs\connection.php on line 3

I have copied libmysql.dll and libmysqli.dll to system32 folder of my windows Xp..i have copied my php.ini to windows

dir and edited it..like i have uncomment this: extension=php_mysql.dll

I have added this to my path variable:
;C:\php5;c:\mysql\bin ...

i have done this too...extension_dir = "C:\php5\ext"

So why i m still getting this error...my phpinfo() is showing me the page powered by zend tech..

Somebody should please help me out, i have php 5.2, apache 2.2 and mysql 5.0.2 (Community server). i tried all my best to configure php and mysql, all to no avail. both of them are working indepently. i have tried all the steps above. and have used a lot tutorials
PLEASE SOMEBODY HELP

Note to the last three members who posted in this sticky thread and who did not get a reply -

1) Sticky threads are for informational purposes, not for posting questions or problems. Create a new thread in the actual forum to post your question or your problem.

2) This sticky thread is right under the menu bar and the highlighting it gets when new posts are made to it is not easily noticed. If you want your post to get noticed, post it in the actual forum as a new thread.

3) Adding new occurrences of a same/similar problem onto the end of an existing thread is also a way to get your post ignored. Each person needs to start his own thread with an appropriate title. If you need to reference an existing thread, either include a link to it or include the pertinent portion of it as a quote in your new thread.

I just solved my problem with php configuration. I thought i had done everyting untill I found a swedish article on the subject.

There is four steps that needs to be done.
One: edit the php.ini file uncoment extension=php_mysql.dll
two: check the Directory in which the loadable extensions (modules) reside.
for example extension_dir = "C:\php\ext"
Three: check that the dll file exists in the obove location.
Four: "important" copy the libmysql.dll file to the system directory C:\Windows\

This should work. PS dont forgett to reload the webserver

If you add the PHP installation folder to your Windows path (as the php.net installation instructions state) there is absolutely no need to copy any files around to get PHP or any extension to work. As always, the best and most current installation instructions are found in the PHP manual and in the installation.txt file that comes with PHP.

Hi,
I am using php5.0 and mysql on winxp with IIS. I am getting a error stating
PHP Warning: PHP Startup: Unable to load dynamic library '.\php_mssql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '.\php_mysql.dll' - The specified procedure could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library '.\php_mysqli.dll' - The specified procedure could not be found. in Unknown on line 0.
I have tried everything possible but cant seem to get this to work.

Hi all,
Thanks a lot for lots of useful info.

I tried the steps to link PHP and mysql. I did all the modifications in php.ini and httpd files.

But still I am getting an error as this :
Fatal error: Call to undefined function mysql_connect()

pls help me out how to resolve this prob.

thanks.

I am currently experiencing the same problems whereby the mysql_connect( )
function is being treated.

hi Bill

thanks for the information , i manage to configure php5 to work with MySql and Apache

Hey thanks to all for the such a valuable information about the PHP.I use Easy PHP software.When it is installed All the three component PHP,Apache,MysQlof the WAMP model get installed.It's very nice for the PHP.

I think that's can help: php mysql extension setup problem