I was trying this code to use adodb library for php. The grid doesnt show me anything.
Neither with XML or JSON.
Someone can tell me what i'm doing wrong?
include('adodb5/adodb.inc.php');
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$page = $_GET['page']; // get the requested page
$limit = $_GET['rows']; // get how many rows we want to have into the grid
$sidx = $_GET['sidx']; // get index row – i.e. user click to sort
$sord = $_GET['sord']; // get the direction
if(!$sidx) $sidx =1;
// connect to the database
$db = ADONewConnection('mysql'); # eg 'mysql' or 'postgres'
$db->debug = true;
$db->Connect('localhost', 'root', 'admin', 'jQgrid_demos');
$row = $db->GetRow(“SELECT COUNT(*) AS count FROM invheader a, clients b WHERE a.client_id=b.client_id”);
$count = $row['count'];
if( $count > 0 ) {
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top