marcfielding on No xml returned to grid.

Thu, 26 Jan 2012 00:21:10 +0200

Hi guys,

Right i've figured it all out now, heres the howto for newbies like me when following the wiki tutorial for Mysql and xml datasource.

1) Make sure if your using dreamweaver you dont keep any of the content that DW creates for you when you make a new file, remove all the existing HTML tags so all you have is the stuff between '<?php' and '?>'.

2) there is a typo in the wiki, sortname: 'id', SHOULD BE sortname: 'invid', when setting up the grid(the bit where you do jQuery("#list1").jqGrid({ blah blah

I know these were probably basic mistakes but hopefully it'll help someone.

Cheers

Marc

marcfielding on No xml returned to grid.

Wed, 25 Jan 2012 22:38:40 +0200

EDIT 3: Ok the problem was I was using the standard document that dreamweaver creates so I removed all the HTML tags and now if I do http://findajob.zapto.org/fb/g.....8;sord=ASC

It actually outputs the correct xml ie:

<rows>

<cell>1</cell>
<cell>0000-00-00</cell>
<cell>0.00</cell>
<cell>0.00</cell>
<cell>0.00</cell>
<cell>
<![CDATA[ note ]]>
</cell>

</row>

<cell>2</cell>
<cell>2010-01-01</cell>
<cell>103.98</cell>
<cell>45.34</cell>
<cell>149.32</cell>
<cell>

EDIT 2: If I manually pass params to my php script I get:

This page contains the following errors:
error on line 10 at column 6: XML declaration allowed only at the start of the document
Below is a rendering of the page up to the first error.

Which is <?php

Hello,

I'm new to jqgrid, jquery and PHP althought I do have a decent amount of development experience, I have the following code and it simply returns a blank grid(I dont get a record <num> out of <num> at the bottom right and the NAV bit doesnt appear. sorry for the long code listing but I've noticed people generally dont include enough info so i'm going all in….

This is cut and pasted right out of the WIKI along with the data and the db structure so I cant figure out why its not working.

EDIT: I even got the griddata to output the xml to a textfile and it looks right to me.

Main page is below, griddata.php is at the bottom…

INDEX.PHP

<!doctype html>

<head>

<title>Facebook – FindaJob Test App</title>

$(document).bind('cbox_closed', function() {

window.location.href = 'newuser.php';

});

</script>

<?php

require 'facebook/src/facebook.php';

require_once 'auth.php';

include 'sqlfuncs.php';

include 'testgrid.php';

include 'userfuncs.php';

//session_start();

//3. requesting 'me' to API

$me = null;

if ($session) {

try {

$uid = $facebook->getUser();

$me = $facebook->api('/me');

$newuser = uidisnew($uid);

$_SESSION['fb_session_key'] = $session['session_key']; // store session key

} catch (FacebookApiException $e) {

error_log($e);

}

//4. login or logout

if ($me) {

$logoutUrl = $facebook->getLogoutUrl();

} else {

$loginUrl = $facebook->getLoginUrl();

}

if($newuser==0){

}

else

{

$(document).ready(function(){

$.colorbox({href:"login.html"});

});

</script>

<?php

}

</head>

<body>

<li><a href="#"><span>Logout</span></a></li>

<li class="last"><a href="#"><span>Settings</span></a></li>

<li><a href="#"><span>Search</span></a>

</li>

<div>

<ul>

</ul>

</div>

</li>

</ul>

</div>

</body>

</html>

$(document).ready(function(){

jQuery("#list1″).jqGrid({

url:'griddata.php?q=1',

datatype: "xml",

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

colModel:[

{name:'id',index:'id', width:75},

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

{name:'name',index:'name', width:100},

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

rowNum:10,

autowidth: true,

rowList:[10,20,30],

pager: jQuery('#pager1'),

sortname: 'id',

viewrecords: true,

sortorder: "desc",

caption:"XML Example"

}).navGrid('#pager1',{edit:false,add:false,del:false});

});

</script>

This is the griddata.php that should return the XML(griddata.php)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<?php

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

// we store here username, database and password

ini_set("display_errors",1);

$dbuser='SOMEUSER';

$dbpassword='SOMEPASS';

$dbhost="localhost";

$database='SOMEDB';

// 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'];

// 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 database

$db = mysql_connect($dbhost, $dbuser, $dbpassword)

or die("Connection Error: " . mysql_error());

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

$result = mysql_query("SELECT COUNT(*) AS count FROM invheader a, clients b WHERE a.client_id=b.client_id");

$row = mysql_fetch_array($result,MYSQL_ASSOC);

$count = $row['count'];

if( $count >0 ) {

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

} else {

$total_pages = 0;

}

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

$start = $limit*$page – $limit; // do not put $limit*($page – 1)

$SQL = "SELECT a.id, a.invdate, b.name, a.amount,a.tax,a.total,a.note FROM invheader a, clients b WHERE "

." a.client_id=b.client_id ORDER BY $sidx $sord LIMIT $start , $limit";

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

if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {

header("Content-type: application/xhtml+xml;charset=utf-8″); } else {

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

}

$et = ">";

echo "<?xml version='1.0' encoding='utf-8'?$etn";

echo "<rows>";

echo "<page>".$page."</page>";

echo "<total>".$total_pages."</total>";

echo "<records>".$count."</records>";

// be sure to put text data in CDATA

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

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

echo "<cell>". $row[id]."</cell>";

echo "<cell>". $row[invdate]."</cell>";

echo "<cell><![CDATA[". $row[name]."]]></cell>";

echo "<cell>". $row[amount]."</cell>";

echo "<cell>". $row[tax]."</cell>";

echo "<cell>". $row[total]."</cell>";

echo "<cell><![CDATA[". $row[note]."]]></cell>";

echo "</row>";

}

echo "</rows>";

</body>

</html>

jQuery Grid Plugin - jqGrid - Topic: No xml returned to grid.

marcfielding on No xml returned to grid.

marcfielding on No xml returned to grid.