Guest User

Untitled

a guest
Nov 23rd, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. function insert_employee() {
  2. global $con;
  3. if (isset($_POST['insert_post'])) {
  4. $fname = $_POST['first_name'];
  5. $lname = $_POST['last_name'];
  6. $email = $_POST['email'];
  7. $type = $_POST['type'];
  8. $username = $_POST['username'];
  9. $password = $_POST['password'];
  10.  
  11. if ($fname == '' || $lname == '' || $email == '' || $type == '' || $username == '' || $password == '' ) {
  12. echo 'please fill all values';
  13. } else {
  14.  
  15. $sql = "INSERT INTO users (username, password) VALUES ('$username', '$password')";
  16. mysqli_query($con, $sql);
  17.  
  18. $id = mysqli_insert_id($con);
  19.  
  20. if ($id) {
  21. $sql = "INSERT INTO employee (fname, lname, email, type, user_id) VALUES ($fname, $lname, $email, $type, $id)";
  22. mysqli_query($con, $sql);
  23. }
  24. }
  25. mysqli_close($con);
  26. }
  27. echo "Data Inserted";
  28. }
Add Comment
Please, Sign In to add comment