mysql_connect function isn't working

[Hendor]

Hi all. I've recently set up Apache 2.2 with PHP 5.2 and MySQL 5.1. I played around with SQL a bit, and now I'm trying to access it with PHP. I currently have the code:

<?php
 
# error_reporting(E_ALL);
# ini_set('display_errors', true);
 
echo "test";
 
$link = mysql_connect('localhost', 'root', '[mypassword]');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
 
?>
 

When I run the above in Firefox with my correct password, all I get is "test", verifying to myself that PHP was working when the script ran. I've also verified that the username and password correctly start MySQL though the CLI, but I don't think that's the issue here. If they were incorrect, I should get the "Could not connect" message and the MySQL error, but I get no errors at all. This makes me think the mysql_connect function itself isn't working right.

What possible mistakes could I be making? Thanks in advance.

[jamwil]

I'm certainly no expert, but it looks to me like your code is sound.
Seems to me like php is not communicating with mySql... Which I'm not the person to ask how to fix.

[Dormilich]

still the question remains, why there is no further output. you could try using a database abstraction layer (e.g. PDO). they are usually more responsive/informative when it comes to errors.

[Ciary]

try this and see what it outputs (if it outputs something). whats wrong is, if an sql error occurs, your phpcode wil stop. therefor you need to put the error-output on the same line as where you get the error.

$link = mysql_connect('localhost', 'root', '[mypassword]') or die(mysql_error($link));

warnings are different, they wont stop the executing code

[Atli]

@Ciary
I'm not sure you are right there.
Using "or die()" or a if statement, like he did, is pretty much the same thing.

SQL errors don't affect the execution of the PHP code, other than the mysql_connect function returning FALSE rather than returning a resource.

Could it be that the mysql extension isn't installed, and the mysql functions simply aren't there?
Try using the function_exists function to see if the mysql_connect function really exists.

[Hendor]

Thanks for your responses; I think Atli got it. I ran this script:

<?php
if (function_exists('mysql_connect')) {
    echo "Good<br />\n";
} else {
    echo "Bad.<br />\n";
}
?>

It returned "Bad", so the MySQL extension for PHP is not installed. Is this the kind of thing that PHP would exclude when I choose the Recommended settings during its installation? Seems like a pretty major component to be considered unimportant... I'll reinstall PHP fully and try again.

[Atli]

@Hendor
The MySQL extension was compiled into PHP4, but they detached it in PHP5 and made it an optional extension.
Not sure exactly why, but I bet they had their reasons :)

If you are using the Windows installer, you don't have to completely reinstall it.
Just go to the Add/Remove Programs, find PHP in the list and click modify. Then you should be able to go through the installation wizard again and check the extensions you want.

[Hendor]

Ok, thanks. I've done that, restarted Apache and computer, but it's still not working. PHP seems to work just as before, but still returns "Bad" when I run that script.



I've read a few things and looked through my php.ini. I found this:

extension_dir=" C:\Program Files\PHP\ext"

The phpinfo() function also returns that directory as the extension location. When I look in that PHP directory, there is no "ext" sub-directory, only ones called dev and PEAR. So PHP is looking for the mysql (and other) extensions in a non-existent folder...

Two questions: Do you know where the PHP installer would have put the extensions during installation, if not where it says in the ini file. And, is it just php_mysqli.dll and libmysql.dll that is needed, or is there more? Thanks.

[Markus]

Not a solution to your current problem, but try out one of the nifty installers that have most web-development components bundled with them.

XAMPP

EasyPHP

Both very easy to set up, and they do most of the work for you.

[Atli]

@Hendor
The installer should have put php_mysql.dll into a ext directory under the PHP installation path.
The libmysql.dll should be directly under the PHP installation path.

There are only three things that you need to do to get the MySQL extension working.

1. Put php_mysql.dll into the directory specified in the extension_dir directive.
   If the installer didn't provide the DLL you can download the ZIP package at the php.net download page and use the DLL from there.
2. Add/uncomment "extension=php_ mysql.dll" in your php.ini file.
3. Add the PHP installation dir to your path variable.
   (See the instructions here)
   Alternatively, you can just copy the libmysql.dll into the Windows directory, although I would at least try setting the path variable first.

Then restart the server and it should be working.

Edit:
I just realized you wrote php_mysqli.dll, rather than php_mysql.dll.

These are two different extensions: The old MySQL Extension and the new Improved MySQL Extension.

They are two very different things.