empList.php
<html>
<head>
<meta content="text/html;charset=utf-8" http-equiv="content-type">
<title>雇员信息列表</title>
</head>
<?php
$conn = mysql_connect ( "localhost", "root", "root" ) or die ( mysql_error () );
mysql_query ( "set names utf8" );
//选择数据库
mysql_select_db ( "test", $conn );
$sql = "select * from emp";
$res = mysql_query ( $sql, $conn );
echo "<table width='700px' border='1px'>";
echo "<tr><th>id</th><th>name</th><th>grade</th><th>email</th><th>salary</th><td colspan='2'>操作</td></tr>";
//这里我们需要循环显示用户的信息
while ( $row = mysql_fetch_assoc ( $res ) ) {
echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['grade']}</td>";
echo "<td>{$row['email']}</td><td>{$row['salary']}</td>";
echo "<td><a href='#'>删除用户</a></td>";
echo "<td><a href='#'>修改用户</a></td><tr>";
}
echo "<h1>雇员信息列表</h1>";
echo "<hr/>";
echo "</table>";
//关闭资源
mysql_free_result($res);
mysql_close($conn);
?>
</html>