jQuery Grid Plugin - jqGrid - Topic: How to add row http://www.trirand.com/blog/?page_id=393/help/how-to-add-row Simple:Press Version 5.7.5.3 cheech74 on How to add row http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p26202 Help http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p26202 I am sure I had this working before, but i am only able to edit the first row. If i try to edit any others the new data doesnt save.

I am still using the code as above. Also what would need to go in to delete a row.

many thanks

]]> Fri, 23 Mar 2012 01:55:19 +0200 cheech74 on How to add row http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p26009 Help http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p26009 Yep thats done it - thanks very much. Couldn't see it for looking

]]> Sat, 25 Feb 2012 01:56:59 +0200 strgg on How to add row http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p25996 Help http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p25996 Maybe it could help to use INSERT instead of UPDATe in the add conditional

]]> Wed, 22 Feb 2012 21:30:44 +0200 cheech74 on How to add row http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p25982 Help http://www.trirand.com/blog/?page_id=393/help/how-to-add-row#p25982 I have created a basic grid, but am having problems adding a new row in jqgrid - any help much appreciated. I have set up the php file with add/edit as below.

thanks

    <script type="text/javascript">
   
    $(function(){
   
      $("#rota").jqGrid({
        url:'example.php',
        datatype: "json",
     mtype: 'POST',
        colNames:['Id', 'Date', 'HPJ', 'Recycler','CCTV','Assistant'],
        colModel:[
         {name:'id',index:'id', width:200,hidden:false,sortable:false,editable:true},
      {name:'date',index:'date', width:200,sortable:false,editable:true},
         {name:'hpj',index:'hpj', width:200,sortable:false,editable:true},
          {name:'recycler',index:'recycler', width:200,sortable:false,editable:true},
          {name:'cctv',index:'cctv', width:200,sortable:false,editable:true},
       {name:'assistant',index:'assistant', width:200,sortable:false,editable:true}
        ],
     rowNum:30,
        sortname: 'id',
        viewrecords: true,
        sortorder: "asc",
        caption:"Weekend Call Out Rota",
     pager : '#navGrid',
     forceFit : true,
    editurl: 'rotaedit.php?action=save',
    
    });
   
    jQuery("#rota").jqGrid('navGrid','#navGrid',{edit:true,add:true,del:true});
   
  
    });

Here is the rotaedit.php code I am using

    //mysql_set_charset('utf8',$database); mysql_query("SET NAMES 'utf8'");  
     if($_POST['oper']=='add') 
    
    {    
     $id   =   mysql_real_escape_string($_POST['id']);
     $date   =   mysql_real_escape_string($_POST['date']);
     $hpj =   mysql_real_escape_string($_POST['hpj']);
     $recycler    =   mysql_real_escape_string($_POST['recycler']);   
     $cctv  =   mysql_real_escape_string($_POST['cctv']);
     $assistant   =   mysql_real_escape_string($_POST['assistant']);  
     $sql = "UPDATE ".$tablename."
     SET id = '".$id."',
     date = '".$date."',
    hpj = '".$hpj."',
    recycler = '".$recycler."',
     cctv = '".$cctv."' , 
     assistant= '".$assistant."'"; 
   
   
     echo $sql; $result=mysql_query($sql) or die(mysql_error());
     mysql_close($db);    }
    
    
    
     if($_POST['oper']=='edit')
     {    
     $id   =   mysql_real_escape_string($_POST['id']);
     $date   =   mysql_real_escape_string($_POST['date']);
     $hpj =   mysql_real_escape_string($_POST['hpj']);
     $recycler    =   mysql_real_escape_string($_POST['recycler']);   
     $cctv  =   mysql_real_escape_string($_POST['cctv']);
     $assistant   =   mysql_real_escape_string($_POST['assistant']);  
     $sql = "UPDATE ".$tablename."
     SET id = '".$id."',
     date = '".$date."',
    hpj = '".$hpj."',
    recycler = '".$recycler."',
     cctv = '".$cctv."' , 
     assistant= '".$assistant."'";
    
   
   
     echo $sql; $result=mysql_query($sql) or die(mysql_error());
     mysql_close($db);    }
     if($_POST['oper']=='del')  {   } 

]]> Tue, 21 Feb 2012 02:09:36 +0200