if (empty($_POST['txtUserId'])) { $msg = "User ID is empty!"; } else { selectUsersUsingId($_POST['txtUserId']); } } else { if ($submit1 == "Update") { mysql_query("update tblusers set fname= '{$_POST['txtFname']}', mname = '{$_POST['txtMname']}', lname = '{$_POST['txtLname']}', no_street = '{$_POST['txtNoStreet']}', city = '{$_POST['txtCity']}', contact_no = '{$_POST['txtContactNo']}', dob = '{$_POST['txtDOB']}', age = '{$_POST['txtAge']}', gender = '{$_POST['selGender']}' where user_id = '{$_POST['txtUserId']}'") or die(mysql_error()); $msg = "Successfully updated the record!"; disableComponents(); } else { if ($submit2 == "Delete") { mysql_query("delete from tblusers where user_id = '{$_POST['txtUserId']}'") or die(mysql_error()); mysql_query("delete from tblaccount where user_id = '{$_POST['txtUserId']}'") or die(mysql_error()); $msg = "Successfully deleted the record!"; disableComponents(); } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="css/styles.css" rel="stylesheet" type="text/css" /> <title>Dadads - Administrator</title> </head> <body id="adminpage"> <div id="main_wrapper"> <div id="main_header">
function selectUsersUsingId($uID) { global $msg; global $userID; global $fname; global $mname; global $lname; global $noSt; global $city; global $contactNo; global $dob; global $age; global $gender; global $selectMaleGender; global $selectFemaleGender; $sqlSelUsers = mysql_query("select * from tblusers where user_id = '{$uID}'") or die(mysql_error()); if (mysql_num_rows($sqlSelUsers) >= 1) { $getRowUser = mysql_fetch_array($sqlSelUsers); $userID = $getRowUser["user_id"]; $fname = $getRowUser["fname"]; $mname = $getRowUser["mname"]; $lname = $getRowUser["lname"]; $noSt = $getRowUser["no_street"]; $city = $getRowUser["city"]; $contactNo = $getRowUser["contact_no"]; $dob = $getRowUser["dob"]; $age = $getRowUser["age"]; $gender = $getRowUser["gender"]; if ($gender == "Male") { $selectMaleGender = "selected"; } else { if ($gender == "Female") { $selectFemaleGender = "selected"; } } enableComponents(); } else { $msg = "No record found!"; disableComponents(); } }