[RESOLVED] php 5 + mysql 5

auddog

I have installed php 5.1.4 and mysql 5.0.18 on my windows 2003 box with IIS6. I followed the instructions to make php work with mysql. I copied the libmysql.dll and the php5ts.dll to the c:\windows\system32. I can see everything on in the phpinfo page as loaded. However, when I run the script below (off of php website) I get nothing but a blank screen. I can get other php scripts to work, but nothing with mysql.

<?php
$link = mysqli_connect("localhost", "root", "password", "pce");

/ check connection /
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

printf("System status: %s\n", mysqli_stat($link));

mysqli_close($link);

Thanks for any help that you might be able to provide.

Houdini

Try this

<?php
echo "MySQLI test";
$link = mysqli_connect("localhost", "root", "password", "pce");
echo $link."<br />";//should get a resource here 
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n". mysqli_connect_error());//you had an error here I fixed the comma
//exit();
echo "It failed MySQL said ".mysql_error();
}
printf("System status: %s\n". mysqli_stat($link));//same problem here It is NOT a comma it is a period
mysqli_close($link);
echo "Something is really wrong here.";
?>

auddog

that worked. I received MySQLI test in the top corner. Thanks for the help. That's really strange because that comes off of php.net page (cut and paste).

auddog

actually that didn't work. I was to quick to reply sorry. It does not give any of the information about the database, it only give the first part (echo).

bradgrafelman

Make sure display_errors is set to On, and change error_reporting to E_ALL.

Houdini

Then what exactly does phpinfo() show when you run it for mysqli and or mysql? You should at least get an error...I do know that from the code I gave you it at least did the first part, but disregarded the rest and dies somehow or It should have also said Something is really wrong here.

auddog

when I run phpinfo, I see an area for mysql - I don't see anything for mysqli - should there be? I also installed php5 and mysql 5 on my laptop and have the exact same error or lack of error, so I think it must be something not configure correctly in php.

Houdini

Your php.ini file should have the below line un commented (no ;) in front of it

extension=php_mysqli.dll

it should also have that file (php_mysqli.dll) in the extension directory in your ext or extension folder wherever it is. PHP 5 comes with this dll or should have. Just make sure it is where you told it in the php.ini under extensions

extension_dir = "C:\php\ext\"

or whatever you have in that section.

auddog

Unbelievable!!! When I looked into my php.ini file, I had the following

extension=php_mysql.dll

There was no listing for php_mysqli.dll, but by adding the "i" to the extension list, I started seeing my database connection. I will continue testing, but it appears to be working correctly. Thanks for all the help.

firecircle

I am having the same/similar problem... I've tried the following code...

Houdini wrote:

Try this

<?php
echo "MySQLI test";
$link = mysqli_connect("localhost", "root", "password", "pce");
echo $link."<br />";//should get a resource here 
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n". mysqli_connect_error());//you had an error here I fixed the comma
//exit();
echo "It failed MySQL said ".mysql_error();
}
printf("System status: %s\n". mysqli_stat($link));//same problem here It is NOT a comma it is a period
mysqli_close($link);
echo "Something is really wrong here.";
?>

This results in the echo "MySQLI test" and the following message and nothing else: "Catchable fatal error: Object of class mysqli could not be converted to string in C:...apache...\test.php on line 4"
I'm at a loss. phpinfo shows MySQLIi and MySQL. I've read every forum I could find and none offer a solution as of yet.

laserlight

This results in the echo "MySQLI test" and the following message and nothing else: "Catchable fatal error: Object of class mysqli could not be converted to string in C:...apache...\test.php on line 4"

That is a bug in Houdini's code. Try the example from the PHP Manual:

<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

printf("Host information: %s\n", $mysqli->host_info);

/* close connection */
$mysqli->close();
?>

firecircle

thanks laserlight, that worked. Turns out I've been trying a variety of erroneous scripts or trying mysql where it should have been mysqli, and I was looking in the wrong section of the PHP Manual.

abhix

hi Laser,
I am bugged by same error but donno how to get rid of it in my case?
I am using PEAR mail Queue tut example

ERROR: Catchable fatal error: Object of class mysqli could not be converted to string in ../add_message.php on line 7
here is add_message.php line 7
$mail_queue =& new Mail_Queue($db_options, $mail_options);
here is config.php from which add_message.php fetches $db_option
$db_options['dsn'] = 'mysql://'.$mysql_user.':'.$mysql_pass.'@'.$mysql_host.'/'.$mysql_db;

I guess 'mysql://'... is causing the problem. tried using new mysqli() but got same error !
plz help!