[RESOLVED] time a function

[child_of_php]

I am trying to tell if my mysql server is running before the page loads. I thought that a good way to do it might be to put in this code:
$db = mysqli_connect("localhost:3306", "root", "", "hscct2003");
if (!$db)
{
die('Server Error: ' . mysql_error());
}
, but after about 30 seconds, my browser just output this error:
Warning: mysqli_connect() [function.mysqli-connect]: [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306:3306) in C:\wamp\www\military\index.php on line 39

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2002): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\wamp\www\military\index.php on line 39.

What I want to do is to put in the same code and if it doesn't respond (set a value to a variable) in 5 seconds, kill the function and echo some sort of error.

does anyone know how to tell if mysql is running or have any idea how to time a function?

[bradgrafelman]

One way would be to change the way you attempt to connect:

1. Use [man]mysqli_init/man to initialize a connection resource.

2. Use [man]mysqli_options/man to set the MYSQLI_OPT_CONNECT_TIMEOUT option to a lower value (e.g. 3-5).

3. Attempt the connection using [man]mysqli_real_connect/man.

[child_of_php]

MYQSLI_OPT_CONNECT_TIMEOUT worked. thanks bradgrafelman.

in case anybody is interested, this is what the final product looked like:

function dbConnect()
{
	function customError($errno, $errstr)
	{
		echo "<b>Server Error:</b> MySQL is not running. <br />1) Please reload the page. <br /> OR <br />2) Try again later.";
		die();
	}
	set_error_handler("customError");
	$user = '(the username)';
	$pass = '';
	$dbName = '(the database)';
	$host = 'localhost:3306';

$mysqli = mysqli_init();
mysqli_options($mysqli,MYSQLI_OPT_CONNECT_TIMEOUT,2);
if(!$test = mysqli_real_connect($mysqli, $host, $user, $pass, $dbName))
{
	return;
}
else
{
	$test = mysqli_real_connect($mysqli, $host, $user, $pass, $dbName);
}
//
return $test;
}

$real_test = dbConnect();
if(isset($real_test) && !empty($real_test))
{
	restore_error_handler();
	session_start();
//and make the rest of the page

[bradgrafelman]

Glad I could help. In the future, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

Also, don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu.