jQuery Grid Plugin - jqGridForum

17/11/2008
05:57

adam

Member

Members

Forum Posts: 6

Member Since:
03/11/2008

Offline

1

Hi all

Ex:

{edit:true,add:false,del:true,search:false,refresh:true},

{ height:280,
editCaption:”Edit”,
bSubmit:”Submit”,
bCancel:”Cancel”,
url:”", //how to use?
processData:”Loading..”,
reloadAfterSubmit:false

},
//{reloadAfterSubmit:false},//add

{
msg:”Delete selected row(s)”,
bSubmit:”Submit”,
bCancel:”Cancel”,
url:”",
reloadAfterSubmit:false

} // del options
);

I want to del(edit) row(s)

I dont know use url to del a row.

Pls help me.

17/11/2008
08:39

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

2

Hello,

Please read the docs.

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.

17/11/2008
09:58

adam

Member

Members

Forum Posts: 6

Member Since:
03/11/2008

Offline

3

Thanks Tony.

I read the docs but I don't understand.

{
msg:”Delete selected row(s)”,
bSubmit:”Submit”,
bCancel:”Cancel”,
url:””,
reloadAfterSubmit:false

} // del options

Pls help me Tony

18/11/2008
07:23

YamilBracho

Member

Members

Forum Posts: 124

Member Since:
08/09/2008

Offline

4

Which part is the difficult one ?

Give us more information to help you better...

18/11/2008
08:08

adam

Member

Members

Forum Posts: 6

Member Since:
03/11/2008

Offline

5

Thanks YamilBracho.

I want to delete a row(s). Ex :A row have id=10.How to GET or POST this id to delete (file php)

{
msg:”Delete selected row(s)”,
bSubmit:”Submit”,
bCancel:”Cancel”,
url:”pro.php?mode=del&id= ”+id,//HOW TO GET(POST) THIS ID SEND TO php file?
reloadAfterSubmit:false

} // del options

18/11/2008
09:05

YamilBracho

Member

Members

Forum Posts: 124

Member Since:
08/09/2008

Offline

6

It is not needed to add the "mode" to your url because jqGrid does for you and pass "del" in the "oper" variable.

You can add any kind of information to your delete url using the delData array. This the code for my delete option:

beforeSubmit: function() {
                 var sr = jQuery("#list").getGridParam('selrow');
                 var rowData = jQuery("#list").getRowData(sr);

                  this.delData = {"co_sector" : rowData['co_sector']};
                  retarr = {"co_sector" : rowData['co_sector']};
                  return retarr;
              }
            }

I am adding the "co_sector" information to my url so it will receive oper=del&co_sector=10, for example...

HTH and it doesn't just ask again...

18/11/2008
11:02

adam

Member

Members

Forum Posts: 6

Member Since:
03/11/2008

Offline

7

Thanks.

My code here

},
//{reloadAfterSubmit:false},//add
{
msg:”Delete selected row(s)”,
bSubmit:”Submit”,
bCancel:”Cancel”,
url:”pro.php?mode=del&id= ”+id,//HOW TO GET(POST) THIS ID SEND TO php file?
reloadAfterSubmit:false

} // del options
);
</script>

pro.php

<?php
include("./common.php");
$mode = isset($_GET["mode"]) ? htmlspecialchars($_GET["mode"]) : '';

switch ($mode)
{
    case "edit":
        do_edit_thuoc();
        break;

    case "del":
        do_delete_thuoc();
        break;
   .......

}

function do_delete_thuoc(){
global $lang,$db, $template;
   $ct_id    = isset($_POST['ct_id']) ? intval($_POST['ct_id']) : 0;
   $sql = 'DELETE FROM tblcart WHERE ct_id='.$ct_id;
        if( !$db->sql_query($sql) ) {
            message_die("Couldn't access to database!!!", "", __LINE__, __FILE__, $sql);
        }
   return true;
}

18/11/2008
12:10

YamilBracho

Member

Members

Forum Posts: 124

Member Since:
08/09/2008

Offline

8

So you have tow urls chained to this grid...

I think you can still use the code I show (beforeSubmit event).

In this method you could see :

var sr = jQuery(”#list”).getGridParam('selrow');
var rowData = jQuery(”#list”).getRowData(sr);

The first line take the current row selected and the second one get the data in this row. Now you can access any value in the row doing something like:

alert(rowData['id']);

Also there is a postData array that you can manipulta using the setPostData() and appendPostData() methods...

18/11/2008
14:24

adam

Member

Members

Forum Posts: 6

Member Since:
03/11/2008

Offline

9

From my scripts(js and php) .You can edit for me?.

I'm a newbie.Pls help me YamilBracho.The first time i use jqgird

19/11/2008
07:03

YamilBracho

Member

Members

Forum Posts: 124

Member Since:
08/09/2008

Offline

10

It could be something like:

{
   msg:”Delete selected row(s)”,
bSubmit:”Submit”,
bCancel:”Cancel”,
url:"pro.php?mode=del"
reloadAfterSubmit:false,
    beforeSubmit: function() {
                 var sr = jQuery(”#list”).getGridParam('selrow');
                 var rowData = jQuery(”#list”).getRowData(sr);

                  this.delData = {”id” : rowData['id']};
                  retarr = {”id” : rowData['id']};
                  return retarr;
              }
            }

} // del options

HTH

22/12/2011
20:51

Felipe

Mexico

New Member

Members

Forum Posts: 2

Member Since:
22/12/2011

Offline

11

Hello, I has this function :

function borrar_cs(row_id,count_sheet)
{

var options = {
caption: "Cancel Count Sheet",
url: '../../countsheetbiz?accion=delete_count_sheet&cs='+count_sheet,
msg: "Cancel count sheet ["+count_sheet+"]?",
bSubmit: "YES",
bCancel: "NO ",
top:"150",
recreateForm:true,
left:"300"
};
$("#tab_list").jqGrid('delGridRow',row_id, options );

}

I invoke this function from a button in the jqgrid, my problem is the msg is not refreshing, somebody know how to refresh the msg on the delete window?

for example: the first time the msg is "Cancel count sheet [40]?" this is correct but the next time

the count_sheet variable change the value but the msg is the same,

the problem is only on the msg, on the code behind is correct, I receive the correct value

thank you in advance

23/12/2011
03:00

Felipe

Mexico

New Member

Members

Forum Posts: 2

Member Since:
22/12/2011

Offline

12

solved with this line

$(".delmsg").html(options.msg);

$("#tab_list").jqGrid('delGridRow',row_id, options );