Location: PHPKode > scripts > Generate Paging > generate-paging/test.php
<?
	//create database test and run given sql file db.sql
	//connect your host
	mysql_connect("localhost");
	//your database name
	mysql_select_db("test");
	include("paging.php");
?>
<html>
<head>
<title>Test Paging</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="stylesheet.css" rel="stylesheet" type="text/css">
</head>
<body>
<?
	$Obj=new Paging("select * from hotel where status='a'");
	$Obj->setLimit(10);
	$limit=$Obj->getLimit();
	$offset=$Obj->getOffset($_GET["page"]);
	$Obj->setParameter("&name=Test&address=India");
	//set link css
	$Obj->setStyle("redheading");
	$Obj->setActiveStyle("smallheading");
	$Obj->setButtonStyle("boldcolor");
?>
<table border="1">
  <?
	$sql="select * from hotel where status='a' order by hotel_name limit $offset,$limit";
	$rs=mysql_query($sql);
	while($row=mysql_fetch_array($rs)) {
?>
  <tr> 
    <td class="bodytext"> 
      <?=$row[hotel_name]?>
    </td>
  </tr>
  <?
	}
?>
</table>
<?
	//get page links
	$Obj->getPageNo();
?>
</body>
</html>
Return current item: Generate Paging