Advertisement
Guest User

PDO

a guest
Nov 24th, 2016
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.52 KB | None | 0 0
  1. <?php
  2.     require_once 'conf.php';
  3.  
  4.     class Conecta extends conf{
  5.  
  6.         var $pdo;
  7.  
  8.         function __construct(){
  9.             $pdo = new PDO('mysql:host='.$this->host.':dbname='.$this->db, $this->usuario, $this->senha);
  10.         }
  11.  
  12.         function login($email, $senha){
  13.             $stmt = $this->PDO->prepare("SELECT * FROM usuarios WHERE email = :email AND senha = :senha");
  14.             $stmt->bindValue(":email",$email);
  15.             $stmt->bindValue(":senha", $senha);
  16.  
  17.             $exec = $stmt->execute();
  18.             $run = $stmt->fetchAll(PDO::FETCH_ASSOC);
  19.             return self::$run;
  20.         }
  21.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement