jQuery Grid Plugin - jqGridForum

22/09/2009
16:41

vicman

New Member

Members

Forum Posts: 1

Member Since:
23/09/2009

Offline

1

How i can delete a row, in the delete.php page i only receive the id (position), but i need send another key (id in database)

thanks.

22/09/2009
17:38

uruguay

Member

Members

Forum Posts: 20

Member Since:
20/09/2009

Offline

2

hi,

When you load de table you can especify de id of the row like this,

$result = mysqli_query($link_identifier,$SQL) or die("Couldn t execute query.".mysqli_error($link_identifier));
    $responce->page = $page;
    $responce->total = $total_pages;
    $responce->records = $count;
    $i=0;
    while($row = mysqli_fetch_array($result,MYSQL_ASSOC)) {
        $responce->rows[$i]['id']=$row[id];
        $responce->rows[$i]['cell']=array($row[nombre],$row[categoria],$row[stock]);
        $i++;
    }

and then use it like this

"DELETE FROM table WHERE id=$_POST[id]"

25/09/2009
04:38

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

3

Hello,

You can use delData parameter to set additional static data, or use onclickSubmit event to add dynamically parameters to the posted data.

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.

10/05/2010
22:00

varnold61

New Member

Members

Forum Posts: 2

Member Since:
10/05/2010

Offline

4

I am very frustrated because I cannot get the delete to send the additional post data. Can anybody help ? i have tried using the onclicksubmit in the delete options as well as setting delData{tablename:"dummy"}

i cannot get either to work... the grid itself is working fine.

i have tried this:

}).navGrid('#pager',
{edit:false, search:false, view:true, add:true, del:true},
{editData:{tablename:"dummy"},reloadAfterSubmit:false}, // edit options
{editData:{tablename:"dummy"}, reloadAfterSubmit:true,closeAfterAdd:true}, // add options
{onclickSubmit : function(eparams) {

return {additionalDataWhenDeleting:"I am additional data when deleting"};
}} // del options
);

and this :

}).navGrid('#pager',
{edit:false, search:false, view:true, add:true, del:true},
{editData:{tablename:"dummy"},reloadAfterSubmit:false}, // edit options
{editData:{tablename:"dummy"}, reloadAfterSubmit:true,closeAfterAdd:true}, // add options
{delData:{tablename:"dummy} }
);

i think the problem maybe with getting the correct includes, etc... for the css and javascript because i had it working at one time and am not sure what i changed.

I am including this :

my table id is "list" , the pager is "pager"

Thanks to anyone who can help.

Virginia

11/05/2010
04:46

sangee

Ulsan in Korea

Member

Members

Forum Posts: 4

Member Since:
11/05/2010

Offline

5

In my case, I used user-defined-button and event as below.

But is's just get method type to delete.

Also I wish that when I delete multi-selected rows, the rows just not displayed in the grid but it exist in DOM just having delete-flag.

~~

  .jqGrid('navButtonAdd','#pager',{caption:"Delete",
      onClickButton:function(){
      deleteGridRow();
   }

~~

function deleteGridRow(){

    var rowID = returnRowID();
    var colDomainID = jQuery('#list').jqGrid('getCol','domain_id',false)[rowID-1];
  var colCodeGroup = jQuery('#list').jqGrid('getCol','code_group',false)[rowID-1];

    var strURL = "source/common/get_code_header.asp";
    strURL = strURL + "?domain_id=" + colDomainID;                 //domain_id and code_group is group-key
    strURL = strURL + "&code_group=" + colCodeGroup;

if( rowID != null ) jQuery("#list").jqGrid('delGridRow',rowID,{url:strURL,reloadAfterSubmit:false});
else alert("Please Select Row to delete!");

}

function returnRowID(){
    var id = jQuery("#list").jqGrid('getGridParam','selrow');        //get the selected rowid
     if(id)
        return id;
     else
        return null;
}

——————— Server(get_code_header.asp)——————-

'//received param

m_strOperator = Trim(Request("oper"))                    '//default param by jqGrid
m_strID = Trim(Request("id"))                                   '//default param by jqGrid
m_strDomainID = Trim(Request("domain_id"))          '//user-defined param
m_strCodeGroup = Trim(Request("code_group"))     '//user-defined param

——————————————————————————-

[explanation] "oper" param value: del, edit, add

12/05/2010
13:23

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

6

HEllo,

Before you delete the row you can use getRowData and store the deleted row in array or in other dom element putting that data somewhere

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.