Guest User

Untitled

a guest
Mar 9th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1. public function selectLogin($userName, $password){
  2.         $link= Connect::getConnect();
  3.            
  4.         $user= new User();
  5.         $userName= $user->setUserName($userName);
  6.         $password= $user->setPassword($password);
  7.        
  8.         $sql= "SELECT (username, password)
  9.                FROM User
  10.                WHERE username = :username AND password = :password";
  11.        
  12.         $param= array(':username'=>$user->getUserName(),
  13.                       ':password'=>$user->getPassword());
  14.        
  15.         try {
  16.             $stmt= $link->prepare($sql);
  17.             $stmt->execute($param);
  18.            
  19.             // A execução da consulta está retornando false!
  20.             var_dump($stmt->execute($param));
  21.            
  22.             $query = $stmt->fetchAll(PDO::FETCH_ASSOC);
  23.            
  24.         } catch (PDOException $e){
  25.             $e->getLine();
  26.             $e->getMessage();          
  27.         } catch (Exception $e) {
  28.             $e->getMessage();
  29.         }
  30.        
  31.     }
Add Comment
Please, Sign In to add comment