Guest User

Untitled

a guest
Nov 18th, 2018
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. Çalışan versiyon.
  2. $userquoted = $this->db->quote($user);
  3. $passquoted = $this->db->quote($pass);
  4.  
  5. $login= $this->db->prepare("SELECT id, username, password, factory_id, email FROM users WHERE username = $userquoted AND password = SHA1($passquoted) LIMIT 1");
  6.  
  7. $login->setFetchMode(PDO::FETCH_ASSOC);
  8. $login->execute();
  9.  
  10.  
  11.  
  12. /*Çalışmayan Parametreli versiyon */
  13. Parametreli kullanımda string sorunu geliyor çünkü PDO::quote(); stringi tek tırnak içerisine alıyor.
  14.  
  15. $userquoted = $this->db->quote($user);
  16. $passquoted = $this->db->quote($pass);
  17.  
  18. $login= $this->db->prepare("SELECT id, username, password, factory_id, email FROM users WHERE username = :user AND password = SHA1(:pass) LIMIT 1");
  19.  
  20. $login->setFetchMode(PDO::FETCH_ASSOC);
  21. $login->execute(
  22. array(
  23. ":user"=>$userquoted,
  24. ":pass"=>$passquoted
  25. )
  26. );
Add Comment
Please, Sign In to add comment