怎么测试mysql连接是否正常_测试mysql连接和编码是否正常。

$db = mysql_connect("localhost", "root","")

or die("Could not connect: " . mysql_error());

mysql_select_db("corp2",$db);

$currConnEncode = mysql_client_encoding($db);

echo $currConnEncode;

$q = "SET NAMES 'utf8' ";

$result = mysql_query($q,$db);

$q="SELECT  * FROM mos_categories limit 50";

//$q = "show tables";

$result = mysql_query($q,$db)

or die("Could not query: ". mysql_error());

$numrows=mysql_num_rows($result);

if ($myrow = mysql_fetch_array($result)) {

echo("

while ($myrow = mysql_fetch_array($result))

{

printf("

%s%s%s\n", $myrow[0], $myrow[1], $myrow[2]);

}

echo "

\n";

}

else{

echo("sorry no record was found");

}

echo ("the affected rows was $numrows");

?>