Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if($crud->create($fname,$mname,$lname,$address,$contactno,$email,$username,$password))
- {
- header("Location: add-emp.php?inserted");
- }
- else
- {
- header("Location: add-emp.php?failure");
- }
- }
- ?>
- <?php include_once 'header.php'; ?>
- <div class="clearfix"></div>
- <div class="container">
- <div class="clearfix"></div>
- <h2>Add Employee</h2>
- <hr>
- <form method='post'>
- <?php
- if(isset($_GET['inserted']))
- {
- ?>
- <div class="alert alert-success alert-dismissable fade show">
- <button type="button" class="close" data-dismiss="alert">×</button>
- <strong>Success!</strong> Record was inserted successfully.
- </div>
- <?php
- }
- else if(isset($_GET['failure']))
- {
- ?>
- <div class="alert alert-danger alert-dismissable fade show">
- <button type="button" class="close" data-dismiss="alert">×</button>
- <strong>Error!</strong> Please try again.
- </div>
- <?php
- }
- ?>
- <table class='table table-bordered'>
- <tr>
- <td colspan="2"><h5 class="text-center"><i class="fas fa-info-circle"></i> Personal Details</h5></td>
- </tr>
- <tr>
- <td>First Name</td>
- <td><input type='text' name='fname' class='form-control' required></td>
- </tr>
- <tr>
- <td>Middle Name</td>
- <td><input type='text' name='mname' class='form-control' required></td>
- </tr>
- <tr>
- <td>Last Name</td>
- <td><input type='text' name='lname' class='form-control' required></td>
- </tr>
- <tr>
- <td>Address</td>
- <td><input type='text' name='address' class='form-control' required></td>
- </tr>
- <tr>
- <td>Contact No</td>
- <td><input type='text' name='contactno' class='form-control' required></td>
- </tr>
- <tr>
- <td>Email</td>
- <td><input type='text' name='email' class='form-control' required></td>
- </tr>
- <tr>
- <td colspan="2"><h5 class="text-center"><i class="fas fa-info-circle"></i> Account Details</h5></td>
- </tr>
- <tr>
- <td>Username</td>
- <td><input type='text' name='username' class='form-control' required></td>
- </tr>
- <tr>
- <td>Password</td>
- <td><input type='password' name='password' class='form-control' required></td>
- </tr>
- <tr>
- <td colspan="2">
- <button type="submit" class="btn btn-primary" name="btn-save">
- <i class="fas fa-save"></i> Save</button>
- <a href="admin.php" class="btn btn-large btn-success"><i class="fas fa-long-arrow-alt-left"></i> Back to index</a>
- </td>
- </tr>
- </table>
- </form>
- </div>
- <?php include_once 'footer.php'; ?>
- {
- private $db;
- function __construct($DB_con)
- {
- $this->db = $DB_con;
- }
- public function create($fname,$mname,$lname,$address,$contactno,$email,$username,$password)
- {
- try
- {
- $role = 2;
- $join_date = date('Y-m-d H:i:s');
- $hashed_password = password_hash($password, PASSWORD_DEFAULT);
- $stmt = $this->db->prepare("INSERT INTO tbluser(`first_name`,`middle_name`,`last_name`,`address`,`contact_no`,`email`,`username`,`password`,`join_date`,`roles`)
- VALUES(:fname, :mname, :lname, :address, :contactno, :email, :username, :password, :join_date, :roles)");
- $stmt->bindparam(":fname", $fname);
- $stmt->bindparam(":mname", $mname);
- $stmt->bindparam(":lname", $lname);
- $stmt->bindparam(":address", $address);
- $stmt->bindparam(":contactno", $contactno);
- $stmt->bindparam(":username", $username);
- $stmt->bindparam(":password", $hashed_password);
- $stmt->bindparam(":email", $email);
- $stmt->bindparam(":join_date", $join_date);
- $stmt->bindparam(":roles", $role);
- $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));
- return true;
- }
- catch(PDOException $e)
- {
- echo $e->getMessage();
- return false;
- }
- }
Add Comment
Please, Sign In to add comment