<html>
<head>
<title>用户列表</title>
</head>
<body>
<?php
//连接数据库
$conn=mysql_connect("localhost","root","12345678") or die("连接失败");
$db=mysql_select_db("fqwh");
$query="select * from usr";
$result=mysql_query($query);
mysql_query('SET NAMES utf-8');
$data=mysql_fetch_array($result);
if(mysql_num_rows($result)>0){
?>
<table border="1" align="center" background="#99CCFFLL">
<tr>
<td align="center">id</td>
<td align="center">name</td>
<td align="center">chinesename</td>
<td align="center">email</td>
<td align="center">qq</td>
<td align="center">housename</td>
<td align="center">操作</td>
</tr>
<?php
do {
echo "<tr>";
echo "<td>$data[id]</td>";
echo "<td>$data[name]</td>";
echo "<td>$data[chinesename]</td>";
echo "<td>$data[email]</td>";
echo "<td>$data[qq]</td>";
echo "<td>$data[housename]</td>";
echo "<td><a href='add.html'>添加用户</a><a href='del.php?uid=$data[id]'>删除用户</a><a href='update.html'>修改用户</a></td>";
echo "</tr>";
}
while ($data=mysql_fetch_array($result));
}
else
{
echo "没有数据";
} ?>
</table>
</body>
</html>