Forum

July 12th, 2025
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
setting editurl and search
25/05/2010
12:04
Avatar
irteza
Member
Members
Forum Posts: 11
Member Since:
18/04/2010
sp_UserOfflineSmall Offline

Hi .. 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

30/05/2010
13:24
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

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.

31/05/2010
14:23
Avatar
irteza
Member
Members
Forum Posts: 11
Member Since:
18/04/2010
sp_UserOfflineSmall Offline

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

02/06/2010
09:26
Avatar
kicsikapa
New Member
Members
Forum Posts: 1
Member Since:
02/06/2010
sp_UserOfflineSmall Offline

irteza 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

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information