From a2fdd37ffb5a3cc80b6fedb332024057553148f8 Mon Sep 17 00:00:00 2001
From: polo <ordipolo@gmx.fr>
Date: Sun, 27 Nov 2022 02:34:34 +0100
Subject: =?UTF-8?q?connexion=20BDD=20orient=C3=A9e=20objet?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 php/ConnectionDatabase.php | 35 +++++++++++++++++++++++++++++++++++
 1 file changed, 35 insertions(+)
 create mode 100644 php/ConnectionDatabase.php

(limited to 'php/ConnectionDatabase.php')

diff --git a/php/ConnectionDatabase.php b/php/ConnectionDatabase.php
new file mode 100644
index 0000000..b26d0bd
--- /dev/null
+++ b/php/ConnectionDatabase.php
@@ -0,0 +1,35 @@
+<?php
+// php/ConnectionDatabase.php
+
+class Connection extends PDO
+{
+    // paramètres du constructeur de PDO, avec sqlite seul le premier est nécessaire
+    public static $dsn = ''; // Data Source Name = 1er paramètre
+    public static $user = '';
+    public static $password = '';
+    public static $options = '';
+    private static $Instance;
+    
+    public function __construct()
+    {
+        try
+        {
+            parent::__construct(self::$dsn); // renseigne la variable $dsn de la classe PDO
+            $this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // $this pour la méthode du parent PDO
+        }
+        catch(PDOException $e)
+        {
+            die('Erreur : '.$e->getMessage());
+        }
+    }
+    
+    // créer son objet avec: $bdd = Connection::getInstance();
+    public static function getInstance(): self
+    {
+        if(self::$Instance === null)
+        {
+            self::$Instance = new self();
+        }
+        return self::$Instance;
+    }
+}
-- 
cgit v1.2.3