Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- require('app-lib.php');
- isset($_POST['a'])? $action = $_POST['a'] : $action = "";
- $msg = null;
- isset($_POST['txtUserID'])? $userID = $_POST['txtUserID'] : $userID = gen_ID();
- isset($_POST['txtUserUsername'])? $userUsername = $_POST['txtUserUsername'] : $userUsername = "";
- isset($_POST['txtUserPassword'])? $userPassword = $_POST['txtUserPassword'] : $userPassword = "";
- isset($_POST['txtUserFirstName'])? $userFirstname = $_POST['txtUserFirstName'] : $userFirstname = "";
- isset($_POST['txtUserLastName'])? $userLastname = $_POST['txtUserLastName'] : $userLastname = "";
- isset($_POST['txtUserGroup'])? $userGroup = $_POST['txtUserGroup'] : $userGroup = "";
- isset($_POST['txtUserStatus'])? $userStatus = $_POST['txtUserStatus'] : $userStatus = "";
- isset($_POST['txtUserAddress'])? $userAddress = $_POST['txtUserAddress'] : $userAddress = "";
- isset($_POST['txtUserPhone'])? $userPhone = $_POST['txtUserPhone'] : $userPhone = "";
- isset($_POST['txtUserConfirm'])? $userConfirm = $_POST['txtUserConfirm'] : $userConfirm = "";
- $mode = "insertRec";
- if($action == "updateRec") {
- $query =
- "UPDATE lpa_users SET
- lpa_user_ID = '$userID',
- lpa_user_username = '$userUsername',
- lpa_user_password = '$userPassword',
- lpa_user_firstname = '$userFirstname',
- lpa_user_lastname = '$userLastname',
- lpa_user_group = '$userGroup',
- lpa_user_status = '$userStatus',
- lpa_user_address = '$userAddress',
- lpa_user_phone = '$userPhone',
- lpa_user_confirm = '$userConfirm'
- WHERE
- lpa_user_ID = '$sid' LIMIT 1
- ";
- openDB();
- $result = $db->query($query);
- if($db->error) {
- printf("Errormessage: %s\n", $db->error);
- exit;
- } else {
- header("Location: users.php?a=recUpdate&txtSearch=$txtSearch");
- exit;
- }
- }
- if($action == "insertRec") {
- $query =
- "INSERT INTO lpa_users (
- lpa_user_ID,
- lpa_user_username,
- lpa_user_password,
- lpa_user_firstname,
- lpa_user_lastname,
- lpa_user_group,
- lpa_user_status,
- lpa_user_address,
- lpa_user_phone,
- lpa_user_confirm
- ) VALUES (
- '$userID',
- '$userUsername',
- sha1('$userPassword'),
- '$userFirstname',
- '$userLastname',
- '$userGroup',
- '$userStatus',
- '$userAddress',
- '$userPhone',
- '$userConfirm'
- )
- ";
- openDB();
- $result = $db->query($query);
- if($db->error) {
- printf("Errormessage: %s\n", $db->error);
- exit;
- } else {
- header("Location: users.php?a=recInsert&txtSearch=".$userID);
- exit;
- }
- }
- if($action == "Edit") {
- $query = "INSERT * INTO lpa_users WHERE lpa_user_ID = '$sid' LIMIT 1";
- $result = $db->query($query);
- $row_cnt = $result->num_rows;
- $row = $result->fetch_assoc();
- $userID = $row['lpa_user_ID'];
- $userUsername = $row['lpa_user_username'];
- $userPassword = $row['lpa_user_password'];
- $userFirstname = $row['lpa_user_firstname'];
- $userLastname = $row['lpa_user_lastname'];
- $userGroup = $row['lpa_user_group'];
- $userStatus = $row['lpa_user_status'];
- $userAddress = $row['lpa_user_address'];
- $userPhone = $row['lpa_user_phone'];
- $userConfirm = $row['lpa_user_confirm'];
- $mode = "updateRec";
- }
- build_header($displayName);
- $fieldSpacer = "5px";
- ?>
- <div id="content">
- <div class="sectionHeader">New Customer Registration</div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div>First Name:
- <input name="fldfirstName"
- id="fldfirstName"
- style="width: 180px;text-align: right">
- </div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div>Last Name: <input
- name="fldlastName"
- id="fldlastName"
- style="width: 180px;text-align: right">
- </div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div> Username: </div>
- <input name="txtUserUsername" id="txtUserUsername" placeholder="Username" value="<?PHP echo $userUsername; ?>" style="width: 180px;text-align: right" title="Username">
- </div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div> Password: </div>
- <input name="txtUserPassword" id="txtUserPassword" placeholder="Password" value="<?PHP echo $userPassword; ?>" style="width: 180px;text-align: right" title="Password">
- </div>
- <div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <label for="confirm">Confirm your password:</label>
- <input name="txtUserPassword" id="txtUserPassword" placeholder="Enter your password again" value="<?PHP echo $userPassword; ?>" style="width: 180px;text-align: right" title="Password">
- </div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div> Address: </div>
- <input name="txtUserAddress" id="txtUserAddress" placeholder="Address" style="width: 180px;text-align: right" title="Address"><?PHP echo $userAddress; ?>
- </textarea>
- </div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div> Phone Number: </div>
- <input name="txtUserPhone" id="txtUserPhone" placeholder="Phone" style="width: 180px;text-align: right" title="Phone"><?PHP echo $userPhone; ?>
- </textarea>
- </div>
- <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
- <div> Group: </div>
- <select name="txtUserGroup">
- <option id="txtUserGroup" placeholder="Group" value="user" style="width: 180px;text-align: right" title="Group">User</option> </select>
- </div>
- <div class="optBar">
- <button type="button" id="btnUsersSave">Register</button>
- <button type="button" onclick="navMan('users.php')">Cancel</button>
- <?PHP if($action == "Edit") { ?>
- <button type="button" onclick="delRec('<?PHP echo $sid; ?>')" style="color: darkred; margin-left: 20px">DELETE</button>
- <?PHP } ?>
- </div>
- </div>
- <script>
- var usersRecStatus = "<?PHP echo $userStatus; ?>";
- if(usersRecStatus == "a") {
- $('#txtUsersStatusActive').prop('checked', true);
- } else {
- $('#txtUsersStatusInactive').prop('checked', true);
- }
- $("#btnUsersSave").click(function(){
- $("#frmUsersRec").submit();
- });
- function delRec(ID) {
- navMan("register-2.php?sid=" + ID + "&a=delRec");
- }
- setTimeout(function(){
- $("#txtUserUsername").focus();
- },1);
- </script>
- <?PHP
- build_footer();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement