21,886
社区成员
发帖
与我相关
我的任务
分享
<body>
<form name="form1" method="post" action="tianjia.php">
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"> <table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="center" bgcolor="#0066FF">
<td>编号 </td>
<td>姓名 </td>
<td>书名 </td>
</tr>
<?
$link=mysql_connect("localhost","book","338160") or die("数据库连接失败".mysql_error());
mysql_select_db("test",$link);
mysql_query("set names gb2312");
$sql=mysql_query("select * from tushu",$link);
if($info=mysql_fetch_array($sql)){
for($nums=0;$nums<count($info);$nums++){
?>
<tr align="center">
<td> <?php echo $info[$nums]['id']; ?> </td>
<td> <? echo $info[$nums]['name']; ?> </td>
<td> <? echo $info[$nums]['bookname']; ?> </td>
</tr>
<?
}
}
$nums=mysql_num_rows($sql);
echo "共有记录".$nums."条";
?>
</table> </td>
</tr>
<tr>
<td width="300"> </td>
<td align="center"> <input name="submit" type="submit" value="添加" /> </td>
</tr>
</table>
</form>
</body>