<STYLE TYPE="text/css">
table { page-break-after: always }
</STYLE>
<?
mysql_connect("localhost","","");
mysql_select_db("mydb");
$rs = mysql_query("select * from book limit 0,120;");
gethtml($rs);
mysql_free_result($rs);
mysql_close();
?>
<A HREF="BLOCKED SCRIPTwindow.print();"> Print </A>
<?
function gethtml($rs)
{
$i=1;
while ($cols = mysql_fetch_array($rs)){
if($i==1){
echo "<H2> EX104.php </H2><br>";
echo "<H3> Book Report </H3><br>";
echo "<table border='1' ";
echo "<tr>";
echo "<td align ='center' bgcolor='#fff000'>id</td> ";
echo "<td align ='center' bgcolor='#fff000'>barcode </td> ";
echo "<td align ='center' bgcolor='#fff000'>Book name </td> ";
echo "<td align ='center' bgcolor='#fff000'>author </td> ";
echo "<td align ='center' bgcolor='#fff000'>page no</td> ";
echo "<td align ='center' bgcolor='#fff000'>type </td> ";
echo "<td align ='center' bgcolor='#fff000'>year </td> ";
echo "</tr>";
} // end if
$b++; // กำหนดให้ line มันขึ้นแบบต่อเนื่องได้
echo "<tr>";
echo "<td>$b </td> ";
echo "<td>$cols[0] </td> ";
echo "<td>$cols[1] </td> ";
echo "<td>$cols[2] </td> ";
echo "<td>$cols[3] </td> ";
echo "<td>$cols[4] </td> ";
echo "<td>$cols[5] </td> ";
echo "</tr>";
$i++;
if($i ==30){
echo "</table>";
$i=1;
} //end if
} // end while
} //end function
?>
Enter your message below
Sign in or Join us (it's free).