Forum

November 2nd, 2014
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_TopicIcon
Add/Edit/Delete from Grid - using 'url' parameter
26/06/2009
13:10
Avatar
jmcleod3
Member
Members
Forum Posts: 33
Member Since:
04/05/2009
sp_UserOfflineSmall Offline

Hello all,

I've been working on a CRUD and was wondering if anyone has seen simple examples using the 'url' parameter instead of 'editurl'?

I can get my grid to edit a row but to delete or add it always goes to the editurl property: 'editGrid.php'.

When I disable/remore 'editurl', I get the 'No url set.' error message.

Here's my grid...

var lastsel;
    var selrow;
    jQuery("#crud").jqGrid({
        url:'_getGrid.php?nd='+new Date().getTime(),
            datatype: "json",
            colNames:['ID','First Name','Last Name','Address','City','State','Zip Code', 'Phone', 'Birth Date', 'Notes'],
            colModel:[
                {name:'customer_id', index:'customer_id', width:50, editable:true, editoptions:{readonly:true}},
                {
                    name:'firstName',
                     index:'firstName',
                     width:100,
                    editable:true,
                    editoptions:{
                        size:20
                    },
                    formoptions:{
                        rowpos:1,
                        label:'First Name',
                        elmprefix:"(*)"
                    },
                    editrules:{
                        required:true
                    }
                },
                {name:'lastName',index:'lastName', width:120, editable:true, editoptions:{size:20}, editrules:{required:true}},
                {name:'address',index:'address', width:200, editable:true, editoptions:{size: 30}},
                {name:'city', index:'city', width:100, editable:true, editoptions:{size:20}},
                {name:'state',index:'state', width:50,
                    editable:true,
                    edittype:'select',
                    editoptions:{value:"AL:AL;AK:AK;AZ:AZ;AR:AR;CA:CA;CO:CO;CT:CT;DE:DE;FL:FL;GA:GA;HI:HI;ID:ID;IL:IL;IN:IN;IA:IA;KS:KS;KY:KY;LA:LA;ME:ME;MD:MD;MA:MA;MI:MI;MN:MN;MS:MS;MO:MO;MT:MT;NE:NE;NV:NV;NH:NH;NJ:NJ;NM:NM;NY:NY;NC:NC;ND:ND;OH:OH;OK:OK;OR:OR;PA:PA;RI:RI;SC:SC;SD:SD;TN:TN;TX:TX;UT:UT;VT:VT;VA:VA;WA:WA;WV:WV;WI:WI;WY:WY"}
                },
                {name:'zipcode', index:'zipcode', width:60, align:"right", hidden:true,editable:true,editoptions:{size:10},editrules:{edithidden:true,number:true}},
                {name:'phone', index:'phone', width:90, align:"right", hidden:true,editable:true,editoptions:{size:11},editrules:{edithidden:true,required:true}},
                {name:'birthdate', index:'birthdate', width:60, align:"right", hidden:true,editable:true,editoptions:{size:10},editrules:{edithidden:true}},
                {name:'notes', index:'notes', width:100, sortable:false,editable: true,edittype:"textarea", editoptions:{rows:"5",cols:"30"}, search:false}
            ],
            pager: jQuery('#pager2'),
            rowNum:10,
            rowList:[10,20,30],
            imgpath:'css/themes/green/images/',
            sortname: 'customer_id',
        viewrecords: true,
        sortorder: "asc",
        caption: "CRUD Contact Management Application",
        //editurl:'_editGrid.php',
        height:210,
        scrollrows : true
    }).navGrid("#pager2",
                {edit:true, add:true, del:true, search:true},
                {height: 400, width: 420, savekey: [true,13], navkeys: [true,38,40], reloadAfterSubmit:false,jqModal:false, closeOnEscape:true, url:'_editGrid.php', bottominfo:"Fields marked with (*) are required"}, // edit options
                /*
                {view:true}, //options
                */
                {height: 360, width: 400, savekey: [true,13], navkeys: [true,38,40], reloadAfterSubmit:false,jqModal:false, closeOnEscape:true, url:'_delete.php', bottominfo:"Fields marked with (*) are required"}, // add options
                /*
                {height: 100, reloadAfterSubmit:false,jqModal:false,closeOnEscape:true, url:'_delete.php'}, // del options
                */
                {closeOnEscape:true}, // search options
                {navkeys: [true,38,40], height:400,jqModal:false,closeOnEscape:true}
              ) // view options
   
});
   
    // Delete Selected Row
   
    $("#crud").click(function(){
        var gr = jQuery("#crud").getGridParam('selrow'); //getSelectedRow();
        if( gr != null ){
            jQuery("#crud").deleteGridRow(gr,{reloadAfterSubmit:false, url:'_delete.php'});
        }
        else {
            alert("Please Select Row to delete!");
        }
    });
   
    // Edit Selected Row
    $("#crud").click(function(){
        var gr = jQuery("#crud").getGridParam('selrow');
        if( gr != null ){
            jQuery("#crud").editGridRow(gr,{height:280,reloadAfterSubmit:false, url: '_editGrid.php'});
        }
        else {
            alert("Please Select Row");
        }
    });

Thanks.

JohnM

It's not who I am underneath, but what I do that defines me.

27/06/2009
12:23
Avatar
tony
Sofia, Bulgaria
Moderator
Members

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

Hello,

I Think the problem is here:

{view:true}, //options

In the navigator options between edit and add.

Regards

Tony

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.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
154 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