PHP & MySQLi timeout

Question

Whenever I try to create a mysqli object, as in;

$mysqli = new mysqli(host, user, pass, database);

...the page just loads for around a minute, then stops, showing all the content of the page up until that line.

info() says that MySQLi (and MySQL if that matters) are enabled, and I can access the MySQL CLI. I'm also working on a local machine, not a remote server.

I feel like I've missed something obvious. Can anyone shed some light on it?

Edit: just for clarification, I am actually putting real values into the mysqli constructor :)

Answer 1

The fourth parameter to the constructor should be the database, not the table.

$mysqli = new mysqli($host, $user, $pass, $database);

You might also want to try displaying the error message:

if (mysqli_connect_errno()) {
   die("MySQL Connect Error: " . mysqli_connect_error());
} 

A possible problem is if MySQL is not using the default port. You can add the port number as an optional parameter in the mysqli constructor.

Answer 2

Had to change the Windows hosts file (un-commented the localhost line).