Error connecting mysql database...

You most probably have simply installed the 2 applications apart from each other and you not installed the MySQL extension in PHP. See your PHP and MySQL installation guidelines on this.

Ronald

Like Ronald says, your PHP installation is missing the MySQL extension.

A common reason for extensions failing to load on Windows is that the PHP install directory is missing from the PATH env variable.

Try adding that, reboot and try again.

Hi All

I installed PHP and MySQL . I am trying to establish the database connection with MySQL through PHP, I got the fatal error of the below message. I am using the MySQL server of Windows XP systems with Service pack S2.

Fatal error: Call to undefined function mysql_connect()

This is my program, please check it and suggest it.

This has nothing to do with your php code! It is your iunstallation of the PHP and MySQL packages where the problem is.

See Atli's and my previous posts on this problem. And check your installation of both applications.

Ronald

Quote: Originally Posted by Atli Like Ronald says, your PHP installation is missing the MySQL extension. A common reason for extensions failing to load on Windows is that the PHP install directory is missing from the PATH env variable. Try adding that, reboot and try again.

Fine.. How can i set path to mysql in PHP or how to check that PHP is missing MySQL extension or not ??.. Should i reinstall PHP ???

Quote: Originally Posted by vikas1111 Fine.. How can i set path to mysql in PHP or how to check that PHP is missing MySQL extension or not ??.. Should i reinstall PHP ???

Hi,
i think you'll get the information regarding MySql extension in phpinfo()

Regards,
RP

Quote: Originally Posted by rpnew Hi, i think you'll get the information regarding MySql extension in phpinfo() Regards, RP

Thanks.. But how can i make changes ?

Quote: Originally Posted by vikas1111 Thanks.. But how can i make changes ?

Try this...

1. Right click on My Computer -> Select Properties
2. Select the Advanced tab and click the Environmental Variables button
3. Find and double-click the PATH variable in the System Variables list
4. Add the absolute path to your PHP installation directory to the the Variable Value. Remember to separate it from the previous item with a semi-colon (;)
5. Click OK -> OK and reboot your computer.
6. Check if the MySQL extension is working now.

Quote: Originally Posted by Atli Try this... [*]Find and double-click the PATH variable in the System Variables list[*]Add the absolute path to your PHP installation directory to the the Variable Value. Remember to separate it from the previous item with a semi-colon (;) [/list]

Thanks..
This.. %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN..
Is already there in the Variable Value field.. Is it correct ???

Quote: Originally Posted by vikas1111 Thanks.. This.. %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN.. Is already there in the Variable Value field.. Is it correct ???

Hi,
Leave them as it is you just need to append your mysql path as 'Atli' has suggested.

Regards,
RP

Quote: Originally Posted by Atli Try this... Right click on My Computer -> Select Properties Select the Advanced tab and click the Environmental Variables button Find and double-click the PATH variable in the System Variables list Add the absolute path to your PHP installation directory to the the Variable Value. Remember to separate it from the previous item with a semi-colon (;) Click OK -> OK and reboot your computer. Check if the MySQL extension is working now.

Hi tried but still not working...

Quote: Originally Posted by vikas1111 Hi tried but still not working...

Check the ext folder in your PHP install dir.
"C:\Program Files\PHP\ext" by default.

There should be a file called 'php_mysql.dll'.
If it is missing you need to run the PHP installer again and have it install the MySQL extension.

If that doesn't work, try opening your php.ini file and locate the line starting with 'extension_dir'...
Make sure that this contains the full path to your PHP extension directory.
Which, by default, is:


And always remember to restart your HTTP server after making changes.
If your using IIS, you will probably have to reboot for the changes to take effect.