jQuery Grid Plugin - jqGridForum

Topic RSS

XML Parsing Error: junk after document element

08/07/2011
20:04

netpumber

Member

Members

Forum Posts: 7

Member Since:
08/07/2011

Offline

Hi… Im tring to create the "myfirst grid" but when im running the script something goes wrong with xml file.

here is the output

XML Parsing Error: junk after document element
Location: http://localhost/SpDatabase/res/grid/
Line Number 62, Column 1:<br />
^

and here is the code of file index.php

http://pastebin.com/cTDyPsyR

What do you think is going wrong ?

Thanks.

08/07/2011
20:50

netpumber

Member

Members

Forum Posts: 7

Member Since:
08/07/2011

Offline

I made two changes and the error changed :

change 1

$sord = $_GET['sord'];

INTO

$sord = 'invid';

change 2

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

INTO

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

The XML error now be this :

XML Parsing Error: junk after document element
Location: http://localhost/SpDatabase/res/grid/
Line Number 62, Column 1:<?xml version='1.0' encoding='utf-8'?><rows><br><page>1</page><total>1</total><records>1</records><row id='1'><cell>1</cell><cell>2001-01-10</cell><cell>103.00</cell><cell>45.00</cell><cell>149.00</cell><cell><![CDATA[This is record 1]]></cell></row></rows>
^

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 994

Currently Online:
11 Guest(s)

Currently Browsing this Page:
1 Guest(s)