jQuery Grid Plugin - jqGrid - Topic: formedit on double click http://www.trirand.com/blog/?page_id=393/help/formedit-on-double-click Simple:Press Version 5.7.5.3 a6andrea on formedit on double click http://www.trirand.com/blog/?page_id=393/help/formedit-on-double-click#p13356 Help http://www.trirand.com/blog/?page_id=393/help/formedit-on-double-click#p13356 edit,

I try to edit the code like this:

<script type="text/javascript">

var lastsel

jQuery(document).ready(function(){
  jQuery("#list").jqGrid({
    url:'example.php',
    datatype: 'xml',
    mtype: 'GET',
    colNames:['id','titolo'],
    colModel :[
      {name:'id', index:'id', width:200},
      {name:'titolo', index:'titolo', width:600, editable: true}
    ],
   
    ondblClickRow: function(id){
        if(id && id!==lastsel){
            jQuery('#list').jqGrid('restoreRow',lastsel);
            jQuery('#list').jqGrid('editGridRow',id);
            lastsel=id;
            }
        },
       
    editurl: "edit.php",
    pager: '#pager',
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'id',
    sortorder: 'desc',
    viewrecords: true,
    caption: 'La mia tabella'
  });
});
</script>

now, on a doubleclick on o row, I can edit data using formedit dialog.

this is my file edit.php

<?php

//I connect to my database and it's all rigth

// How can I recovery the data passed from the formedit dialog ??

// $id = $_POST['id'];  // like this ??

// $titolo = $_POST['titolo'];  // like this ??

$sql=" UPDATE my_tab SET titolo='$titolo' WHERE id='$id' "

$res=mysql_query($sql,$db) or die(mysql_error());

?>

]]> Sun, 27 Dec 2009 06:56:16 +0200 a6andrea on formedit on double click http://www.trirand.com/blog/?page_id=393/help/formedit-on-double-click#p13355 Help http://www.trirand.com/blog/?page_id=393/help/formedit-on-double-click#p13355 Hello to everyone !!

First of all, sorry for my english, I don't speak and write it well.

this is my code:

.....

<script type="text/javascript">
jQuery(document).ready(function(){
  jQuery("#list").jqGrid({
    url:'example.php',
    datatype: 'xml',
    mtype: 'GET',
    colNames:['id','titolo'],
    colModel :[
      {name:'id', index:'id', width:200},
      {name:'titolo', index:'titolo', width:600, editable: true}
    ],
    editurl: "edit.php",
    pager: '#pager',
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'id',
    sortorder: 'desc',
    viewrecords: true,
    caption: 'La mia tabella'
  });
 
    $("#bedata").click(function(){
    var gr = jQuery("#list").jqGrid('getGridParam','selrow');
    if( gr != null ) jQuery("#list").jqGrid('editGridRow',gr,{height:280,reloadAfterSubmit:false});
    else alert("Seleziona una riga da modifcare !");
    });   
});
</script>
 
</head>
<body>
<table id="list"></table>
<div id="pager"></div>
<input type="button" id="bedata" value="edit selected" />
</body>
</html>

1st question)

I would like to open the formedit dialog with a  "double clik" on the row that I choose, (I don't want press the button "edit selected"). How can I do it?

2nd question)

what kind of data is post the file "edit.php" and how can I use it for save the data in a mysql table?

Thank You for Everything !

Andrea

]]> Sun, 27 Dec 2009 03:43:49 +0200