Re: Fw: [PHP] Connecting to MySql with PHP

On Tue, 2010-10-05 at 13:35 +0100, sueandant wrote: > ----- Original Message ----- > From: sueandant > To: ash@ashleysheridan.co.uk > Sent: Monday, October 04, 2010 10:29 PM > Subject: Re: [PHP] Connecting to MySql with PHP > > > Thanks Ash > > Where do I find the PHP mysql module? I have uncommented both the extensions php-mysql.dll > and php-mysqli.dll; do I need to do more? > Just curious... BUT.... Did you restart apache (or your webserver software) ? > Thanks > > Tony Holland > ----- Original Message ----- > From: ash@ashleysheridan.co.uk > To: sueandant ; php-general@lists.php.net > Sent: Monday, October 04, 2010 10:21 PM > Subject: Re: [PHP] Connecting to MySql with PHP > > > Have you installed the php mysql module? Basically, it tells php how to connect to mysql. > > This question has come up a few times this week, have you tried installing something like > xampp or easyphp rather than the individual software components: Apache, php & mysql. > > Thanks, > Ash > http://www.ashleysheridan.co.uk > > ----- Reply message ----- > From: "sueandant" <hollandsathome@tiscali.co.uk> > Date: Mon, Oct 4, 2010 22:08 > Subject: [PHP] Connecting to MySql with PHP > To: <php-general@lists.php.net> > > I am running PHP 5.3.3, with Apache 2.0 Handler and MySql Server 5.1. My OS is Vista Home > Premium 32 bit with SP2. > > MySql works fine from the command prompt, Apache is running and PHP works. But I cannot > access the mysqli classes. This simple program: > > <?php > > $mysqli = new mysqli("localhost", "root", "######", > "testDB"); #I've deliberately obliterated the password > > if (mysqli_connect_errno()) { > printf("Connect failed: %s\n", mysqli_connect_error()); > exit(); > } else { > printf("Host information: %s\n", mysqli_get_host_info($mysqli)); > } > ?> > > produces this error message: > > Warning: mysqli::mysqli() [mysqli.mysqli]: [2002] A connection attempt failed because the > connected party did not (trying to connect via tcp://localhost:3306) in > C:\Apache\htdocs\mysqlconnect.php on line 3 > > Warning: mysqli::mysqli() [mysqli.mysqli]: (HY000/2002): A connection attempt failed because > the connected party did not properly respond after a period of time, or established connection > failed because connected host has failed to respond. in C:\Apache\htdocs\mysqlconnect.php on line 3 > > Fatal error: Maximum execution time of 30 seconds exceeded in > C:\Apache\htdocs\mysqlconnect.php on line 3 > > I guess PHP cannot find the mysqli classes. I've checked the phpinfo() output and > discovered : > > Configuration File (php.ini) Path C:\Windows > Loaded Configuration File C:\PHP\php.ini > > > I don't know if this ok. I've tried changing the location of the loaded file to > C:\Windows\php.ini, but to no avail, and I don't know how to change the location of the config > file. > > I am obviously doing something wrong, but I don't know what. Can anyone help? > > Ironically, everything worked perfectly before I upgraded to PHP 5.3.3! >