public static function getConnection() {
if(!isset(self::$conexion)){
//change to your database server/user name/password
self::$conexion = mysqli_connect("localhost", "root", PASSWORD) or
die("Could not connect: " . mysql_error());
//change to your database name
mysqli_select_db(self::$conexion, DATABASE) or
die("Could not select database: " . mysql_error());
}
return self::$conexion;
}
<?php
include_once("../ConnectionManager.php");
header('Content-type:text/javascript;charset=UTF-8');
$json = json_decode(stripslashes($_POST["_gt_json"]));
$pageNo = $json->{'pageInfo'}->{'pageNum'};
$pageSize = 10; //10 rows per page
$conManager = new ConManager();
$conManager->getConnection();
//to get how many records totally.
$sql = "select count(*) as cnt from orders";
$handle = mysql_query($sql);
$row = mysql_fetch_object($handle);
$totalRec = $row->cnt;
//make sure pageNo is inbound
if ($pageNo < 1 || $pageNo > ceil(($totalRec / $pageSize))) {
$pageNo = 1;
}
//page index starts with 1 instead of 0
$sql = "select * from orders limit " . ($pageNo - 1) * $pageSize . ", " . $pageSize;
$handle = mysql_query($sql);
$retArray = array();
while ($row = mysql_fetch_row($handle)) {
