jQuery Grid Plugin - jqGrid - Topic: unable to post data from edit form to DB.. http://www.trirand.com/blog/?page_id=393/help/unable-to-post-data-from-edit-form-to-db Simple:Press Version 5.7.5.3 dams on unable to post data from edit form to DB.. http://www.trirand.com/blog/?page_id=393/help/unable-to-post-data-from-edit-form-to-db#p15380 Help http://www.trirand.com/blog/?page_id=393/help/unable-to-post-data-from-edit-form-to-db#p15380 Hello ,

View my sample code for update product in database with edit form : ( my little experiance and my english ... Smile )

.HTML :

var gridimgpath = 'js/themes/start/images/'
jQuery(document).ready(function(){
jQuery("#s1list").jqGrid({
 sortable: true,
    url:'data/devis_detail_view.php?q=1&NumFactures=<?php echo $NumFactures_Factures?>',
 datatype: "json",
    colNames:['Actions','Interne','Produit','Reference', 'Libeller',  'Commentaire', 'Quantite', 'Remise','Prix unitaire','Prix total'],
    colModel:[
  {name:'act',index:'act', width:15,sortable:false,align:"center"},
  {name:'id',index:'id', width:20,align:"center",hidden:true},
        {name:'id_produit',index:'id_produit', width:20,align:"center"},
        {name:'Reference',index:'Reference', width:45,align:"center"},
  {name:'Libeller',index:'Libeller', width:45,align:"center"},
  {name:'commentaire',index:'commentaire', width:50, align:"center",editable: true,edittype:"textarea", editoptions:{rows:"5",cols:"30"}},
        {name:'quantite',index:'quantite', width:30, align:"center",editable:true},
        {name:'Remise',index:'id_remise', width:20, align:"center",editable:true},  
  {name:'prix',index:'prix', width:20,align:"center",editable:true,editoptions:{size:5}},
  {name:'$total',index:'$total', width:20,align:"center"},
    ],
    rowNum:25,
    mtype: "POST",
    rowList:[25,50,75],
    imgpath: gridimgpath,
    pager: jQuery('#s1pager'),
    sortname: 'id_produit',
    viewrecords: true,
 toolbar : [true,"top"],
 cellEdit: false,
 cellsubmit: 'remote',
 cellurl:'data/devis_update.php',
 editurl: 'data/devis_update.php',
 reloadAfterSubmit:true,
 autowidth: true,
 forceFit : true,
 sortorder: "asc", 
 gridview : true,
 userDataOnFooter : true,
 footerrow : true, 
 altRows : false,
    caption:"Détails des Produits",

 devis_update.php :

<php require_once('../Connections/gesy.php'); ?>
<?php
include('protect.php');
$id=$_POST[id];
$quantite=$_POST[quantite];
$commentaire=$_POST[commentaire];
$remise=$_POST[Remise];
$prix=$_POST[prix];
print_r($_POST);
mysql_select_db($database_gesy, $gesy);
$modifier="UPDATE factures_produits SET  quantite='$quantite', id_remise='$remise', prix='$prix', commentaire='$commentaire' WHERE id='$id';";
$execute=mysql_query($modifier) or die(mysql_error());
?>

Best regards ,

]]> Fri, 05 Mar 2010 10:36:57 +0200 kelso on unable to post data from edit form to DB.. http://www.trirand.com/blog/?page_id=393/help/unable-to-post-data-from-edit-form-to-db#p15366 Help http://www.trirand.com/blog/?page_id=393/help/unable-to-post-data-from-edit-form-to-db#p15366 Because im unable to post the data here in a readable format, refer to this post for code.

http://stackoverflow.com/quest.....a-troubles

I for the life of me can not get the form data to submit to the db. As long as reloadaftersubmit is false, it shows on the grid, but any reload of the form or grid erases my changes. Im using the navigator add/edit method. This is idealy what I want to use, but finding a "good" working example is hard to come by. your examples on the page have gotten me to where I am now, but when it comes to posting the data, noobs like me are completely lost.

Ive been working on this all week, and made absolutley no progress, and am at my wits end, please assist!

]]> Thu, 04 Mar 2010 20:49:43 +0200