jQuery Grid Plugin - jqGrid - Topic: Problem with "example.php" in documentation http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation Simple:Press Version 5.7.5.3 ssaccone on Problem with "example.php" in documentation http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation#p18208 Bugs http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation#p18208

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!

]]> Fri, 25 Jun 2010 18:18:38 +0300 tony on Problem with "example.php" in documentation http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation#p18183 Bugs http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation#p18183 HEllo,

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

Regards

Tony

]]> Fri, 25 Jun 2010 10:27:21 +0300 ssaccone on Problem with "example.php" in documentation http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation#p18170 Bugs http://www.trirand.com/blog/?page_id=393/bugs/problem-with-example-php-in-documentation#p18170 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.

]]> Fri, 25 Jun 2010 04:48:48 +0300