$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);
?>