jQuery Grid Plugin – jqGrid

Whether it is possible to draw a conclusion of data from MySQL, but the usual table, that it was possible to make the reference to editing to other file in the next cell of the table, for example:

//while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
//
//
//
//$row[user_id];
//
//
//$row[user_name];
//

//
//
//

//
//
//}

???? And how? Please help! Very need! Sorry for prevision post!

Thank you, Tony!

Whether it is possible to draw a conclusion of data from MySQL, but the usual table, that it was possible to make the reference to editing to other file in the next cell of the table, for example:


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

}


???? And how? Please help! Very need!

Thank you, Tony!

Whether it is possible to draw a conclusion of data from MySQL, but the usual table, that it was possible to make the reference to editing to other file in the next cell of the table, for example:

[code]
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

$row[user_id];
$row[user_name];

Edit

}
[/code]

???? And how? Please help! Very need!

Thank you, Tony!

Whether it is possible to draw a conclusion of data from MySQL, but the usual table, that it was possible to make the reference to editing to other file in the next cell of the table, for example:

Sorry, but I cant attach normal code. I shall try to make it having replaced in a code Edit[/a]
[/td]

[/tr]
[/table]

}

???? And how? Please help! Very need!

Thank you, Tony!

Whether it is possible to draw a conclusion of data from MySQL, but the usual table, that it was possible to make the reference to editing to other file in the next cell of the table, for example:

Sorry, but I cant attach normal code. I shall try to make it having replaced in a code Edit[//a]
[//td]

[//tr]
[//table]

}

???? And how? Please help! Very need! Sorry for spam, please!

Thank you, Tony!

Whether it is possible to draw a conclusion of data from MySQL, but the usual table, that it was possible to make the reference to editing to other file in the next cell of the table, for example:

Sorry, but I cant attach normal code. I shall try to make it having replaced in a code Edit[//a]
[//td]

[//tr]
[//table]

}

???? And how? Please help! Very need!

Tony, sory for this spam. But I need some help. Can I send my code to your e-mail? In advanced thanks.

Really nice plugin Tony. Following are some observations.

1. In createEl and el is checkbox, due to bug in IE I added elem.defaultChecked = true; after elem.checked = true; see: http://channel9.msdn.com/wiki/ default.aspx/Channel9.InternetExplorerProgrammingBugs under Dynamic Checkboxes Unchecked.

2. In saveRow and edittype is checkbox, old value is posted to server (new is shown on browser). Somwhere around line 305 I added:

if( $t.p.colModel[i].hidden===true) tmp[nm] = $(this).html();
else if( $t.p.colModel[i].edittype===’checkbox’) tmp[nm]= $(“input”,this).attr(“checked”) ? 1 : 0
else tmp[nm ….

3. IMO, callback in editRow is useless as is called at the end of editRow() function, so it can be called by appli program after editRow with the same effect, if needed. However, after the end of user edit process there should be a callback, so I defined onEditDone(success, rowId) public member, which is called at the start of saveRow() and restoreRow() functions.

4. I integrated colorpicker to jqGrid. I use two columns, one hidden, editable / not editable to hold hex color value and another not editable, where the backgroud is changed according to user selection. When the edit is done by the user the onEditDone (see 3) is fired to repair value of first column (if edit succeeded) or restore backgroud color, if edit failed. Problem arouse when posting value of the first (hidden) column to server. Column one should be hidden. If editable, its value is spoiled by saveRow function, if not editable its value is not sent to server at all. I added condition && !$t.p.colModel[i].hidden in two if statements around lines 320 and 365 (where you check if subgrid etc..), so the value of column is changed when editable but not hidden, much the same as hidden form input when submitting form.

Anyway, wonderful plugin and HNY 2008.

In fact there are two callbacks needed.

First to perform client side verification. onEditDone(success, rowID) can do that.
Second after server side verification (when Ajax done), one can name it onSaveDone(success, response), jqGrid allready has it under different name, but not publicly accessible.

Hi there!

Im amazed for the capabilities of your script. Awesome!

But I cant integrate it, I just dont know how to… Could you help me? I want to use the Bigset but I’ve tried, I cant get it.

Please, help

Hi there! … again.

I’ve did it!

Its amazing, dude. Congrats, but there’is something I need to and I cant:

I’ve created a select input, but when the query is sent, the select value isn’t queried.

I’ve modified the bigset.js adding the variable to the url in get method, but the grid stops and no data is loaded after.

How could I integrate the select input to work with the script and with autoseach?

Ariel,
Maybe you should use onchange event. Something like this:


HTML
<select name="cars" onchange="searchme(this.value)">
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="fiat">Fiat</option>
<option value="audi">Audi</option>
</select>

The Javascript
function searchme(svalue)
{
if (svalue)
{
jQuery("mygrid").setUrl("mysearchpage.php?sval="+svalue);
jQuery.("mygrid").trigger("reloadGrid");
}
}


}

two tables are bad ! layout is not in control!

Great plug-in!

I can’t get the save row working on pressing Enter as with Row Editing Using Callback example. Server script does not get called and row stays selected. Any suggestions for where to look?

Thanks!

HS

Hi Tony,

Thanks, for the help. I was not getting data from $_POST correctly, now it works.

Cheers!

Tony,
I don’t know the colNames before I get the data from the server.
How an I use the plugin instead of this:

jQuery(“#list2”).jqGrid({ url:’server.php?q=2&nd=’+new Date().getTime(), datatype: “json”, colNames:[‘Inv No’,’Date’, ‘Client’, ‘Amount’,’Tax’,’Total’,’Notes’], colModel:[
….

Thanks
Antonio

Hi Antonio,
Currently this is not possible. The upcoming release will give you the possibility to write your own extension to do that.
One possible solution is:
Write your own ajax call to obtain the names, before constructing the grid and fill the colNames array with this values.
The very important note here is that this ajax call should be with option async:false.

Regards
Tony

Hi there, still loving jqgrid! So thanks for that. My question is: is it possible to display images from a field containing image source urls? e.g. a field called image may contain data such as http://www.somesite.com/images/someimage.jpg or maybe just someimage.jpg with a default local image path.

Any help would be gratefully appreciated.
Cheers
Alan

hi tony, very impressed with jqGrid! One bug i have found in testing: the custom multi select does not work in safari v3.0.4. Cheers, tony

Hi Tony.. congratulation.. your plugin is amazing!!!

I have a question to you..

I realized that in the method delRowData, i can remove row by id, that’s the same i passed in json data.

But i can´t show id on dataGrid, and i need to manipulate data. Do you know how can i do???

Thanks

Pedro.

Hi Tony!
Super plugin!
I’m currently customizing it for one of the projects i work on.
I have lots of suggestions for you, mainly concerning the behaveiour of the grid, adding more flexibility, autowidth, autoheight, resizing the whole grid by mouse drag, etc :D. I’ll come back to my suggestions later, when I’m done customizing 🙂

But for now I have a question: In the jqGrid 2.0rc release you mentioned you would add a ‘setWidth’ method to dynamically adjust the width of the grid.
Is it possible to do that now? I haven’t seen the ‘setWidth’ method.
If not, maybe you could suggest me what methods to use to achieve this functionality. I’ll be glad to share the code afterwards.

I wrapped the whole grid in a resizable div (jQuery.interface) and I’m trying to get the grid to resize along with this wrapper div. I found that by adding ‘height:false’ it automatically adjusts to the divs height (though the pager is outside the div), Now i would like to also adjust the width of the grid. Interface resizeble has an ‘onResize’ handler so all i need to do is call the ‘jqGrid.setWidth’ method, when it will exist… 🙂

PS: My first sugestion would be for you to wrap the whole grid in a wrapper div. 🙂

PS2: I’ve followed the development of jqGrid from start. Super work! It became very fast the (probably) most complete grid solution for jQuery. Nice work!

Hi,

Nice work!
With xml everything is working well but with php and mysql I get a error.
Searched the internet but couldn’t find a solution.
Error:
Couldn t execute query.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1

Any help will be appreciated.

Hi,

Really nice work.

Having some issues with delRowData needed to add:

if (success) {
var t = this
t.p.records–;
}

Because it’s not decrementing the total number of rows. Is it the correct approach?

Regards,
Guille

BUG?

when there are two grid in a page, the second grid’s pager data(record no), will as same as the first one.

I am sorry about that, it seem to be my mistake.

Since I use a json_encode’d string to initialize the grid, some properties, like the pager I could not set, therefore I added the following lines after the definition of $.fn.jqGrid. Perhaps an idea for a next version to keep configuration serializable? Nice work, btw!

if (typeof p.pager == “string”) {
p.pager = jQuery(p.pager);
}

thank you