Intergrating PHP with MYSQL

pipl

Hi everyone,

I have MYSQL 5.0.45, PHP running on D:\ drive,

and I am trying to connect PHP to MYSQL.

I keep getting this:

Fatal error: Call to undefined function mysql_connect() in D:\webroot\temp_con.php on line 3

on my browser.

Does anyone know what I am doing wrong!

Paul.

laserlight

You need to enable the MySQL extension by editing php.ini and restarting the webserver.

Actually, unless you have no other choice, you might as well use the PDO extension or MySQLi extension instead.

pipl

Thanks for your reply,

I have opened the php.ini file in Notepad to have a look and it seems these extensions are already in there.

I loaded the php test page on my browser and it says my Configuration file (php.ini) path is: C:\WINDOWS

I installed php to D:\ drive

Could this be the problem!

Wishing you only good things,

Paul.

laserlight

I have opened the php.ini file in Notepad to have a look and it seems these extensions are already in there.

Are they commented out with a #?

I loaded the php test page on my browser and it says my Configuration file (php.ini) path is: C:\WINDOWS

I installed php to D:\ drive

The "Loaded Configuration File" value is more interesting, so look out for that instead.

As this appears to be an installation problem, I am moving it to the Install forum.

pipl

Hi,

I found if I put this line PHPIniDir "D:/php" in my apache httpd config file the php test page doesnt show, that is once I have restarted apache.
The opposite happens if I delete that line above, that is the php test page appears meaning PHP works.

I'm a little confused, cause it says in the PHP install file to add that line after LoadModule php5_module "D:/php/php5apache2.dll"
AddType application/x-httpd-php .php

I was curious, what does PHPIniDir "D:/php" do and why doesn't it work when I add it?

Wishing you well

Paul.

laserlight

I was curious, what does PHPIniDir "D:/php" do and why doesn't it work when I add it?

It sets the "D:\php" directory as the configuration file directory, i.e., the configuration settings in the file with file path "D:\php\php.ini" would be used. In other words, "D:\php\php.ini" would be the loaded configuration file.

I'm a little confused, cause it says in the PHP install file to add that line after LoadModule php5_module "D:/php/php5apache2.dll"

What version of Apache and PHP did you install, and what is the exact directory where you installed PHP to?