Advertisement
InstruktuIT

Sintak Login dengan Prepared Statement pada PHP

Apr 23rd, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.57 KB | None | 0 0
  1. <?php
  2.  
  3. if(isset($_POST['login'])) {
  4.     $id_user = $_POST['id_user'];
  5.     $pass = md5($_POST['pass']);
  6.  
  7.     try {
  8.         $sql = "SELECT * FROM tbuser WHERE id_user = :id_user AND pass = :pass";
  9.         $stmt = $db->prepare($sql);
  10.         $stmt->bindParam(':id_user', $id_user);
  11.         $stmt->bindParam(':pass', $pass);
  12.         $stmt->execute();
  13.  
  14.         $count = $stmt->rowCount();
  15.         if($count == 1) {
  16.             header("location: index.php");
  17.             return;
  18.         }else{
  19.             echo "ID. User dan Password salah !";
  20.         }
  21.     }catch(PDOException $e) {
  22.         echo $e->getMessage();
  23.     }
  24. }
  25.  
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement