Advertisement
LucianoCharles2017

Conexao PDO

Oct 17th, 2017
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.07 KB | None | 0 0
  1. <?php
  2.  
  3. class Conn {
  4.  
  5.     private static $Connect = null;
  6.     private static $host = 'localhost';
  7.     private static $user = 'root';
  8.     private static $pass = '';
  9.     private static $dbname = 'grupo++';
  10.  
  11.     private static function Connection() {
  12.  
  13.         try {
  14.  
  15.             if (self::$Connect == null) {
  16.  
  17.                 $options = [
  18.                     PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES UTF8"
  19.                 ];
  20.                 self::$Connect = new PDO("mysql:dbname=" . self::$dbname . ";host=" . self::$host, self::$user, self::$pass, $options);
  21.  
  22.                 self::$Connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  23.             }
  24.         } catch (PDOException $e) {
  25.             die($e->getMessage());
  26.         }
  27.  
  28.         return self::$Connect;
  29.     }
  30.  
  31.     public static function getConn() {
  32.         return self::Connection();
  33.     }
  34.  
  35.     public static function getQuery($sql) {
  36.         $stmt = self::getConn()->query($sql);
  37.         return $stmt->fetchAll();
  38.     }
  39.  
  40. }
  41.  
  42. var_dump(Conn::getQuery('SELECT * FROM usuarios'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement