001.<html>
002.<head>
003.<title>ThaiCreate.Com PHP & SQL Server (PDO)</title>
004.</head>
005.<body>
006.<?php
007. ini_set('display_errors', 1);
008. error_reporting(~0);
009.
010. $serverName = "localhost";
011. $userName = "sa";
012. $userPassword = "";
013. $dbName = "mydatabase";
014.
015. $conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);
016.
017. $sql = "SELECT count(*) FROM customer";
018. $stmt = $conn->prepare($sql);
019. $stmt->execute();
020.
021. $num_rows = $stmt->fetchColumn();
022.
023. $per_page = 2;
024. $page = 1;
025.
026. if(isset($_GET["Page"]))
027. {
028. $page = $_GET["Page"];
029. }
030.
031. $prev_page = $page-1;
032. $next_page = $page+1;
033.
034. $row_start = (($per_page*$page)-$per_page);
035. if($num_rows<=$per_page)
036. {
037. $num_pages =1;
038. }
039. else if(($num_rows % $per_page)==0)
040. {
041. $num_pages =($num_rows/$per_page) ;
042. }
043. else
044. {
045. $num_pages =($num_rows/$per_page)+1;
046. $num_pages = (int)$num_pages;
047. }
048. $row_end = $per_page * $page;
049. if($row_end > $num_rows)
050. {
051. $row_end = $num_rows;
052. }
053.
054.
055. $sql = " SELECT c.* FROM (
056. SELECT ROW_NUMBER() OVER(ORDER BY CustomerID) AS RowID,* FROM customer
057. ) AS c
058. WHERE c.RowID > $row_start AND c.RowID <= $row_end
059. ";
060. $stmt = $conn->prepare($sql);
061. $stmt->execute();
062.
063.?>
064.<table width="600" border="1">
065. <tr>
066. <th width="91"> <div align="center">CustomerID </div></th>
067. <th width="98"> <div align="center">Name </div></th>
068. <th width="198"> <div align="center">Email </div></th>
069. <th width="97"> <div align="center">CountryCode </div></th>
070. <th width="59"> <div align="center">Budget </div></th>
071. <th width="71"> <div align="center">Used </div></th>
072. </tr>
073.<?php
074.while($result = $stmt->fetch( PDO::FETCH_ASSOC ))
075.{
076.?>
077. <tr>
078. <td><div align="center"><?php echo $result["CustomerID"];?></div></td>
079. <td><?php echo $result["Name"];?></td>
080. <td><?php echo $result["Email"];?></td>
081. <td><div align="center"><?php echo $result["CountryCode"];?></div></td>
082. <td align="right"><?php echo $result["Budget"];?></td>
083. <td align="right"><?php echo $result["Used"];?></td>
084. </tr>
085.<?php
086.}
087.?>
088.</table>
089.<br>
090.Total <?php echo $num_rows;?> Record : <?php echo $num_pages;?> Page :
091.<?php
092.if($prev_page)
093.{
094. echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$prev_page'><< Back</a> ";
095.}
096.
097.for($i=1; $i<=$num_pages; $i++){
098. if($i != $page)
099. {
100. echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
101. }
102. else
103. {
104. echo "<b> $i </b>";
105. }
106.}
107.if($page!=$num_pages)
108.{
109. echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$next_page'>Next>></a> ";
110.}
111.$conn = null;
112.?>
113.</body>
114.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
