Guest User

Untitled

a guest
Feb 19th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.94 KB | None | 0 0
  1. if($crud->create($fname,$mname,$lname,$address,$contactno,$email,$username,$password))
  2. {
  3. header("Location: add-emp.php?inserted");
  4. }
  5. else
  6. {
  7. header("Location: add-emp.php?failure");
  8. }
  9. }
  10. ?>
  11. <?php include_once 'header.php'; ?>
  12. <div class="clearfix"></div>
  13.  
  14. <div class="container">
  15.  
  16. <div class="clearfix"></div>
  17.  
  18. <h2>Add Employee</h2>
  19. <hr>
  20.  
  21. <form method='post'>
  22. <?php
  23. if(isset($_GET['inserted']))
  24. {
  25. ?>
  26. <div class="alert alert-success alert-dismissable fade show">
  27. <button type="button" class="close" data-dismiss="alert">&times;</button>
  28. <strong>Success!</strong> Record was inserted successfully.
  29. </div>
  30. <?php
  31. }
  32. else if(isset($_GET['failure']))
  33. {
  34. ?>
  35. <div class="alert alert-danger alert-dismissable fade show">
  36. <button type="button" class="close" data-dismiss="alert">&times;</button>
  37. <strong>Error!</strong> Please try again.
  38. </div>
  39. <?php
  40. }
  41. ?>
  42. <table class='table table-bordered'>
  43. <tr>
  44. <td colspan="2"><h5 class="text-center"><i class="fas fa-info-circle"></i>&nbsp;Personal Details</h5></td>
  45. </tr>
  46. <tr>
  47. <td>First Name</td>
  48. <td><input type='text' name='fname' class='form-control' required></td>
  49. </tr>
  50.  
  51. <tr>
  52. <td>Middle Name</td>
  53. <td><input type='text' name='mname' class='form-control' required></td>
  54. </tr>
  55.  
  56. <tr>
  57. <td>Last Name</td>
  58. <td><input type='text' name='lname' class='form-control' required></td>
  59. </tr>
  60.  
  61. <tr>
  62. <td>Address</td>
  63. <td><input type='text' name='address' class='form-control' required></td>
  64. </tr>
  65.  
  66. <tr>
  67. <td>Contact No</td>
  68. <td><input type='text' name='contactno' class='form-control' required></td>
  69. </tr>
  70.  
  71. <tr>
  72. <td>Email</td>
  73. <td><input type='text' name='email' class='form-control' required></td>
  74. </tr>
  75.  
  76. <tr>
  77. <td colspan="2"><h5 class="text-center"><i class="fas fa-info-circle"></i>&nbsp;Account Details</h5></td>
  78. </tr>
  79.  
  80. <tr>
  81. <td>Username</td>
  82. <td><input type='text' name='username' class='form-control' required></td>
  83. </tr>
  84.  
  85. <tr>
  86. <td>Password</td>
  87. <td><input type='password' name='password' class='form-control' required></td>
  88. </tr>
  89.  
  90. <tr>
  91. <td colspan="2">
  92. <button type="submit" class="btn btn-primary" name="btn-save">
  93. <i class="fas fa-save"></i>&nbsp; Save</button>
  94. <a href="admin.php" class="btn btn-large btn-success"><i class="fas fa-long-arrow-alt-left"></i> &nbsp; Back to index</a>
  95. </td>
  96. </tr>
  97.  
  98. </table>
  99. </form>
  100. </div>
  101. <?php include_once 'footer.php'; ?>
  102.  
  103. {
  104. private $db;
  105.  
  106. function __construct($DB_con)
  107. {
  108. $this->db = $DB_con;
  109. }
  110.  
  111. public function create($fname,$mname,$lname,$address,$contactno,$email,$username,$password)
  112. {
  113. try
  114. {
  115. $role = 2;
  116. $join_date = date('Y-m-d H:i:s');
  117. $hashed_password = password_hash($password, PASSWORD_DEFAULT);
  118.  
  119. $stmt = $this->db->prepare("INSERT INTO tbluser(`first_name`,`middle_name`,`last_name`,`address`,`contact_no`,`email`,`username`,`password`,`join_date`,`roles`)
  120. VALUES(:fname, :mname, :lname, :address, :contactno, :email, :username, :password, :join_date, :roles)");
  121. $stmt->bindparam(":fname", $fname);
  122. $stmt->bindparam(":mname", $mname);
  123. $stmt->bindparam(":lname", $lname);
  124. $stmt->bindparam(":address", $address);
  125. $stmt->bindparam(":contactno", $contactno);
  126. $stmt->bindparam(":username", $username);
  127. $stmt->bindparam(":password", $hashed_password);
  128. $stmt->bindparam(":email", $email);
  129. $stmt->bindparam(":join_date", $join_date);
  130. $stmt->bindparam(":roles", $role);
  131. $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));
  132. return true;
  133. }
  134. catch(PDOException $e)
  135. {
  136. echo $e->getMessage();
  137. return false;
  138. }
  139.  
  140. }
Add Comment
Please, Sign In to add comment