Skip to content
Snippets Groups Projects
Select Git revision
  • f12db57edc09bfb3f4710da29d46cf0f9092f7d6
  • main default protected
2 results

Database.php

Blame
  • Sofiane Lasri's avatar
    Sofiane Lasri authored
    f12db57e
    History
    Database.php 1.18 KiB
    <?php
    
    class Database
    {
        // les attributs static caractéristiques de la connexion
        static private $hostname = 'localhost';
        static private $database = 'iut-dev';
        static private $login = 'iut-dev-user';
        static private $password = 'p73i74KAV8lami2iyIpehE5ozic8GA';
    
        static private $tabUTF8 = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8");
    
        // l'attribut static qui matérialisera la connexion
        static private $pdo;
    
        // le getter public de cet attribut
        static public function pdo()
        {
            return self::$pdo;
        }
    
        // la fonction static de connexion qui initialise $pdo et lance la tentative de connexion
        static public function connect()
        {
            $hostname = config("DB_HOST");
            $database = config("DB_NAME");
            $login = config("DB_LOGIN");
            $password = config("DB_PASSWORD");
            $t = self::$tabUTF8;
            try {
                self::$pdo = new PDO("mysql:host=$hostname;dbname=$database", $login, $password, $t);
                self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            } catch (PDOException $e) {
                echo "Erreur de connexion : " . $e->getMessage() . "<br>";
            }
        }
    }
    
    ?>