Advertisement
edfcsx

conexao pdo

Jul 13th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. <?php
  2. class Conexao{
  3.    
  4.     public static $host = 'localhost';
  5.     public static $dbname = 'treino';
  6.     public static $user = 'root';
  7.     public static $pass = '';
  8.  
  9.     private static $connect = null;
  10.  
  11.  
  12.     private static function conectar(){
  13.         try{
  14.             if (self::$connect == null){
  15.                 self::$connect = new PDO('mysql:host='.self::$host.';dbname='.self::$dbname.';charset=utf8', self::$user,self::$pass);
  16.             }
  17.         }catch (PDOException $e){
  18.             echo 'Não foi possivel conectar ao banco ', $e->getMessage();
  19.             die();
  20.         }
  21.         self::$connect->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND,'SET NAMES utf8');
  22.         self::$connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  23.         return self::$connect;
  24.     }
  25.  
  26.     function getConexao(){
  27.         return self::conectar();
  28.     }
  29.  
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement