Advertisement
Guest User

Untitled

a guest
Dec 10th, 2018
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 6.58 KB | None | 0 0
  1. <?PHP
  2. require('app-lib.php');
  3. isset($_POST['a'])? $action = $_POST['a'] : $action = "";
  4. $msg = null;
  5.  
  6.   isset($_POST['txtUserID'])? $userID               = $_POST['txtUserID']           : $userID = gen_ID();
  7.   isset($_POST['txtUserUsername'])? $userUsername   = $_POST['txtUserUsername']     : $userUsername = "";
  8.   isset($_POST['txtUserPassword'])? $userPassword   = $_POST['txtUserPassword']     : $userPassword = "";
  9.   isset($_POST['txtUserFirstName'])? $userFirstname = $_POST['txtUserFirstName']    : $userFirstname = "";
  10.   isset($_POST['txtUserLastName'])? $userLastname   = $_POST['txtUserLastName']     : $userLastname = "";
  11.   isset($_POST['txtUserGroup'])? $userGroup         = $_POST['txtUserGroup']        : $userGroup = "";
  12.   isset($_POST['txtUserStatus'])? $userStatus       = $_POST['txtUserStatus']       : $userStatus = "";
  13.  
  14.   isset($_POST['txtUserAddress'])? $userAddress     = $_POST['txtUserAddress'] : $userAddress = "";
  15.   isset($_POST['txtUserPhone'])? $userPhone         = $_POST['txtUserPhone'] : $userPhone = "";
  16.   isset($_POST['txtUserConfirm'])? $userConfirm     = $_POST['txtUserConfirm'] : $userConfirm = "";
  17.  
  18.   $mode = "insertRec";
  19.   if($action == "updateRec") {
  20.     $query =
  21.       "UPDATE lpa_users SET
  22.         lpa_user_ID = '$userID',
  23.         lpa_user_username = '$userUsername',
  24.          lpa_user_password  = '$userPassword',
  25.         lpa_user_firstname = '$userFirstname',
  26.         lpa_user_lastname = '$userLastname',
  27.         lpa_user_group = '$userGroup',
  28.         lpa_user_status = '$userStatus',
  29.          
  30.          lpa_user_address = '$userAddress',
  31.          lpa_user_phone = '$userPhone',
  32.          lpa_user_confirm = '$userConfirm'
  33.       WHERE
  34.         lpa_user_ID = '$sid' LIMIT 1
  35.      ";
  36.      openDB();
  37.      $result = $db->query($query);
  38.      if($db->error) {
  39.        printf("Errormessage: %s\n", $db->error);
  40.        exit;
  41.      } else {
  42.          header("Location: users.php?a=recUpdate&txtSearch=$txtSearch");
  43.        exit;
  44.      }
  45.   }
  46.   if($action == "insertRec") {
  47.     $query =
  48.       "INSERT INTO lpa_users (
  49.         lpa_user_ID,
  50.         lpa_user_username,
  51.          lpa_user_password,
  52.         lpa_user_firstname,
  53.         lpa_user_lastname,
  54.         lpa_user_group,
  55.         lpa_user_status,
  56.          
  57.          lpa_user_address,
  58.          lpa_user_phone,
  59.          lpa_user_confirm
  60.          
  61.       ) VALUES (
  62.         '$userID',
  63.         '$userUsername',
  64.          sha1('$userPassword'),
  65.         '$userFirstname',
  66.         '$userLastname',
  67.         '$userGroup',
  68.         '$userStatus',
  69.          
  70.          '$userAddress',
  71.          '$userPhone',
  72.          '$userConfirm'
  73.       )
  74.      ";
  75.     openDB();
  76.     $result = $db->query($query);
  77.     if($db->error) {
  78.       printf("Errormessage: %s\n", $db->error);
  79.       exit;
  80.     } else {
  81.       header("Location: users.php?a=recInsert&txtSearch=".$userID);
  82.       exit;
  83.     }
  84.   }
  85.  
  86.   if($action == "Edit") {
  87.     $query = "INSERT * INTO lpa_users WHERE lpa_user_ID = '$sid' LIMIT 1";
  88.     $result = $db->query($query);
  89.     $row_cnt = $result->num_rows;
  90.     $row = $result->fetch_assoc();
  91.     $userID         = $row['lpa_user_ID'];
  92.     $userUsername   = $row['lpa_user_username'];
  93.     $userPassword   = $row['lpa_user_password'];
  94.     $userFirstname  = $row['lpa_user_firstname'];
  95.     $userLastname   = $row['lpa_user_lastname'];
  96.     $userGroup      = $row['lpa_user_group'];
  97.     $userStatus     = $row['lpa_user_status'];
  98.  
  99.     $userAddress    = $row['lpa_user_address'];
  100.     $userPhone      = $row['lpa_user_phone'];
  101.     $userConfirm    = $row['lpa_user_confirm'];
  102.  
  103.     $mode = "updateRec";
  104.   }
  105.   build_header($displayName);
  106.   $fieldSpacer = "5px";
  107. ?>
  108.   <div id="content">
  109.  
  110.     <div class="sectionHeader">New Customer Registration</div>
  111.     <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  112.     <div>First Name:
  113.         <input name="fldfirstName"
  114.                id="fldfirstName"
  115.                style="width: 180px;text-align: right">
  116.     </div>
  117.     <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  118.     <div>Last Name: <input
  119.         name="fldlastName"
  120.         id="fldlastName"
  121.         style="width: 180px;text-align: right">
  122.     </div>
  123.         <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  124.         <div> Username: </div>
  125.         <input name="txtUserUsername" id="txtUserUsername" placeholder="Username" value="<?PHP echo $userUsername; ?>" style="width: 180px;text-align: right"  title="Username">
  126.       </div>
  127.         <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  128.          <div> Password: </div>
  129.         <input name="txtUserPassword" id="txtUserPassword" placeholder="Password" value="<?PHP echo $userPassword; ?>" style="width: 180px;text-align: right"  title="Password">
  130.       </div>
  131.     <div>
  132.         <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  133.         <label for="confirm">Confirm your password:</label>
  134.         <input name="txtUserPassword" id="txtUserPassword" placeholder="Enter your password again" value="<?PHP echo $userPassword; ?>" style="width: 180px;text-align: right"  title="Password">
  135.     </div>
  136.  
  137.  
  138.       <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  139.       <div> Address: </div>
  140.         <input name="txtUserAddress" id="txtUserAddress" placeholder="Address" style="width: 180px;text-align: right"  title="Address"><?PHP echo $userAddress; ?>
  141.           </textarea>
  142.       </div>
  143.       <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  144.       <div> Phone Number: </div>
  145.         <input name="txtUserPhone" id="txtUserPhone" placeholder="Phone" style="width: 180px;text-align: right"  title="Phone"><?PHP echo $userPhone; ?>
  146.           </textarea>
  147.       </div>
  148.  
  149.       <div style="margin-top: <?PHP echo $fieldSpacer; ?>">
  150.       <div> Group: </div>
  151.         <select name="txtUserGroup">
  152.         <option id="txtUserGroup" placeholder="Group" value="user" style="width: 180px;text-align: right"  title="Group">User</option> </select>
  153.       </div>
  154.  
  155.  
  156.     <div class="optBar">
  157.       <button type="button" id="btnUsersSave">Register</button>
  158.       <button type="button" onclick="navMan('users.php')">Cancel</button>
  159.       <?PHP if($action == "Edit") { ?>
  160.       <button type="button" onclick="delRec('<?PHP echo $sid; ?>')" style="color: darkred; margin-left: 20px">DELETE</button>
  161.       <?PHP } ?>
  162.     </div>
  163.   </div>
  164.   <script>
  165.     var usersRecStatus = "<?PHP echo $userStatus; ?>";
  166.     if(usersRecStatus == "a") {
  167.       $('#txtUsersStatusActive').prop('checked', true);
  168.     } else {
  169.       $('#txtUsersStatusInactive').prop('checked', true);
  170.     }
  171.     $("#btnUsersSave").click(function(){
  172.         $("#frmUsersRec").submit();
  173.     });
  174.     function delRec(ID) {
  175.       navMan("register-2.php?sid=" + ID + "&a=delRec");
  176.     }
  177.     setTimeout(function(){
  178.       $("#txtUserUsername").focus();
  179.     },1);
  180.   </script>
  181. <?PHP
  182. build_footer();
  183. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement