jQuery Grid Plugin - jqGrid

hello,

As i have discovered, posting data to php is not a consistent or intuitive process.

When the grid is initially created or refreshed, the only data posted to php (via postData option) are the following: "_search", "nd", "page", "rows", "sidx" and "sord".  These variables as far as i can remember are only mentioned at the bottom of this link:  http://www.trirand.com/jqgridw.....first_grid .

_search: Will be true if you do a search, false otherwise. If true, you'll also get the "searchfield", "searchoper" and searchstring" for simple searching as well as "filters" for advanced searching.

nd: is a timestamp having to do with an IE problem.

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

rows: get how many rows we want to have into the grid – by default the "rowNum" option parameter defined in the grid.

sidx: get index row – i.e. user click to sort. by default the "sortname" option parameter defined in the grid.  If you select a column to sort, the "sortname" option parameter will be the index name from colModel.

sord: sorting order – by default the "sortorder" option parameter defined in the grid.  Each time you click on a column header, the sort order option parameter will toggle.

The Row ID variable/name (id), Column variables/names and associated parameters are only posted when you initiate an edit, add or delete operation on the grid since you are attempting to modify database tables. During an edit, add or del operation, anything defined in postDATA will not get passed.  When you create or refresh the grid, your only asking for data from the database so jqGrid does not post any column variables/parameters.  Also, I believe what gets posted differs somewhat between edit, add and del.

In any case, this all happens automatically when you initially create the grid, or when you click on the refresh, edit, add or delete buttons in the navigation layer. No other user action is required.

If you need to post other variables and their parameters to php, there are a number of way to do it but i've found that other than passing them through the URL and EDITURL options as parameters, they are tricky to get functioning and the docs don't offer a lot of examples or explaination of the nuances.  The other ways i have found but not been successful at getting to work are: editDATA and delDATA options, editGridRow and delGridRow methods, and the setGridParam method.

I still have not figured out how to get the editDATA and delDATA options to work.

The easiest way to find out what gets posted is to use something like Firebug with Firefox. It allows you to monitor and debug all activity between your browser page and the server script.

good luck.