jQuery Grid Plugin - jqGrid - Topic: How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl Simple:Press Version 5.7.5.3 OlegK on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19605 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19605 If your beforeSubmitCell function will returns an object it will be combined with the postdata. For example is you fill use

    beforeSubmitCell : function(rowid,celname,value,iRow,iCol) {
        return {tableName: "myTableName", tableNameId: "myTableNameId"}
    }

then the posted data will looks like

    tableName=myTableName&tableNameId=myTableNameId&Col=NewData&id=2&oper=edit

So with respect of beforeSubmitCell you can put/override any information send during cell editing.

Regards
Oleg 

P.S. How could I see I write slowly as you. 🙂

]]> Wed, 08 Sep 2010 18:00:12 +0300 sibbim on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19604 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19604 After all - it was pretty easy 😉

        beforeSubmitCell : function(rowid,celname,value,iRow,iCol) {
            //alert (rowid +"/"+celname+"/"+value+"/"+iRow+"/"+iCol);
            return {tableNameId:tableNameId,tableName:tableName};
        },

I hope I could help you 😉

]]> Wed, 08 Sep 2010 17:50:11 +0300 sibbim on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19600 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19600 Hi Oleg,

thanks for your reply - I found the other parameter...

...However - I also need the table name and the primary key. My idea was to use

ajaxCellOptions: {data: "tableName="+tableName+"&tableNameId="+tableNameId}

This works pretty good - BUT... this overwrites the jqGrid parameters (Col=NewData&id=2&oper=edit)

I also tried it this way:

ajaxCellOptions: {data: "tableName="+tableName+"&tableNameId="+tableNameId+"&rowid="+rowid+"&cellname="+cellname+"&value="+value},

But it seems that the variables are not known at this stage - and this is why it doesn't show the grid than.

Nevertheless, is this the right way to pass additional parameters to the PHP?

Thanks,

Sebastian

]]> Wed, 08 Sep 2010 16:57:03 +0300 OlegK on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19598 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19598 You can use Fiddler to see all data which will be send or returned from the server. If you use it with the localhost you should use ipv4.fiddler instead of the localhost.

The data look like

Col=NewData&id=2&oper=edit

where Col is the column name like you define it in the colModel, NewData is the value which the user enter in the cell, the meaning of id and oper is clear.

Regards
Oleg 

]]> Wed, 08 Sep 2010 16:45:02 +0300 sibbim on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19597 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19597 and thats the way to get the id 😉

$rowid         = isset($_POST['id']) ? $_POST['id']: false;

only the column name is missing

]]> Wed, 08 Sep 2010 16:26:45 +0300 sibbim on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19596 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19596 It's getting clearer now...

$celname     = isset($_POST['orig_country']) ? $_POST['orig_country']: false;

I'm able to get the value when I use the name of the column directly.

Now I just need the column name itself and the rowid - any ideas on that?

]]> Wed, 08 Sep 2010 16:18:19 +0300 sibbim on How to pass data of the cell from jqGrid to the "cellurl" http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19591 Help http://www.trirand.com/blog/?page_id=393/help/how-to-pass-data-of-the-cell-from-jqgrid-to-the-cellurl#p19591 Hi Everybody,

I'm pretty new to jqGrid and I understand already lot of thinks. However I'm not able to pass

the data after a cellchange to my update php script.

View a few words:

1. I build the jqGrid with the option:

cellurl: 'se/ref_mgmnt_save.php',

I can see the grid with all data and when I click on a cell it becomes editable.

2. After pressing the Return-Key I want this data to be stored in the MySQL database:

$queryUpdate = "UPDATE table SET ".$celname."='".$value."' WHERE table_id='".$rowid."';";

Well, and this is my problem. The PHP-File "se/ref_mgmnt_save.php" is called but the data is not stored in the database because the PHP script doesn't know the celname (column name from grid), value (the new value in this column) and the rowid (the primary key).

The Wiki says (http://www.trirand.com/jqgridw.....ll_editing)

"The rowid and the cell content are added to the url as name:value pairs. For example, if we save the cell named mycell,{id: rowid, mycell: cellvalue} is added to the url."

Sorry, but I don't have any idea what is ment by this and how I can refer to the data in my PHP-Script. I think without a hint from your site I'm totally lost Cry

More detailed - my Javascript file:

getColumnHeader is just a function to populate the jqgrid with all columns from the corresponding table. This works pretty fine.

function loadRefMgmnt(tableName){
    
    var tableNameId = tableName + "_id";
    var columnHeader = getColumnHeader(tableName, "", "");
    var columnHeader2 = getColumnHeader2(tableName, "", "");
    
    $("#ref_mgmnt").jqGrid({
        url:'se/ref_mgmnt.php',
        datatype: "json",
        height: 450,
        width: 1100,
        colNames: columnHeader2,
        colModel: columnHeader,
        rowNum: 50,
        rowTotal: 2000,
        rowList : [20,30,50],
        scroll:1,
        loadonce:true,
        mtype: "GET",
        gridview: true,
        pager: '#ref_mgmnt_pager',
        sortname: 'item_id',
        viewrecords: true,
        sortorder: "asc",
        caption: "Reference data",
        cellEdit: true,
        cellurl: 'se/ref_mgmnt_save.php',
        afterSubmitCell: function(serverresponse, rowid, cellname, value, iRow, iCol) {
            alert (serverresponse.responseText);
        },
        beforeSubmitCell : function(rowid,celname,value,iRow,iCol) {
            var varCellUrl = 'se/ref_mgmnt_save.php';
            //alert (rowid +"/"+celname+"/"+value+"/"+iRow+"/"+iCol);
        }
    });

    $("#ref_mgmnt").jqGrid('navGrid','#ref_mgmnt_pager',{del:false,add:true,edit:false},{},{},{},{multipleSearch:true});
}

2. And finally my PHP-File:

<?php
    require '../settings.inc.php';
    require BASE_DIR.'/class/mysql.class.php';
    
    $celname     = isset($_POST['celname']) ? $_POST['celname']: false;
    $value        = isset($_POST['value']) ? $_POST['value']: false;
    $rowid         = isset($_POST['rowid']) ? $_POST['rowid']: false;    
    

    try {
        $sql = new mysql ($_SESSION['db_server'], $_SESSION['db_user'], $_SESSION['db_pass'], $_SESSION['db_name']);
        $queryUpdate = "UPDATE table SET ".$celname."='".$value."' WHERE table_id='".$rowid."';";
        $result = $sql->mysqlGetData ($queryUpdate);
    } catch (Exception $e) {
        echo $e->getMessage();
        exit();
    }
    
    $total = mysql_affected_rows();
      
    // Return JSON data
    $json = array();
    $json['queryUpdate'] = $queryUpdate;

    // PHP json_encode not supported < 5.1.6
    require BASE_DIR.'/class/json_encode.php';
    echo json_encode($json);
    
    try {
        $sql->mysqlCloseDb();
    } catch (Exception $e) {
        echo $e->getMessage();
        exit();
    }
?>

Thanks,

Sebastian

]]> Wed, 08 Sep 2010 14:30:44 +0300