Skip to content

Instantly share code, notes, and snippets.

@Simplesmente

Simplesmente/conn.php

Last active January 20, 2016 15:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Simplesmente/4b79689e23f3b431fd4f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Simplesmente/4b79689e23f3b431fd4f to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Simplesmente created this gist Jan 20, 2016.
    45 changes: 45 additions & 0 deletions conn.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,45 @@
    <?php

    /**
    * Conn.class [ CONEXÃO ]
    * Classe abstrata de conexão. Padrão SingleTon.
    * Retorna um objeto PDO pelo método estático getConn();
    *
    * @copyright (c) 2013, Robson V. Leite UPINSIDE TECNOLOGIA
    */
    abstract class Conn {

    private static $Host = HOST;
    private static $User = USER;
    private static $Pass = PASS;
    private static $Dbsa = DBSA;

    /** @var PDO */
    private static $Connect = null;

    /**
    * Conecta com o banco de dados com o pattern singleton.
    * Retorna um objeto PDO!
    */
    private static function Conectar() {
    try {
    if (self::$Connect == null):
    $dsn = 'mysql:host=' . self::$Host . ';dbname=' . self::$Dbsa;
    $options = [ PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES UTF8'];
    self::$Connect = new PDO($dsn, self::$User, self::$Pass, $options);
    endif;
    } catch (PDOException $e) {
    echo $e->getMessage();
    die;
    }

    self::$Connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    return self::$Connect;
    }

    /** Retorna um objeto PDO Singleton Pattern. */
    protected static function getConn() {
    return self::Conectar();
    }

    }