php file name: edit_user.php
<?
include('../connections/theConnection.php'); //connections
$newid = $_POST['id']; //row id. this is the id of the selected row
$uname = $_POST['uname']; //some variable
$pass = md5($_POST['pass']); //some variable
$email = $_POST['email']; //some variable
$fname = $_POST['fname']; //some variable
$mname = $_POST['mname']; //some variable
$lname = $_POST['lname']; //some variable
$cnumber = $_POST['cnumber']; //some variable
$level = $_POST['level']; //some variable
$operation = $_POST['oper']; //can be “add” “edit” “del”
if ($operation == “edit”)
{
$result = mysql_query(“UPDATE user_tbl SET uname = '$uname', fname = '$fname', mname = '$mname', lname = '$lname', email = '$email', pass = '$pass', cnumber = '$cnumber', level = '$level' WHERE uid = '$newid'”);
}
else if ($operation == “add”) {
$result = mysql_query(“INSERT INTO user_tbl(uname, fname, mname, lname, email, pass, cnumber, level, status) VALUES ('$uname', '$fname', '$mname', '$lname', '$email','$pass', '$cnumber','$level', 2)”);
}
else if($operation == “del”)
{
$result = mysql_query(“UPDATE user_tbl SET del = 2 WHERE uid = '$newid'”);
}
mysql_close($db);
?>
the javascript required:
jQuery(”#btn_add_edit”).click(function(){
var gr = jQuery(”#my_jqgrid”).getGridParam('selrow');
if( gr != null ) {
jQuery(”#my_jqgrid”).editGridRow(gr,{height:280,reloadAfterSubmit:true});
}
else {
jQuery(”#my_jqgrid”).editGridRow(”new”,{height:280,reloadAfterSubmit:true});
}
});
the html required:
SPAN { font-family: “Courier New”; font-size: 10pt; color: #000000; background: #FFFFFF; }A { text-decoration: none; font-weight: bold; color:#000000;}.S1 { color: #009300; background: #FFF7F7; }.S2 { color: #00008B; background: #FFF7F7; }<button type='submit' id='btn_add_edit'>ADD/EDIT
____________________________________________________________________________
my simple
