jQuery Grid Plugin - jqGridForum

Topic RSS

Problem with "example.php" in documentation

25/06/2010
04:48

ssaccone

Member

Members

Forum Posts: 5

Member Since:
25/06/2010

Offline

I found that example.php at

/jqgridwiki/doku.php?id=wiki:first_grid would not work unless I quoted the MySQL column names in expressions like $s .= "<cell>". $row[invid]."</cell>" - use $row["invid"] instead. Otherwise it causes an error in PHP, and the table will display with no data.

25/06/2010
10:27

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

HEllo,

Download the demo and use this one. Copy Paste is not recommended

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

25/06/2010
18:18

ssaccone

Member

Members

Forum Posts: 5

Member Since:
25/06/2010

Offline

tony said:

HEllo,

Download the demo and use this one. Copy Paste is not recommended

Regards

Tony

Perfect, I located the example code in the downloads section. Is this what you were referring to? It's nice to have the html, js, php & mysql dumps all in one place.

However, I believe the same problem exists in these files. I can install these files on my server and view the "Array Data" example, but examples calling mysql show no data in the table. PHP reports errors like this:

PHP Notice: Use of undefined constant note - assumed 'note' in /var/www/html/js-ex/jqGrid/jqgrid_demo/server.php on line 157

And that line is:

$responce->rows[$i]['cell']=array($row[id],$row[invdate],$row[name],$row[amount],$row[tax],$row[total],$row[note]);

I think you need quotes around the MySQL column names, at least for my version of PHP which is 5.1.6. There is more information on PHP & quoting array keys here.

Thanks!

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
34 Guest(s)

Currently Browsing this Page:
1 Guest(s)