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)) {