PHP? ?? ??? ???? ?? ??? ?? ?? ?? ???? ?????.

? ???? ?? ???? ?? ?? ?? "?? ??" ?? ???? ????.

<table>? ???? ??? ?? ? ???? ?? ?? ??? ???? ??? ? ? ????. ??? <tr>????? ?? CSS ???? ??? ??????.

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table">
<tr>
<td height="27" colspan="2" align="left" bgcolor="#FFFFFF" class="bg_tr">&nbsp;后臺(tái)管理&nbsp;>>&nbsp;圖書統(tǒng)計(jì)</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF" height="27">圖書類別</td>
<td align="center" bgcolor="#FFFFFF">庫(kù)內(nèi)圖書</td>
</tr>
</table>

SQL ? ??? ?? ??? ?????

??? COUNT(*) ??? ???? ???? ??? ?? ?????.

GROUP BY ?? ?? ??? ?? ???? ?? ??? ?? ???? ?? ??? ??????.

?? ??? ????? ?? ??? ?????.

<?php
$SQL = "SELECT type, count(*) FROM yx_books group by type";
?>

????? while ??? ???? ???????? ??? ???? ?????

<?php
$SQL = "SELECT type, count(*) FROM yx_books group by type";
$val=mysqli_query($link,$sql);
while($arr=mysqli_fetch_row($val)){
   echo "<tr height='30'>";
   echo "<td align='center' bgcolor='#FFFFFF'>".$arr[0]."</td>";
   echo "<td align='center' bgcolor='#FFFFFF'>本類目共有：".$arr[1]."&nbsp;種</td>";
   echo "</tr>";
}
?>

??:

mysql_fetch_row() ??? ?? ???? ?? ??? ?? ?????.

?? ?: ?? ?? ???? ??? ??? ????? ? ?? ?? ??? false? ?????.

???? ??

??? ??

<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PHP圖書管理系統(tǒng)圖書統(tǒng)計(jì)</title> <style> .table{ border: 1px solid #CAF2FF;/*邊框顏色*/ margin-top: 5px; margin-bottom: 5px; background:#a8c7ce; } .td_bgf { background:#d3eaef; color:#000000; } .td_bg { background:#ffffff; color:#344b50; } .bg_tr { font-family: "微軟雅黑,Verdana, 新宋體"; color:#e1e2e3;/*標(biāo)題字體色*/ font-size:12px; font-weight:bolder; background:#353c44;/*標(biāo)題背景色*/ line-height: 22px; } td { color:#1E5494; font-size:12px; line-height: 18px; } </style> </head> <body> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC" class="table"> <tr> <td height="27" colspan="2" align="left" bgcolor="#FFFFFF" class="bg_tr"> 后臺(tái)管理 >> 圖書統(tǒng)計(jì)</td> </tr> <tr> <td align="center" bgcolor="#FFFFFF" height="27">圖書類別</td> <td align="center" bgcolor="#FFFFFF">庫(kù)內(nèi)圖書</td> </tr> </table> </body> </html>

?????? ???

????