windows - Undefined function mysql_connect() error

Question

I am new to this whole programming, PHP, MySql deal. So, if I don't say it how I should please bear with me. I ran MySql.PHP through my site and web browser and get this >"Fatal error: Call to undefined function mysql_connect() in D:web sitemysql-php-test.php on line 2"

I have no idea what I am really doing. Here's the code for the file.

<?php
$link = mysql_connect('localhost', 'username', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

I of course change the username and password to the user and password for my database. The database is on port 3306. What am I doing wrong? If nothing, then any ideas on what's going on?

Answer 1

Check if the mysql module is loaded.

Your php.ini file needs to have extension=mysql.dll somewhere, without ; at the start of the line.

See also phpinfo. It will help you see what is enabled.

To do that, create a page called phpinfo.php in the webroot (e.g. the same place you put mysql.php) with this contents:

<?php
phpinfo();
?>

then browse to http://localhost/phpinfo.php.

Search that page for mysql. There should be a section about halfway down. If not, something is wrong with your setup and MySQL is not enabled.