jQuery Grid Plugin - jqGrid

onSelectRow: function(id){
    if(id && id!==lastSel){
        jQuery('#list2').restoreRow(lastSel);
        jQuery('#list2').editRow(id, true,on_edit,checksave);
        lastSel=id;
    }
}

function checksave(result) {
    // check to see if POST returns a good HTTP response
    if (result.status != 200) {
        alert(result.statusText);
         alert(”Update failed!”);
         return false;
    }
  // the PHP code sends OK as the first 2 characters if it did the db update successfully
  // if the response does not begin with 'OK'
  // display whatever is returned (probably error msgs)
    if (result.responseText.substring(0,2) != “OK”) {
        alert(result.responseText);
        return false;
    }
  return true;
}
function on_edit(result) {
        // do nothing
      return true;
}

<?php
// database connection parameters
$db='';
$host='';
$user='';
$pass='';

// connect to the MySQL database server
$dbh = mysql_connect($host,$user,$pass) or die(”Connection Error: ” . mysql_error());
// select the database
mysql_select_db($db) or die(”Error selecting '$db' database.”);

// get clean id
$id=mysql_real_escape_string($_POST['id']);

$fields = '';
$values = '';
// $exceptions - fields that will not be UPDATEd into table
//               i.e. 'submit, action, '; (note trailing comma and space!)
$exceptions='submit, id, ';

// format input POST fields into SQL syntax for the list of fields and values after SET
foreach ($_POST as $field => $value) {
  if (!preg_match(”/$field, /”, $exceptions)) {
    $value = mysql_real_escape_string($value);
    $fields .= “$field = '$value', “;
  }
}
// remove trailing “, ” from $fields
$fields = preg_replace('/, $/', '', $fields);
 
$query = “UPDATE tmpsale SET $fields WHERE id='$id'”;

//echo $query;    // for debugging, any output text that does not begin with “OK” will display in an alert box      

$result = mysql_query($query);
if (!$result) {
   die('Query error:' . mysql_error());
}

if (mysql_affected_rows($dbh) > 0) {
  echo “OK\\n”;
} else {
    echo “Update Failed.\\n”;
}
?>