[RESOLVED] Trouble connecting to MySQL

[tuxedoparkmark4]

I am just getting through the SAMS teach yourself PHP, MySQL, and Apache and have run into a road block. There must be something that I am missing, because everywhere that I have looked shows that the following should work:

<?php
$dblink = new mysqli("localhost", "root", "password", "access") or die(mysqli_error($dblink));
echo "Connected to MySQL<br />";
?>

MySQL is on the local PC, I only have the root user, I know the password, and I have created a database named access. Any suggestions would be great, I have been working on this for several hours now.

Thanks,

[reli4nt]

What error do you get?

[NogDog]

To check for a connection error:

<?php
$dblink = new mysqli("localhost", "root", "password", "access");
if($dblink->connect_error)
{
   die($dblink->connect_error);
}
echo "Connected to MySQL<br />";
?>

[tuxedoparkmark4]

Sorry, it took me some time to find the error log file. I have alot to learn. Here is what I am getting:
[Tue Apr 07 21:02:39 2009] [error] [client 127.0.0.1] PHP Fatal error: Class 'mysqli' not found in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysqlconnect.php on line 2

[stolzyboy]

Are you using PHP5?

[tuxedoparkmark4]

Yes I am using PHP5. Here is what I have done so far from reading other posts;
changed the directory to where the extensions are:
extension_dir = C:\php\ext

deleted the ; before:
extension=php_mysqli.dll

copied libmysql.dll to System32 dir:
I just read somewhere that this is not recommended, and that I should add the path to the Windows System's path environement variable.

Are there some small steps that I am missing. Should there be quotes around the dir path? Do I need to restart something?

Thanks,

[stolzyboy]

Are you restarting Apache when you make changes to the php.ini?

[bradgrafelman]

tuxedoparkmark4 wrote:

copied libmysql.dll to System32 dir:
I just read somewhere that this is not recommended

Indeed; delete the copy of the file.

tuxedoparkmark4 wrote:

I should add the path to the Windows System's path environement variable.

Right again! :p If you haven't done that already, you should. See this manual page if you need help doing so.

Finally, are you sure your php.ini file is being parsed by PHP? Make a change in some core PHP directive (e.g. turn display_errors On if it's off presently, or vice versa), restart Apache as stolzyboy pointed out, and see if a phpinfo() reflects your change. If not, then PHP isn't parsing your php.ini file.

[NogDog]

The DLL files should be in the directory pointed to by the extension_dir setting in your php.ini file. It should not also be copied to your Windows DLL directory. The Windows path setting should include your main PHP directory. For instance my path setting is "C:\wamp\bin\php\php5.2.6" and the php.ini extension_dir is "c:/wamp/bin/php/php5.2.6/ext/".

[tuxedoparkmark4]

I have not restarted Apache after any of the changes, I will give that a try ASAP. I am hoping that this has been my problem all along. Thanks for all of the help.

[stolzyboy]

Well, if you were making php.ini changes and weren't restarting Apache, those changes wouldn't take effect until Apache was restarted.

It's possible you've been chasing your tail this whole time with a simple change that didn't occur due to the lack of the restart.