leonsuke

Login PDO

Sep 30th, 2016
240
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. <?php
  2. session_start();
  3.  
  4. defined("VALIDASI", TRUE);
  5.  
  6. require_once "dbconn.php";
  7.  
  8. $status = "Online";
  9. $kata_sandi = isset($_POST["kata_sandi"]) ? $_POST["kata_sandi"] : "FALSE";
  10. $nama_pengguna = isset($_POST["nama_pengguna"]) ? $_POST["nama_pengguna"] : "FALSE";
  11.  
  12. $sql1 = $con->prepare("SELECT * FROM tbl_pengguna WHERE nama_pengguna = ?");
  13. $sql1->bindParam(1, $nama_pengguna);
  14. $sql1->execute();
  15. $fetch1 = $sql1->fetch(PDO::FETCH_ASSOC);
  16.  
  17. if (count($fetch1) > 0 && password_verify($kata_sandi, $fetch1["kata_sandi"])) {
  18.  
  19. $sql3 = $con->prepare("INSERT INTO tbl_absensi (id_absensi, id_pengguna, waktu_absensi) VALUES (UUID(), ?, NOW())");
  20. $sql3->bindParam(1, $fetch1["id_pengguna"]);
  21. if ($sql3->execute()) {
  22. $sql4 = $con->prepare("UPDATE tbl_pengguna SET status = ? WHERE id_pengguna = ?");
  23. $sql4->bindParam(1, $status);
  24. $sql4->bindParam(2, $fetch1["id_pengguna"]);
  25. if ($sql4->execute()) { $_SESSION["nama_pengguna"] = $fetch1["nama_pengguna"]; header("location: /mahasiswa/"); }
  26. }
  27. } else { header("location: /?err=2"); }
Advertisement
Add Comment
Please, Sign In to add comment