01.<?php
02.@mysql_connect("localhost", "root", "admin") or die("Not Connected");
03.@mysql_select_db("fuku2nd") or die("Not Correct");
04.function paging_start_row($current_page,$rows_per_page){
05.}
06.function paging_total_pages($total_rows, $rows_per_page){
07.}
08.function paging_pagenum($current_page,$total_pages,$page_range,$query_string){
09.}
10.$current_page = 1;
11.if(isset($_GET['page'])){
12.}
13.$rows_per_page = 5;
14.$start_row = paging_start_row($current_page, $rows_per_page);
15.$sql = "SELECT SQL_CALC_FOUND_ROWS 8 FROM product
16.LIMIT $start_row, $rows_per_page;";
17.
18.$result = mysql_query($sql);
19.$found_rows = mysql_query ("SELECT FOUND_ROWS();");
20.$total_rows = mysql_result($found_rows,0,0);
21.
22.if ($total_rows == 0){
23. echo "<caption><b>ไม่พบสินค้า</b></caption>";
24.}
25.else {
26. $stop_row = paging_stop_row($start_row,$rows_per_page,$total_rows);
27. echo"<caption><b>รายการสินค้าลำดับที่: ".($start_row + 1).
28. " - " . "$stop_row จากทั้งหมด $total_rows</b></caption>";
29.}
30.while($p = mysql_fetch_array($result)) {
31. $id = $p['pro_id'];
32. $descr = substr ($p['description'] , 0 , 80) . " . . . " ;
33. echo "
34. <tr valign=top>
35. <td rowspan=2 width=60 align=center>
36. <img width=50 src=read_image.php?id=$id/>
37. </td>
38. <td colspan=2>
39. <a href=product_detail.php?id=$id>
40. <b>{$p['pro_name']}</b></a><br/>
41. $descr
42. </td>
43. </tr>
44. <tr valign=bottom>
45. <td>
46. ราคา : {$p['price']} บาท
47. </td>
48. <td align=right>
49. <input type=button value=หยิบใส่รถเข็น class=add_cart
50. onclick=\"addCart($id)\"/>
51. </td>
52. </tr>
53. <tr><td colspan=3 class=line_dot> </td></tr>";
54.}
55.?>
56.
57. </table>
58. <p align="center">
59. <?php
60. $page_range= 5;
61. $qry_str="";
62. $total_pages = paging_total_pages($total_rows,$rows_per_page);
63. $pagenum = paging_pagenum($current_page, $total_pages, $page_range, $qry_str);
64. echo "หน้า: " .$pagenum
65. ?>
66. </td>
67. <td width="261" bgcolor="#CCCCCC" id="cart">
68. <script> readCart();</script>
69. </td>
70. </tr>
71.</table>
72.</body>
