Forum
Topic RSS
Related Topics
12:04
18/04/2010
OfflineHi .. i am a beginner at php and needed some help with jqgrid. I use mysql database and i have set the datatype as xml. I can retrieve data from the databse but I wanted to edit the data as well as perform search functions. I know this has to be implemented using editurl for editing data and server side coding for seaching. I downloaded the jqgridcrud example but they use JSON. Can anyone please point me to a good example for setting up editurl and search functions. Thanks
13:24
Moderators
30/10/2007
OfflineHello,
The grid demo files contain a lot of examples with xml.
Regards
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.
14:23
18/04/2010
OfflineHI thanks for replying...i have already looked through those examples...i still couldn't find anything which could help me write the code for editurl page... they have referred to the page ..(someurl.php) but I want to understand how to pass the values from jqgrid to this page....how to define data for updating etc....can i please get any help with that???? Thanks
09:26
02/06/2010
Offlineirteza said:HI thanks for replying...i have already looked through those examples...i still couldn't find anything which could help me write the code for editurl page... they have referred to the page ..(someurl.php) but I want to understand how to pass the values from jqgrid to this page....how to define data for updating etc....can i please get any help with that???? Thanks
Hi!
Its pretty easy by empiric mode. Make a php file what insert all $_POST and $_GET key/value pairs into a 1 column SQL table or a text file. U will see all passed data by jqgrid.
Try search, edit, del, insert via jqgrid and u will get a passing definition for every action.
<?php
$res = '$_GET:';
foreach ($_GET as $k => $v){
if(is_array($v)){
foreach($v as $k2 => $v2){
$res .= "[".$k2."]=(".$v2.");";
}
}else{
$res .= "[".$k."]=(".$v.");";
}}$res.="$_POST:";
foreach ($_POST as $k => $v){
if(is_array($v)){
foreach($v as $k2 => $v2){
$res .= "[".$k2."]=(".$v2.");";
}
}else{
$res .= "[".$k."]=(".$v.");";
}
}
//connect to sql database and run sql command to write $res//and the sql command something like that//"INSERT INTO tatblaname (fieldname) VALUES ('$res')"
?>
Kind Regards
Most Users Ever Online: 994
Currently Online:
15 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
Log In
Home