<!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=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
$link = mysql_pconnect("localhost","root","12345") or die(mysql_error());
mysql_select_db("skybook",$link) or die(mysql_error());
mysql_query("SET NAMES UTF8");
?>
<?php
$sql="select * from mybook";
$query=mysql_query($sql) or die(mysql_error());
$num=mysql_num_rows($query);
echo "จำนวนทั้งหมด ".$num." เล่ม<br>";
?>
<table width="1290" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="90"><div align="center">ลำดับ</div></td>
<td width="156"><div align="center">รหัสหนังสือ</div></td>
<td width="288"><div align="center">ชื่อหนังสือ</div></td>
<td width="288"><div align="center">สำนักพิมพ์</div></td>
<td width="288"><div align="center">วันที่พิมพ์</div></td>
<td width="166"><div align="center">จำนวนหนังสือ</div></td>
</tr>
<?php
$i=0;
while($row=mysql_fetch_array($query)){
$i++;
?>
<tr>
<td><div align="center"><?php echo $i; ?></div></td>
<td><div align="left"><?php echo $row["id"]; ?> </div></td>
<td><?php echo $row["bookname"]; ?></td>
<td><?php echo $row["publisher"]; ?></td>
<td><?php echo $row["dateproduct"]; ?></td>
<td><div align="left"><?php echo $row["amount"]; ?> </div></td>
</tr><?php }?>
</table>
</body>
</html>
