coolmanlg on Data missing from table. php file is not been called!

Sat, 20 Nov 2010 11:46:57 +0200

I hope this helps some one. I was able to solve the problem by passing the query string to the url: e.g.

url: "example.php?page=1&start=0&rows=10&sidx=1&sord=desc",

This was not obvious in the example documentation.

coolmanlg on Data missing from table. php file is not been called!

Sat, 20 Nov 2010 03:52:04 +0200

I have been trying to debug the problem using firebug and in I saw the url is set to "http://localhost/jgrid/jgrid.html" instead of "example.php" How do I change this please?

coolmanlg on Data missing from table. php file is not been called!

Fri, 19 Nov 2010 15:26:00 +0200

Hell all,

I have downloaded the plugin and followed the setup instructions but it doesn't connect to the php file hence the table is empty without data.

Html file:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<style>

html, body {

margin: 0;

padding: 0;

font-size: 75%;

}

</style>

$(function(){

$("#list").jqGrid({

datatype: 'xml',

url:'example.php',

mtype: 'GET',

colNames:['Inv No','Date', 'Amount','Tax','Total','Notes'],

colModel :[

{name:'invid', index:'invid', width:55},

{name:'invdate', index:'invdate', width:90},

{name:'amount', index:'amount', width:80, align:'right'},

{name:'tax', index:'tax', width:80, align:'right'},

{name:'total', index:'total', width:80, align:'right'},

{name:'note', index:'note', width:150, sortable:false}

pager: '#pager',

rowNum:10,

rowList:[10,20,30],

sortname: 'invid',

sortorder: 'desc',

viewrecords: true,

caption: 'My first grid'

});

</script>

</head>

<body>

</body>

</html>

PHP file:

<?php

//include the information needed for the connection to MySQL data base server.

// we store here username, database and password

include("dbconfig.php");

// to the url parameter are added 4 parameters as described in colModel

// we should get these parameters to construct the needed query

// Since we specify in the options of the grid that we will use a GET method

// we should use the appropriate command to obtain the parameters.

// In our case this is $_GET. If we specify that we want to use post

// we should use $_POST. Maybe the better way is to use $_REQUEST, which

// contain both the GET and POST variables. For more information refer to php documentation.

// Get the requested page. By default grid sets this to 1.

$page = $_GET['page'];

// get how many rows we want to have into the grid - rowNum parameter in the grid

$limit = $_GET['rows'];

echo $limit;

// get index row - i.e. user click to sort. At first time sortname parameter -

// after that the index from colModel

$sidx = $_GET['sidx'];

// sorting order - at first time sortorder

$sord = $_GET['sord'];

// if we not pass at first time index use the first column for the index or what you want

if(!$sidx) $sidx =1;

// connect to the MySQL database server

$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error());

// select the database

mysql_select_db($database) or die("Error connecting to db.");

// calculate the number of rows for the query. We need this for paging the result

$result = mysql_query("SELECT COUNT(*) AS count FROM invheader");

$row = mysql_fetch_array($result,MYSQL_ASSOC);

$count = $row['count'];

// calculate the total pages for the query

if( $count > 0 && $limit > 0) {

$total_pages = ceil($count/$limit);

} else {

$total_pages = 0;

}

// if for some reasons the requested page is greater than the total

// set the requested page to total page

if ($page > $total_pages) $page=$total_pages;

// calculate the starting position of the rows

$start = $limit*$page - $limit;

// if for some reasons start position is negative set it to 0

// typical case is that the user type 0 for the requested page

if($start <0) $start = 0;

// the actual query for the grid data

$SQL = "SELECT invid, invdate, amount, tax,total, note FROM invheader ORDER BY $sidx $sord LIMIT $start , $limit";

echo $SQL;

$result = mysql_query( $SQL ) or die("Couldn't execute query.".mysql_error());

// we should set the appropriate header information. Do not forget this.

header("Content-type: text/xml;charset=utf-8");

$s = "<?xml version='1.0' encoding='utf-8'?>";

$s .= "<rows>";

$s .= "<page>".$page."</page>";

$s .= "<total>".$total_pages."</total>";

$s .= "<records>".$count."</records>";

// be sure to put text data in CDATA

while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

$s .= "<row id='". $row['invid']."'>";

$s .= "<cell>". $row['invid']."</cell>";

$s .= "<cell>". $row['invdate']."</cell>";

$s .= "<cell>". $row['amount']."</cell>";

$s .= "<cell>". $row['tax']."</cell>";

$s .= "<cell>". $row['total']."</ceecho phpinfo()ll>";

$s .= "<cell><![CDATA[". $row['note']."]]></cell>";

$s .= "</row>";

}

$s .= "</rows>";

What did I miss please?

jQuery Grid Plugin - jqGrid - Topic: Data missing from table. php file is not been called!

coolmanlg on Data missing from table. php file is not been called!

coolmanlg on Data missing from table. php file is not been called!

coolmanlg on Data missing from table. php file is not been called!