📄 show.php

📁 php +mysql+apeach实现在线通讯录。功能：添加

💻 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 + -