Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. extract($_POST, EXTR_SKIP);
  2.  
  3. $stmt = $pdo->prepare('SELECT COUNT(*) FROM user WHERE user = :user AND password = :password AND status = :status');
  4. $stmt->bindParam('user', $user);
  5. $stmt->bindParam('password', md5($password));
  6. $stmt->bindValue('status', 1);
  7. $stmt->execute();
  8.  
  9. if($stmt->fetchColumn() > 0){
  10.  
  11. $stmt = $pdo->prepare('SELECT COUNT(*) FROM user WHERE user = :user AND time > :time AND status = :status');
  12. $stmt->bindParam('user', $user);
  13. $stmt->bindValue('time', $lifeTime);
  14. $stmt->bindValue('status', 1);
  15. $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement