index.php

来自「php 一般代码 还是不错的东西 我就贡献这么多了 别建议」· PHP 代码 · 共 46 行

<?php
 include ("conn.php")
 ?>

<?
$SQLStr = "SELECT * FROM list order by id desc";
	$res = mysql_query($SQLStr);
	
?>
<style type="text/css">
<!--
.STYLE3 {color:#0000FF; font-size: 12px; }
.STYLE6 {color: #333333; font-size: 14; }
-->
</style>


<div align="center">
  <p><a href="add.php">我要添加数据</a></p>
  <table width="691" height="19" border="1" cellpadding="1" cellspacing="0">
  <tr>
    <td width="125" height="17" class="STYLE3"><div align="center" class="STYLE6">id</div></td>
    <td width="112" class="STYLE3"><div align="center" class="STYLE6">name</div></td>
    <td width="105" class="STYLE3"><div align="center" class="STYLE6">qq</div></td>
    <td width="89" class="STYLE3"><div align="center" class="STYLE6">content</div></td>
    <td width="92" class="STYLE3"><div align="center" class="STYLE6">time</div></td>
  </tr>
 <? $num = mysql_num_rows($res);
 
   
  while($row = mysql_fetch_array($res))
 
   {
   
  echo"<tr>";
   echo "<td>&nbsp;"  .$row['id']."</td>";
 echo   "<td>&nbsp;" .$row['name']."</td>";
   echo "<td>&nbsp;" .$row['qq']."</td>";
  echo "<td>&nbsp;" .$row['content']."</td>";
   echo "<td>&nbsp;" .$row['time']."<a href=del.php?id=".$row['id'].">del <td> <a href=message_change.php?id=".$row['id'].">edit</td>";
  echo"</tr>";
  }
  ?>
</table>
</div>