I want to put pagination in my search result. my code is working but got an error saying:Non-static method Pager::factory( ) should not be called statically in...
This is my code.
This is the error line.
Please help me..
This is my code.
Code:
require_once 'Pager/Pager.php';
$sqlQuery = "select * from vehicles";
$result = mysql_query($sqlQuery);
$totalRows = mysql_num_rows($result);
$pager_options = array(
'mode' => 'Sliding',
'perPage' => 20,
'delta' => 4,
'totalItems' => $totalRows,
);
$pager =Pager::factory($pager_options);
echo $pager->links;
list($from, $to) = $pager->getOffsetByPageId();
$from = $from - 1;
/* The number of rows to get per query */
$perPage = $pager_options['perPage'];
$result = mysql_query("SELECT * FROM vehicles LIMIT $from , $perPage");
echo "<table width=100% align=center>";
echo " <tr height=20 bgcolor=#C0C0C0><td align=center>Vehicle Id</td><td align=center>Vehicle Make</td><td align=center>Vehicle Model</td><td>SELECT</td></tr>";
while($row = mysql_fetch_array($result))
{
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
echo "<tr class=normalText>";
echo "<td> $vehicleId</td>";
echo "<td> $vehicleMake</td>";
echo "<td> $vehicleModel</td>";
echo "<td><a href='javascript:void(0);' onclick=\"LookupVehicle('$vehicleType','$vehicleMake'); return false;\">Select</a></td>";
echo "</tr>";
}
echo "</table>";
Code:
$pager =Pager::factory($pager_options);
Comment