empList.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 "
echo "
idnamegradeemailsalary操作";//这里我们需要循环显示用户的信息
while ( $row = mysql_fetch_assoc ( $res ) ) {
echo "
{$row['id']}{$row['name']}{$row['grade']}";echo "
{$row['email']}{$row['salary']}";echo "
删除用户";echo "
修改用户";}
echo "
雇员信息列表
";echo "
";
echo "
";//关闭资源
mysql_free_result($res);
mysql_close($conn);
?>