01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
04.</head>
05.<body>
06.<form name="frmMain1" action="" method="post">
07.<?
08.$objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
09.$objDB = mysql_select_db("mydatabase");
10.$strSQL = "SELECT * FROM customer ";
11.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
12.$Num_Rows = mysql_num_rows($objQuery);
13.
14.$Per_Page = 5;
15.
16.$Page = $_GET["Page"];
17.if(!$_GET["Page"])
18.{
19. $Page=1;
20.}
21.
22.$Prev_Page = $Page-1;
23.$Next_Page = $Page+1;
24.
25.$Page_Start = (($Per_Page*$Page)-$Per_Page);
26.if($Num_Rows<=$Per_Page)
27.{
28. $Num_Pages =1;
29.}
30.else if(($Num_Rows % $Per_Page)==0)
31.{
32. $Num_Pages =($Num_Rows/$Per_Page) ;
33.}
34.else
35.{
36. $Num_Pages =($Num_Rows/$Per_Page)+1;
37. $Num_Pages = (int)$Num_Pages;
38.}
39.
40.$strSQL .=" order by CustomerID ASC LIMIT $Page_Start , $Per_Page";
41.$objQuery = mysql_query($strSQL);
42.?>
43.<table width="600" border="1">
44. <tr>
45. <th width="91"> <div align="center">No </div></th>
46. <th width="91"> <div align="center">CustomerID </div></th>
47. <th width="98"> <div align="center">Name </div></th>
48. <th width="198"> <div align="center">Email </div></th>
49. <th width="97"> <div align="center">CountryCode </div></th>
50. <th width="59"> <div align="center">Budget </div></th>
51. <th width="71"> <div align="center">Used </div></th>
52. </tr>
53.<?
54.$no = 0;
55.if($Page > 1)
56.{
57. $no = $Per_Page * $Page;
58.}
59.while($objResult = mysql_fetch_array($objQuery))
60.{
61. $no++;
62.?>
63. <tr>
64. <td><div align="center"><?=$no;?></div></td>
65. <td><div align="center"><?=$objResult["CustomerID"];?></div></td>
66. <td><?=$objResult["Name"];?></td>
67. <td><?=$objResult["Email"];?></td>
68. <td><div align="center"><?=$objResult["CountryCode"];?></div></td>
69. <td align="right"><?=$objResult["Budget"];?></td>
70. <td align="right"><?=$objResult["Used"];?></td>
71. </tr>
72.<?
73.}
74.?>
75.</table>
76.
77.<br>
78.Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
79.<select name="ddlPage">
80.<?
81.for($i=1; $i<=$Num_Pages; $i++){
82.?>
83.}
84.<option value="<?=$i;?>" <?if($Page==$i){echo "selected";}?>><?=$i;?></option>
85.<?
86.}
87.?>
88.</select>
89.<input type="button" name="OK" value="OK" OnClick="javascript:window.location='?Page='+document.frmMain1.ddlPage.value;">
90.<?
91.mysql_close($objConnect);
92.?>
93.</form>
94.</body>
95.</html>
