jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

I add a new row, but nothing happened with the grid

Tags: add new row someurl

11/01/2012
23:22

chucky2183

Argentina

Member

Members

Forum Posts: 3

Member Since:
10/01/2012

Offline

Hello. I just created a grid of a detail of an invoice and shows it well. I charge
to start a local datatype (i use a local array) because i don't
touch the database, I just want to be able to insert,
edit and delete rows on the client side. And then when this
ended, newly obtained data and upload it to the database. But by adding
does nothing, call to "someurl.php", but i don't know what to do with those
data to update the data grid.

This is the code

jQuery("#table").jqGrid({
data: mydata,
datatype: 'local',
colNames:['Nº','Quantity', 'Description', 'Cost','SubTotal'],

colModel:[{name:'number',width:100, sortable:false,editoptions:{readonly:true,size:10}},
{name:'quantity', width:100,editable:true,sortable:false},
{name:'description', width:400, edittype:"textarea",align:"right",editable:true,

sortable:false},
{name:'cost', width:150, align:"right",editable:true,sortable:false,editrules:

{number:true}},
{name:'subtotal', width:150,editable:true, sortable:false}
],
height: 'auto',
pager: '#pager',
});

jQuery("#table").jqGrid('navGrid',"#pager",{add:true,edit:true,del:true, search:false, refresh:false},
{height:370,width:400,reloadAfterSubmit:true,url:'someurl.php'}, // edit options
{height:370,width:400,reloadAfterSubmit:true,url:'someurl.php'}, // add options
{reloadAfterSubmit:false,url:'fede.php'} // del options
);
</script>

someurl.php (Here i don't know how to do to edit the grid) adding, modifying or deleting

<?php
if($_POST[oper]=='add') {
    $number = $_POST['number'];
    $quantity = $_POST['quantity'];
    $description = $_POST['description'];
    $cost= $_POST['cost'];
    $subtotal = $_POST['subtotal'];
    $model = array(
    array("number"=>"$number","quantity"=>"$quantity",
        "description"=>"$description",
        "cost"=>"$cost", "subtotal"=>$cost* $cantidad));
// MODIFIES USER RECORD
} elseif($_POST[oper]=='edit') {
    $number = $_POST['number'];
    $quantity = $_POST['quantity'];
    $description = $_POST['description'];
    $cost = $_POST['cost'];
    $subtotal = $_POST['subtotal'];
} elseif($_POST[oper]=='del') {
    $number = $_POST['number'];
    $quantity = $_POST['quantity'];
    $description = $_POST['description'];
    $cost = $_POST['cost'];
    $subtotal = $_POST['subtotal'];
}
return $model;
?>

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
60 Guest(s)

Currently Browsing this Page:
1 Guest(s)