Little something for the experts...

thesinister

Hello World...!
Newbie at PHP.

Was following this tutorial @ http://www.tanguay.at/installPhp5.php5?step=16&PHPSESSID=ae6a155b81fe6981431e81269fcf8cac when suddenly came across with this error:

Fatal error: Class 'mysqli' not found in C:\webs\test\testmysql41.php on line 3

Following the tutorial I created the database "demo" and the testmysql41.php file. (Just a cut and paste):

$mysqli = new mysqli('localhost','root','admin');
$mysqli->select_db('demo');

$result = $mysqli->query("SELECT * FROM members");

while($row = $result->fetch_assoc()) {
print $row['firstName'] . ' ' . $row['lastName'] . '<br/>';
}

$result->close();

Followed the tutorials' instructions and checked out most of the posted comments on possible problems with no avail.... mysqli.dll is in the c:\php folder like it instructs and the php.ini file updated with the extension=php_mysqli.dll inserted without the semi-colon. Still getting this problem.

Any help is appreciated.

thorpe

create another file named phpinfo.php and place this code in it.

<?php

phpinfo();

?>

now browse to this script and view it. this should bring up a bunch of info about your php install. is there anything in there about mysqli? just want to check to make sure its definately installed properly as it appears its not.

thesinister

I checked again thorpe using that script to see if maybe there was something strange i could spot. Nothing out of the ordinary... Though I dont know all that much about this....Should there be something in particular to look at?

Everything seems enabled or directed to the correct path.
The config file path is set to c:\php\php.ini and the windows path
is set correctly (with the ;c:/php in the end).

Apache/2.0.55 (Win32) PHP/5.0.5 is my setup by the way just to clear things up.
everything pretty much is up to date. Running windows xp pro.
The funny thing is that with other tutorials with small scripts (like date and time) (sql lite database examples) all worked perfectly fine.

Now with mysql..... i cant get it to work...!
Could there be something up within the script.... say the root or the password is wrong and causing that error in line 3?..... Could someone clarify what that line does?

Thanks.

kakki

maybe you can use "mysql_connect" as a workaround

thorpe

it is saying that the mysqli (not mysql) class cannot be found. this leads me to believe it isn't installed.

when you run the phpinfo(); function, scroll down, just below the section for mysql there should be a section for mysqli. if its not there, then its not installed properly.

you could just as easily use the mysql extension to achieve the same goal.

<? 
mysql_connect('localhost','root','admin'); 
mysql_select_db('demo'); 

$result = $mysql_query("SELECT * FROM members"); 

while($row = $result_fetch_assoc()) { 
  print $row['firstName'] . ' ' . $row['lastName'] . '<br/>'; 
} 

?>

thesinister

I'll try those out....
Thanks!