$grid = new jqGridRender($conn); // Write the SQL Query $grid->SelectCommand = 'SELECT CustomerID, CompanyName, Phone, PostalCode, City FROM customers'; // Set the table to where you update the data $grid->table = 'customers'; // Set output format to json $grid->dataType = 'json'; $grid->setPrimaryKeyId('CustomerID'); // Let the grid create the model $grid->setColModel(); // Set the url from where we obtain the data $grid->setUrl('grid.php'); // Set some grid options $grid->setGridOptions(array("rowNum" => 10, "rowList" => array(10, 20, 30), "sortname" => "CustomerID")); $grid->setColProperty('CustomerID', array("editoptions" => array("readonly" => true))); // For demonstration purposes only we will update the Customer name adding at end of // the field U after the data is updated from the user // We can set ulimited commands after edit occur. // The same apply for del and add operation $cid = jqGridUtils::GetParam('CustomerID'); // This command is executed immediatley after edit occur. $grid->setAfterCrudAction('edit', "UPDATE customers SET CompanyName = CONCAT(CompanyName,' -U') WHERE CustomerID=?", array($cid)); // Enable navigator $grid->navigator = true; // Enable only editing $grid->setNavOptions('navigator', array("excel" => false, "add" => false, "edit" => true, "del" => false, "view" => true, "search" => false)); // Close the dialog after editing $grid->setNavOptions('edit', array("closeAfterEdit" => true, "editCaption" => "Update Customer", "bSubmit" => "Update")); // Enjoy $grid->renderGrid('#grid', '#pager', true, null, null, true, true); $conn = null;