[jQuery] Re: jqGrid new version
Ryura, It is a choice of developer. You can do that at server side using PHP(in this case) and at client side using the methods of jqGrid. I have updated the grid and you can find a couple of methods to do that. If you want you can view the new methods. Regards Tony On 22 Окт, 23:20, Ryura [EMAIL PROTECTED] wrote: Thanks Tony. I realized I had forgotten to comment the JSON lines that needed to be commented, and also the Javascript was looking for server.php when it was really example.php. It seems to be working fine now! Great job on everything. This is by far one of the best jQuery plugins yet. I'm not too skilled with PHP, but is there a way I can dynamically decide the rank of a person depending on how many points they have? This is probably irrelevant but you are highly knowledgeable so I though I would ask. Thanks :)
[jQuery] Re: jqGrid new version
Hello: very good work... one info: it is not possible to get the data with a POST ... in the example all are set for a GEt method // get the requested page $page = $_GET['page']; // get how many rows we want to have into the grid // rowNum parameter in the grid $limit = $_GET['rows']; // get index row - i.e. user click to sort // at first time sortname parameter - after that the index from colModel $sidx = $_GET['sidx']; // sorting order - at first time sortorder $sord = $_GET['sord']; it is possible, with a set, to have // get the requested page $page = $_POST['page']; // get how many rows we want to have into the grid // rowNum parameter in the grid $limit = $_POST['rows']; // get index row - i.e. user click to sort // at first time sortname parameter - after that the index from colModel $sidx = $_POST['sidx']; // sorting order - at first time sortorder $sord = $_POST['sord']; Thank you On Oct 7, 3:35 pm, Tony [EMAIL PROTECTED] wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
It can be done. In this case you need to edit code and to change the
ajax call type from GET to POST - i.e:
$.ajax({ url: ts.p.url,type:POST,dataType:xml,data :...).
If you use JSON you need to change $.getJSON with $.ajax the same way,
but do not forget to eval the response with eval.
If you need help please let me known.
Regards
Tony
On 22 Окт, 13:57, Andrea - Aosta [EMAIL PROTECTED] wrote:
Hello: very good work... one info: it is not possible to get the data
with a POST ... in the example all are set for a GEt method
// get the requested page
$page = $_GET['page'];
// get how many rows we want to have into the grid
// rowNum parameter in the grid
$limit = $_GET['rows'];
// get index row - i.e. user click to sort
// at first time sortname parameter - after that the index from
colModel
$sidx = $_GET['sidx'];
// sorting order - at first time sortorder
$sord = $_GET['sord'];
it is possible, with a set, to have
// get the requested page
$page = $_POST['page'];
// get how many rows we want to have into the grid
// rowNum parameter in the grid
$limit = $_POST['rows'];
// get index row - i.e. user click to sort
// at first time sortname parameter - after that the index from
colModel
$sidx = $_POST['sidx'];
// sorting order - at first time sortorder
$sord = $_POST['sord'];
Thank you
On Oct 7, 3:35 pm, Tony [EMAIL PROTECTED] wrote:
I have released a new version of jqGrid.
Demo page here:http://trirand.com/jqgrid/jqgrid.html
Home page:http://www.trirand.com/blog/
Enjoy.
[jQuery] Re: jqGrid new version
Thanks Tony. I realized I had forgotten to comment the JSON lines that needed to be commented, and also the Javascript was looking for server.php when it was really example.php. It seems to be working fine now! Great job on everything. This is by far one of the best jQuery plugins yet. I'm not too skilled with PHP, but is there a way I can dynamically decide the rank of a person depending on how many points they have? This is probably irrelevant but you are highly knowledgeable so I though I would ask. Thanks :)
[jQuery] Re: jqGrid new version
Tony,
I can't seem to get jqGrid to work. I've looked at all the examples
but I must be missing something somewhere. I would appreciate if you
would take a look at my PHP.
include(dbconfig.php);
include(JSON.php);
$json = new Services_JSON();
$examp = $_GET[q];
$page = $_GET['page'];
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
if(!$sidx) $sidx =1;
$db = mysql_connect($dbhost, $dbuser, $dbpassword)
or die(Connection Error: . mysql_error());
mysql_select_db($database) or die(Error conecting to db.);
switch ($examp) {
case 1:
$result = mysql_query(SELECT COUNT(*) AS count FROM scoremain
a);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];
if( $count 0 ) {
$total_pages = ceil($count/$limit);
} else {
$total_pages = 0;
}
if ($page $total_pages) $page=$total_pages;
$start = $limit*$page - $limit; // do not put $limit*($page - 1)
if ($start0) $start = 0;
$SQL = SELECT id, user, score, favgame, rank FROM scoremain
ORDER BY $sidx $sord LIMIT $start , $limit;
$result = mysql_query( $SQL ) or die(Couldn#146;t execute
query..mysql_error());
if ( stristr($_SERVER[HTTP_ACCEPT],application/xhtml+xml) )
{
header(Content-type: application/xhtml+xml;charset=utf-8); }
else {
header(Content-type: text/xml;charset=utf-8);
}
$et = ;
echo ?xml version='1.0' encoding='utf-8'?$et\n;
echo rows;
echo page.$page./page;
echo total.$total_pages./total;
echo records.$count./records;
// be sure to put text data in CDATA
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo row id='. $row[id].';
echo cell. $row[rank]./cell;
echo cell![CDATA[. $row[user].]]/cell;
echo cell. $row[score]./cell;
echo cell![CDATA[. $row[favgame].]]/cell;
echo /row;
}
echo /rows;
break;
case 2:
$result = mysql_query(SELECT COUNT(*) AS count FROM
scoremain);
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];
if( $count 0 ) {
$total_pages = ceil($count/$limit);
} else {
$total_pages = 0;
}
if ($page $total_pages) $page=$total_pages;
$start = $limit*$page - $limit; // do not put $limit*($page - 1)
if ($start0) $start = 0;
$SQL = SELECT id, user, score, favgame, rank FROM scoremain
ORDER BY $sidx $sord LIMIT $start , $limit;
$result = mysql_query( $SQL ) or die(Couldn#146;t execute
query..mysql_error());
$responce-page = $page;
$responce-total = $total_pages;
$responce-records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$responce-rows[$i]['id']=$row[id];
$responce-rows[$i]['cell']=array($row[rank],$row[user],
$row[score],$row[favgame]);
$i++;
}
echo $json-encode($responce);
// coment if php 5
echo json_encode($responce);
break;
}
This is uploaded at http://xeolife.com/dbtest/. Thanks.
[jQuery] Re: jqGrid new version
ads_german, In the demo page (Examples) I have write a step by step example and a easy way of creating json data using PHP. Look on every example - there is a detailed code. Regards Tony On 18 Окт, 16:17, ads_german [EMAIL PROTECTED] wrote: ads_german wrote: I am using php to return a json dataset, and have double checked that the json returned is valid (which it appears to be). Hmm, Seems that json that looked valid must have had some errors in it somewhere - I tried populating the grid via local and xml data and these methods both worked, so for now I'll just stick with xml. Thanks again for a great plugin!! Cheers, Adam. -- View this message in context:http://www.nabble.com/jqGrid-new-version-tf4583212s27240.html#a13272249 Sent from the jQuery General Discussion mailing list archive at Nabble.com.
[jQuery] Re: jqGrid new version
Hi Tony, First of all, I'd like to say this is a great plugin! I am using jqGrid with a json data source, and upon load, the tableheader and pager div appear, but no rows are rendered, and the Loading message stays visible (so Ijust see an empty table and the loading message). Ther are no javascript errors occurring (at least according to the debugger in FireFox) and other query functions and plugins in my project are working. I am using php to return a json dataset, and have double checked that the json returned is valid (which it appears to be). Is there a help forum dedicated to jqGrid that I can search through for tips, or can yourself or someone else here suggest what I might start looking at first to debug this issue? Cheers, Adam. Tony-109 wrote: I have released a new version of jqGrid. Demo page here: http://trirand.com/jqgrid/jqgrid.html Home page: http://www.trirand.com/blog/ Enjoy. -- View this message in context: http://www.nabble.com/jqGrid-new-version-tf4583212s27240.html#a13267951 Sent from the jQuery General Discussion mailing list archive at Nabble.com.
[jQuery] Re: jqGrid new version
ads_german wrote: I am using php to return a json dataset, and have double checked that the json returned is valid (which it appears to be). Hmm, Seems that json that looked valid must have had some errors in it somewhere - I tried populating the grid via local and xml data and these methods both worked, so for now I'll just stick with xml. Thanks again for a great plugin!! Cheers, Adam. -- View this message in context: http://www.nabble.com/jqGrid-new-version-tf4583212s27240.html#a13272249 Sent from the jQuery General Discussion mailing list archive at Nabble.com.
[jQuery] Re: jqDynTabs (was Re: [jQuery] Re: jqGrid new version)
Jack, I will publish it as soon as possible. The plugin need to be refined (better CSS). It can work with 1.2 version of jQuery. Regards Tony On 16 Окт, 23:18, Jack Killpatrick [EMAIL PROTECTED] wrote: Hi Tony, I am interested, for a few reasons: 1. I like the way tabs can be added/removed dynamically 2. It looks like the code does not require jquery 1.2. I have a bunch of sites that I won't be migrating to 1.2 soon, but that I'd like to add some nice tabbing to. FWIW, I've found idTabs really easy to work with, but something about the Tabs plugin seems to trip me up each time, and my understanding is that the version that doesn't use jquery-UI also doesn't allow varied width tabs. I might be wrong, but anyway, I don't think it (pre jquery 1.2 version) supports dynamic add/remove of tabs, either. I'd really like to try your solution. Thx, Jack Tony wrote: Jack, Yes this is my plugin that I never published and use in my project. I do not have published this plugin because there are nice other - Tabs plugin (from Klaus) and idTabs (from Sean) Instead if you are interest I will make some documentation and publish it. Regards On 16 Окт, 19:47, Jack Killpatrick [EMAIL PROTECTED] wrote: Nice work, Tony! While looking at the demos I also noticed the dynamic tabs. Looking at the source, it looks like that might be a project of yours, too. Is there any documentation on that? List of known issues, maybe? Thanks, Jack Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqDynTabs (was Re: [jQuery] Re: jqGrid new version)
Hi Tony, Thanks! By the way, to clarifyone of the reasons it was attractive to me was that it was running on a version of jquery *before* 1.2. The sites I'd be using it with are all running 1.1.x and will not be moving to 1.2 any time soon, so having it *not* require 1.2 would be a positive thing for me (or having it support both 1.1.x and 1.2). - Jack Tony wrote: Jack, I will publish it as soon as possible. The plugin need to be refined (better CSS). It can work with 1.2 version of jQuery. Regards Tony On 16 Окт, 23:18, Jack Killpatrick [EMAIL PROTECTED] wrote: Hi Tony, I am interested, for a few reasons: 1. I like the way tabs can be added/removed dynamically 2. It looks like the code does not require jquery 1.2. I have a bunch of sites that I won't be migrating to 1.2 soon, but that I'd like to add some nice tabbing to. FWIW, I've found idTabs really easy to work with, but something about the Tabs plugin seems to trip me up each time, and my understanding is that the version that doesn't use jquery-UI also doesn't allow varied width tabs. I might be wrong, but anyway, I don't think it (pre jquery 1.2 version) supports dynamic add/remove of tabs, either. I'd really like to try your solution. Thx, Jack Tony wrote: Jack, Yes this is my plugin that I never published and use in my project. I do not have published this plugin because there are nice other - Tabs plugin (from Klaus) and idTabs (from Sean) Instead if you are interest I will make some documentation and publish it. Regards On 16 Окт, 19:47, Jack Killpatrick [EMAIL PROTECTED] wrote: Nice work, Tony! While looking at the demos I also noticed the dynamic tabs. Looking at the source, it looks like that might be a project of yours, too. Is there any documentation on that? List of known issues, maybe? Thanks, Jack Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Jiming, I have updated the plugin so that in multi select mode we can use SHIFT or CTRL or ALT keys. It will be available in the final release Tony On 9 Окт, 05:02, Jiming [EMAIL PROTECTED] wrote: Hi Tony, Great job, thanks! May I suggest that in multiselect, support SHIFT and CTRL, just like GMail does. Which means that you can press SHIFT and select a range of items. Jiming Tony wrote: I have released a new version ofjqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Nice work, Tony! While looking at the demos I also noticed the dynamic tabs. Looking at the source, it looks like that might be a project of yours, too. Is there any documentation on that? List of known issues, maybe? Thanks, Jack Tony wrote: I have released a new version of jqGrid. Demo page here: http://trirand.com/jqgrid/jqgrid.html Home page: http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Tony , in the future it's possible support cell editing.? On Oct 16, 7:28 pm, Tony [EMAIL PROTECTED] wrote: David, Sorry, jqGrid does not support cell editing. On 13 Окт, 20:20, David [EMAIL PROTECTED] wrote: Tony it's possible update one cell (that input text or combo select) from database? On Oct 7, 4:35 pm, Tony [EMAIL PROTECTED] wrote: I have released a new version ofjqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Tony,
If columns can have classes applied to them, then you can allow cell
editing by using jEditable and LiveQuery. The syntax would be real easy
as well:
$(.editable).livequery(function() {
// Inplace Editing...
$( this ).editable(updinv.cfm, {
style : display: inline
});
});
Rey...
Tony wrote:
David,
Sorry, jqGrid does not support cell editing.
On 13 Окт, 20:20, David [EMAIL PROTECTED] wrote:
Tony it's possible update one cell (that input text or combo select)
from database?
On Oct 7, 4:35 pm, Tony [EMAIL PROTECTED] wrote:
I have released a new version ofjqGrid.
Demo page here:http://trirand.com/jqgrid/jqgrid.html
Home page:http://www.trirand.com/blog/
Enjoy.
[jQuery] Re: jqGrid new version
Rey,
Thank you very much for the suggestion. I will try this.
Right now I'm very busy with a finishing a jqGrid 3 plugin.
With success I add another feature hide and show column.
After this release I will add (if possible) editing cell.
Regards
On 16 Окт, 20:30, Rey Bango [EMAIL PROTECTED] wrote:
Tony,
If columns can have classes applied to them, then you can allow cell
editing by using jEditable and LiveQuery. The syntax would be real easy
as well:
$(.editable).livequery(function() {
// Inplace Editing...
$( this ).editable(updinv.cfm, {
style : display: inline
});
});
Rey...
Tony wrote:
David,
Sorry, jqGrid does not support cell editing.
On 13 Окт, 20:20, David [EMAIL PROTECTED] wrote:
Tony it's possible update one cell (that input text or combo select)
from database?
On Oct 7, 4:35 pm, Tony [EMAIL PROTECTED] wrote:
I have released a new version ofjqGrid.
Demo page here:http://trirand.com/jqgrid/jqgrid.html
Home page:http://www.trirand.com/blog/
Enjoy.
[jQuery] Re: jqGrid new version
Jack, Yes this is my plugin that I never published and use in my project. I do not have published this plugin because there are nice other - Tabs plugin (from Klaus) and idTabs (from Sean) Instead if you are interest I will make some documentation and publish it. Regards On 16 Окт, 19:47, Jack Killpatrick [EMAIL PROTECTED] wrote: Nice work, Tony! While looking at the demos I also noticed the dynamic tabs. Looking at the source, it looks like that might be a project of yours, too. Is there any documentation on that? List of known issues, maybe? Thanks, Jack Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] jqDynTabs (was Re: [jQuery] Re: jqGrid new version)
Hi Tony, I am interested, for a few reasons: 1. I like the way tabs can be added/removed dynamically 2. It looks like the code does not require jquery 1.2. I have a bunch of sites that I won't be migrating to 1.2 soon, but that I'd like to add some nice tabbing to. FWIW, I've found idTabs really easy to work with, but something about the Tabs plugin seems to trip me up each time, and my understanding is that the version that doesn't use jquery-UI also doesn't allow varied width tabs. I might be wrong, but anyway, I don't think it (pre jquery 1.2 version) supports dynamic add/remove of tabs, either. I'd really like to try your solution. Thx, Jack Tony wrote: Jack, Yes this is my plugin that I never published and use in my project. I do not have published this plugin because there are nice other - Tabs plugin (from Klaus) and idTabs (from Sean) Instead if you are interest I will make some documentation and publish it. Regards On 16 Окт, 19:47, Jack Killpatrick [EMAIL PROTECTED] wrote: Nice work, Tony! While looking at the demos I also noticed the dynamic tabs. Looking at the source, it looks like that might be a project of yours, too. Is there any documentation on that? List of known issues, maybe? Thanks, Jack Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Tony, it's possible update one cell (that input or combo select) from database ?
[jQuery] Re: jqGrid new version
Tony it's possible update one cell (that input text or combo select) from database? On Oct 7, 4:35 pm, Tony [EMAIL PROTECTED] wrote: I have released a new version ofjqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Hi Tony, Great job, thanks! May I suggest that in multiselect, support SHIFT and CTRL, just like GMail does. Which means that you can press SHIFT and select a range of items. Jiming Tony wrote: I have released a new version of jqGrid. Demo page here: http://trirand.com/jqgrid/jqgrid.html Home page: http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Very good idea Olivier, I will update this in the plugin. Tony On 8 Окт, 02:19, Olivier Percebois-Garve [EMAIL PROTECTED] wrote: Very slick work tony May I suggest to add a loading icon (maybe with status of the queue) ? I have an erratic Internet connection and nothing tells me if the next pane will eventually be loaded. -Olivier Tony wrote: Rey, Thank you for this note. It is my bad. It is corrected now. Tony P.S. The searchdb plugin will be updated soon too. On 7 Окт, 17:59, Rey Bango [EMAIL PROTECTED] wrote: Tony, The link to the searchDB plugin is invalid. (http://www.trirand.com/jqgrid/searchdb.zip) Rey Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Ryura, I know that the documentation describes only options and methods and does not have a detailed step by step guide. About PHP - jqGrid can work not only with PHP (this is just example). It work with any server side language like ASP, CF that can generate XML or JSON data from database. In the demo page there is a full code of every example. Instead I will update the demo pages with detailed comments. Regards Tony On 8 Окт, 02:03, Ryura [EMAIL PROTECTED] wrote: Tony, You've made a nice looking plugin, however the documentation is hard to understand. I'm not sure on how to include a jqGrid onto my site. Would it be possible for you to make a more detailed documentation for those of us who are fairly unfamiliar with PHP?
[jQuery] Re: jqGrid new version
Tony, The link to the searchDB plugin is invalid. (http://www.trirand.com/jqgrid/searchdb.zip) Rey Tony wrote: I have released a new version of jqGrid. Demo page here: http://trirand.com/jqgrid/jqgrid.html Home page: http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Rey, Thank you for this note. It is my bad. It is corrected now. Tony P.S. The searchdb plugin will be updated soon too. On 7 Окт, 17:59, Rey Bango [EMAIL PROTECTED] wrote: Tony, The link to the searchDB plugin is invalid. (http://www.trirand.com/jqgrid/searchdb.zip) Rey Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Very slick work tony May I suggest to add a loading icon (maybe with status of the queue) ? I have an erratic Internet connection and nothing tells me if the next pane will eventually be loaded. -Olivier Tony wrote: Rey, Thank you for this note. It is my bad. It is corrected now. Tony P.S. The searchdb plugin will be updated soon too. On 7 Окт, 17:59, Rey Bango [EMAIL PROTECTED] wrote: Tony, The link to the searchDB plugin is invalid. (http://www.trirand.com/jqgrid/searchdb.zip) Rey Tony wrote: I have released a new version of jqGrid. Demo page here:http://trirand.com/jqgrid/jqgrid.html Home page:http://www.trirand.com/blog/ Enjoy.
[jQuery] Re: jqGrid new version
Tony, You've made a nice looking plugin, however the documentation is hard to understand. I'm not sure on how to include a jqGrid onto my site. Would it be possible for you to make a more detailed documentation for those of us who are fairly unfamiliar with PHP?
