Edit Ship Details
This Form is created with HTML5 Guriddo Form PHP builder

It is possible to get the desired data and update it very easy.
We just need to write the SQL query and pass a parameter with the desired
index to be find.
The class automatically detect if the record should be updated or inserted.
require_once '../../../php/demo/tabs2.php';
<!DOCTYPE html>
<html lang="en" class="no-js">
    <title>jqForm PHP Demo</title>
    <link rel="stylesheet" type="text/css" media="screen" href="../../../css/jquery-ui.css" />
    <link rel="stylesheet" type="text/css" media="screen" href="../../../css/trirand/ui.jqform.css" />
    <style type="text/css">
        html, body {
        margin: 0;            /* Remove body margin/padding */
        padding: 0;
        /*overflow: hidden;*/    /* Remove scroll bars on browser window */
        font-size: 90%;
        body {
            font-family: "Trebuchet MS", "Helvetica", "Arial",  "Verdana", "sans-serif";
        #notsupported  { border: 0px none;}
    <script src="../../../js/jquery.min.js" type="text/javascript"></script>
    <script src="../../../js/jquery-ui.min.js" type="text/javascript"></script>    
    <script src="../../../js/jquery.form.js" type="text/javascript"></script>
    <script src="../../../js/modernizr.js" type="text/javascript"></script>
    <script type="text/javascript">
          if(Modernizr.inputtypes.number) {
              jQuery("#supported").append("<div>Your browser support input type: number!</div>");
          } else {
              jQuery("#notsupported").append("<div>Your browser does not support input type: number!</div>").addClass('ui-state-error');
      <div style="margin-left:20px;margin-right: 20px;">
          <?php include ("sqlquerydata.php");?>
          <div style="text-align: center;margin-top:10px;">This Form is created with HTML5 Guriddo Form PHP builder</div>
      <div id="supported"></div>
      <div id="notsupported"></div>
      <?php tabs(array("sqlquerydata.php"));?>
// Include class 
include_once '../jqformconfig.php'

// Create instance 
$newForm = new jqForm('newForm',array('method' => 'post''id' => 'newForm'));
// Demo Mode creating connection 
include_once $DRIVER_PATH.'jqGridPdo.php'
$newForm->setConnection$conn );
// Set url
// Set Form header 
$formhead='Edit Ship Details';
// Set parameters 
$Order jqGridUtils::GetParam('Order','10254');
$Order is_numeric($Order) ? (int)$Order 0;
$jqformparams = array($Order);
// Set SQL Command, table, keys 
$newForm->SelectCommand 'SELECT OrderID, ShipName, ShipAddress, ShipCity, ShipPostalCode, ShipCountry, Freight FROM orders WHERE OrderID = ?';
$newForm->table 'orders';
$newForm->serialKey true;
// Set Form layout 
// Add elements
$newForm->addElement('OrderID','hidden', array('label' => 'OrderID''id' => 'newForm_OrderID'));
$newForm->addElement('ShipName','text', array('label' => 'ShipName''maxlength' => '40''style' => 'width:98%;''id' => 'newForm_ShipName'));
$newForm->addElement('ShipAddress','text', array('label' => 'ShipAddress''maxlength' => '60''style' => 'width:98%;''id' => 'newForm_ShipAddress'));
$newForm->addElement('ShipCity','text', array('label' => 'ShipCity''maxlength' => '15''size' => '20''id' => 'newForm_ShipCity'));
$newForm->addElement('ShipPostalCode','text', array('label' => 'ShipPostalCode''maxlength' => '10''size' => '20''id' => 'newForm_ShipPostalCode'));
$newForm->addElement('ShipCountry','select', array('label' => 'ShipCountry''datasql' => 'SELECT ShipCountry FROM orders  WHERE ShipCountry <> "" GROUP BY ShipCountry''id' => 'newForm_ShipCountry'));
$newForm->addElement('Freight','number', array('label' => 'Freight''id' => 'newForm_Freight'));
$elem_8[]=$newForm->createElement('newSubmit','submit', array('value' => 'Submit'));
$newForm->addGroup("newGroup",$elem_8, array('style' => 'text-align:right;''id' => 'newForm_newGroup'));
// Add events
// Add ajax submit events
$newForm->setAjaxOptions( array('dataType'=>null,
'resetForm' =>null,
'clearForm' => null,
'iframe' => false,
'forceSync' =>false) );
// Demo mode - no input 
$newForm->demo true;
// Render the form 
echo $newForm->renderForm($jqformparams);