Advertisement
Guest User

Untitled

a guest
Nov 28th, 2014
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. try
  2. {
  3. $query = 'SELECT userID, firstname, surname, email FROM jinx_users WHERE email = :email AND password = :password';
  4. $this->dbh->beginTransaction();
  5. $stmt = $this->dbh->prepare($query);
  6. $stmt->bindParam(':email', $email, PDO::PARAM_STR);
  7. $stmt->bindParam(':password', $password, PDO::PARAM_STR);
  8. $stmt->execute();
  9. if($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  10. return true;
  11. }else{
  12. return false;
  13. }
  14. $stmt = null;
  15. }
  16. catch (Exception $e)
  17. {
  18. $stmt = null;
  19. $this->dbh->rollback();
  20. exit();
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement