Trouble making connection to MYSQL

[pherrick]

I am a PHP beginner  trying to connect to MySQL data base

The following code gives me NO feedback from my browser.

 

<?php

$mysqli = new mysqli("localhost", "root", "password", "test");

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

} else {

printf("Host information: %s\n", mysqli_get_host_info($mysqli));

}

?>

 

 

[Jessica]

There is probably a syntax error but you can't see it because you don't have error reporting turned on.

 

add:

ini_set('display_errors', 1);
error_reporting(E_ALL);

to the top.

[pherrick]

Thankyou!

Now I am getting feed back, another clue to solve.

The error trapping routine has told me that line 4 has a syntax error.

 

Fatal error: Class 'mysqli' not found in ........

 

Thanks for your help.

 

Paul

[Jessica]

I am not that familiar with the mysqli functions. Does it work when you use the regular mysql functions?

Does your PHP have mysql support? Like, if you do phpinfo() does it show the mysqli stuff?

[BlueSkyIS]

Jesirose is right on track as usual. Make sure you have mysqli compiled into your PHP.

[pherrick]

I am not able to use any msqli functions.

I am able to use msql.

 

As far as my connection problem, I found the info about setting up the msql extensions in the php.ini file.  (I found that in FAQ)

So I can successfully connect to MYSQL.  Thanks

 

 

I am now getting more dangerous as each day goes by.  Thanks to all your help.

 

I will look into compiling the msqli into PHP, so I can use the examples in this book I am using.

 

Thanks again.

 

Paul