?? show.php
字號:
<!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>
<style type="text/css">
<!--
.STYLE2 {color: #000000}
-->
</style>
</head>
<body>
<?
if(empty($_COOKIE["test"])) //沒記錄
echo "<script> alert('無權限查看！請先登陸 ！');history.back();</script>";
require('db_start.inc');
$sql="SELECT * FROM web_user ORDER BY `id` DESC ";//sql語句
$result = mysql_query($sql);
?>
<table width="800" border="1" align="center" cellspacing="0" bordercolor="#99FF99" bgcolor="#FFFFFF">
<tr bgcolor="#FFFF99" bordercolor="#999999">
<td width="70"><div align="center" class="STYLE2">姓名</div></td>
<td width="100"> <div align="center" class="STYLE2"><span class="STYLE2">生日</span></div></td>
<td width="100"> <div align="center" class="STYLE2">電話</div></td>
<td width="170"><div align="center" class="STYLE2">身份證</div></td>
<td width="170"> <div align="center" class="STYLE2">興趣</div></td>
<td width="150"> <div align="center" class="STYLE2">住址</div></td>
<td width="40"><div align="center" class="STYLE2">其他 </div> </td>
</tr>
<tr>
<td colspan="7" height="3"></td>
</tr>
<?
while($row=mysql_fetch_row($result))//返回結果
{ //print_r($row);
?>
<tr bgcolor="#CCFFFF" >
<td width="70"><div align="center"><? echo $row[2];?></div></td>
<td width="100"> <div align="center"><span class="STYLE2"><? echo $row[4]."/".$row[5]."/".$row[6];?></span></div></td>
<td width="100"> <div align="center"><span class="STYLE2"><? echo $row[8];?></span></div></td>
<td width="170"><div align="center"><span class="STYLE2"><? echo $row[11];?></span></div></td>
<td width="170"> <div align="center"><span class="STYLE2"><? echo $row[7];?></span></div></td>
<td width="150"> <div align="center"><span class="STYLE2"><? echo $row[12];?></span></div></td>
<td width="40"><div align="center">詳情 </div> <p align="center" ><a href="modify.php?id=<? echo $row[0];?>">修改</a></p></td>
</tr>
<tr>
<td colspan="7" height="3"></td>
</tr>
<?
}
?>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -