<html>
<head>
<title>PHP example</title>
</head>
<body>
<?php
if (isset($_GET[’pageno’])) $CurPage = $_GET[’pageno’]; else $CurPage = 1;
$conn = new COM(’ADODB.Connection’);
$conn->Open(”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=”.getcwd().”\Northwind.mdb”);
$sqlQ = ‘SELECT ProductName, QuantityPerUnit, UnitPrice FROM Products ORDER BY ProductName’;
$rds = new COM(’ADODB.Recordset’);
$rds->Open($sqlQ,$conn,1);
$rowcount = 0;
$TotalRec=$rds->RecordCount;
$RecPerPage=10;
$MaxPage=(int) ($TotalRec/$RecPerPage)+1;
if($CurPage<1) $CurPage=1;
if($CurPage>$MaxPage) $Curpage=$MaxPage;
$CurRec=($CurPage-1)*$RecPerPage;
?>
<table border=”1” cellpadding=”3” cellspacing=”0”>
<tr>
<th>Product Name</th>
<th>Quantity Per Unit</th>
<th>Unit Price</th>
</tr>
<?php
$RowCnt=0;
$rds->Move($CurRec);
while (!$rds->EOF && $RowCnt<10) { ?>
<tr>
<td><?php echo $rds->Fields[’ProductName’]->Value ?>
</td>
<td><?php echo $rds->Fields[’QuantityPerUnit’]->Value ?>
</td>
<td><?php echo $rds->Fields[’UnitPrice’]->Value ?>
</td>
</tr>
<?php $rds->MoveNext();$RowCnt++; ?>
<?php } ?>
</table>
<?php
if($CurPage!=1){
echo “<a href=’nwind.php?pageno=” . ($CurPage-1) . “’>Previous page</a> ”;
}
if($CurPage!=$MaxPage){
echo “ <a href=’nwind.php?pageno=” . ($CurPage+1) . “’>Next page</a>”;
}
$rds->Close();
$conn->Close();
$rds = null;
$conn = null;
?>
</body>
</html>