How to use PHP & Access (odbc) and Paging/Pagination This is tutorial php developers how to using PHP get data from microsoft access database and display result of multiple pages to pagination.
ShotDev Focus:
- PHP & Microsoft Access list data and pagination.
Example
php_access_pagination.php
- <html>
- <head>
- <title>ShotDev.Com Tutorial</title>
- </head>
- <body>
- <?
- $objConnect = odbc_connect("mydatabase","","");
- $strSQL = "SELECT * FROM customer ORDER BY CustomerID ASC";
- $objExec = odbc_exec($objConnect, $strSQL) or die ("Error Execute [".$strSQL."]");
- $Num_Rows = 0;
- while(odbc_fetch_row($objExec))$Num_Rows++; // Count Record
- $Per_Page = 2; // Per Page
- $Page = $_GET["Page"];
- if(!$_GET["Page"])
- {
- $Page=1;
- }
- $Prev_Page = $Page-1;
- $Next_Page = $Page+1;
- $Page_Start = (($Per_Page*$Page)-$Per_Page)+1;
- if($Num_Rows<=$Per_Page)
- {
- $Num_Pages =1;
- }
- else if(($Num_Rows % $Per_Page)==0)
- {
- $Num_Pages =($Num_Rows/$Per_Page) ;
- }
- else
- {
- $Num_Pages =($Num_Rows/$Per_Page)+1;
- $Num_Pages = (int)$Num_Pages;
- }
- $Page_End = $Per_Page * $Page;
- if($Page_End > $Num_Rows)
- {
- $Page_End = $Num_Rows;
- }
- ?>
- <table width="600" border="1">
- <tr>
- <th width="91"> <div align="center">CustomerID </div></th>
- <th width="98"> <div align="center">Name </div></th>
- <th width="198"> <div align="center">Email </div></th>
- <th width="97"> <div align="center">CountryCode </div></th>
- <th width="59"> <div align="center">Budget </div></th>
- <th width="71"> <div align="center">Used </div></th>
- </tr>
- <?
- for($i=$Page_Start;$i<=$Page_End;$i++)
- {
- $objResult = odbc_fetch_array($objExec,$i);
- ?>
- <tr>
- <td><div align="center"><?=$objResult["CustomerID"];?></div></td>
- <td><?=$objResult["Name"];?></td>
- <td><?=$objResult["Email"];?></td>
- <td><div align="center"><?=$objResult["CountryCode"];?></div></td>
- <td align="right"><?=$objResult["Budget"];?></td>
- <td align="right"><?=$objResult["Used"];?></td>
- </tr>
- <?
- }
- ?>
- </table>
- <br>
- Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
- <?
- if($Prev_Page)
- {
- echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
- }
- for($i=1; $i<=$Num_Pages; $i++){
- if($i != $Page)
- {
- echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
- }
- else
- {
- echo "<b> $i </b>";
- }
- }
- if($Page!=$Num_Pages)
- {
- echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
- }
- odbc_close($objConnect);
- ?>
- </body>
- </html>
Create a php file and save to path root-path/myphp/
Run
http://localhost/myphp/php_access_pagination.php
Screenshot
1carolina…
…