gistfile1.php

<?php
/*
mysqliでコネクションを確認しつつ接続しなおすサンプル
*/
$mysqli = mysqli_init();
$mysqli->options(MYSQLI_INIT_COMMAND,"set names utf8");
$host = "localhost";
$user = "user";
$pass = "";
$db_name = "moe";

$mysqli->real_connect($host,$user,$pass,$db_name);
$mysqli->query("SET SESSION wait_timeout = 3");

if($error = mysqli_connect_error()){
	throw new Exception($error);
}

$mysqli->set_charset("utf8");

for(;;){
	if($mysqli->ping()){
    printf ("Our connection is ok!\n");
    printf("thread_id:%d\n",$mysqli->thread_id);
    sleep(4);
	}else{
		$stmt = $mysqli->query("select 1");
    printf("thread_id:%d\n",$mysqli->thread_id);
    printf("Our connection is not good.\n");
    $mysqli->real_connect("localhost","websrv","","auction_motekawa");
    sleep(3);
	}

}