listUser.php

来源：互联网发布：mac系统崩溃怎么恢复编辑：程序博客网时间：2024/05/16 15:52

<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){

<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>