<!DOCTYPE html>
<html>
<head>
<title></title>
<style type="text/css">
h3{
text-align: center;
}
table{
width: 80%;
background-color: #33CCFF;
padding: 5px;
margin:5px auto;
text-align: center;
}
</style>
</head>
<body>
<h3>用户列表页</h3>
<table border="1">
<tr>
<td>编号</td>
<td>姓名</td>
<td>年龄</td>
<td>性别</td>
<!-- <td>头像</td> -->
</tr>
<?php
/*链接数据库*/
$con = mysql_connect('localhost','root','');
/*链接数据表*/
$db_selected = mysql_select_db('users',$con);
/*定义编码格式*/
mysql_query('set names utf8');
$sql = 'select * from userlist';
$res = mysql_query($sql);
/*长度*/
$num=mysql_num_rows($res);
for($i=0;$i<$num;$i++)
{
$sql_arr=mysql_fetch_assoc($res);
$id = $sql_arr['id'];
$username = $sql_arr['username'];
$age = $sql_arr['age'];
$sex = $sql_arr['sex'];
echo "<tr><td>$id</td><td>$username</td><td>$age</td><td>$sex</td></tr>";
}
?>
</table>
</body>
</html>
页面效果