From 6b55446d12a5c39d5a4a4584bfabc7507c2f9b74 Mon Sep 17 00:00:00 2001
From: polo <ordipolo@gmx.fr>
Date: Fri, 2 Dec 2022 15:29:02 +0100
Subject: date<->timestamp, ===, renommage, latex

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

(limited to 'php/Connection.php')

diff --git a/php/Connection.php b/php/Connection.php
new file mode 100644
index 0000000..bdc7aa9
--- /dev/null
+++ b/php/Connection.php
@@ -0,0 +1,35 @@
+<?php
+// php/Connection.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