$con = mysql_connect("localhost","root","");

if (!$con)

{

die('数据库连接失败: ' . mysql_error());

}

else

{

mysql_query("SET NAMES UTF8");

mysql_query("set character_set_client=utf8");

mysql_query("set character_set_results=utf8");

mysql_select_db("demosql", $con);

$result = mysql_query("SELECT * FROM teacher");

//在表格中输出显示结果

echo "

id	name

while($row = mysql_fetch_array($result))

{

echo "

";

echo "

" . $row['id'] . "";

echo "

" . $row['name'] . "";

echo "

";

}

echo "

";

}

mysql_close($con);

?>