<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head> <body>
<?php
$conn= mysql_connect("localhost","root","haifeng");
$dbselect = mysql_select_db("haifeng",$conn);
mysql_query("set names gb2312");
$sql = mysql_query("select * from testhaifeng");
$row = mysql_fetch_row($sql);
if($row==false){
echo "<div align='center' style='color:#ff0000; font-size:12px'>对不起,还没有</div> ";
} ?> <table width="200" border="0">
<tr>
<td>序号</td>
<td>用户名</td>
<td>密码</td>
<td>权限</td>
</tr>
<?php
do{
?>
<tr>
<td> <?php echo $row[0]; ?></td>
<td> <?php echo $row[1]; ?></td>
<td> <?php echo $row[2]; ?></td>
<td> <?php echo $row[3]; ?></td>
</tr>
<?php
}while($row=mysql_fetch_row($sql));
?>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($sql);
mysql_close($conn);
?>
|