[RESOLVED] PHP can't connect to MySQL 5.1

StevenJ

I have just bought a number fo new components & Vista 64, & build a new PC. Following this, I am trying to get my PC in the state it was before for developing php/mysql

I have php 5 installed, and I belive this is working fine, although, it wasn't as straight forward as Win2K and php 4.0.

Now I have come to installing MySQL and I can't get PHP to connect. the output from

phpinfo();

doesn't list anything to do with MySQL and my scripts can't connect, an example error being

Fatal error: Call to undefined function mysql_pconnect() in C:\localhost\blahwebsite\Connections\photogallery.php on line 9

I have followed all the straightforward instructions and even looked for a tutorial to do this, but still I cannot get it to work.

If I go to the MySQL command line promt, that is working fine, so MySQL is ok.

Finally, i have uncommented the lines in the php.ini file so they should load the extensions.

extension=php_mysql.dll
extension=php_mysqli.dll

I always considered myself to be very pc litterate, now i am unsure, HELP!

is there anything that is fundamental in getting the two to connect?

I even tried going back to MySQL 4 - but that didn't work either................

StevenJ

Loaded Configuration File C:\Windows\php.ini

both

php_mysql.dll
php_mysqli.dll

are in the ext directory,

checking the extension_dir in the php.ini file, I can see the following........

extension_dir ./ext

and this is refelected in the out put from phpinfo() ;

anybody?

cahva

Well you could try the full path. This is from my WAMP setup:

extension_dir = "c:/wamp/bin/php/php5.2.8/ext/"

If you really want to start developing and stop hassling with PHP/Apache/Mysql/whatever installation, I can warmly suggest just installing WAMP or other some other ready made packages that will install all the goodies for you.

StevenJ

I have actually changed the path, and specified the FULL path, but no difference.

Does WAMP do all the configuration too? I am just uninstalling PHP5, IIS and MySQL5.1, and will try this WAMP thingy. I have seen that mentioned elsewhere, but no link was given.

will let people know the outcome............

bradgrafelman

If you were using IIS, the solution probably would have been to add the PHPRC environment variable so that your php.ini file is loaded and parsed. You also need to add PHP to your system's PATH environment variable.

StevenJ

cahva;10906832 wrote:
If you really want to start developing and stop hassling with PHP/Apache/Mysql/whatever installation, I can warmly suggest just installing WAMP or other some other ready made packages that will install all the goodies for you.

thanks. thread resolved, and installed this WAMP nonsense. Recommend it!

thanks.

I do have other issues that have now arrised, which I guess are from the U/G from PHP4 to PHP5 but I need another thread for that!

thread resolved.