X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=lib%2Fdb.php;h=c7c2d48c71f9cb45e756b1151576b7e125e36c1a;hb=77e900523470eb7de54f2b92794177b54c3ad1bf;hp=0f280a459e8efbdbeb55c0de5730481678b6cf9b;hpb=6405835a808d5ac4986ff463a7be0b146058440d;p=Project_webapp.git

diff --git a/lib/db.php b/lib/db.php
index 0f280a4..c7c2d48 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -9,6 +9,7 @@ class CustomDB
     public $connected;
     private $current_pquery;
     private $current_stmt;
+    private $current_result;
 
     /**
      * [__construct description]
@@ -19,18 +20,22 @@ class CustomDB
      */
     public function __construct($host, $username, $password, $dbname)
     {
-        $connection = new mysqli($host, $username, $password, $dbname);
-        $this->connection = $connection;
+        $this->connection = new mysqli($host, $username, $password, $dbname);
 
         if (!$this->connection->connect_errno) {
             $this->connected = true;
         } else {
-            die('Fail to connect to the RDBMS');
+            die('Fail to connect to the RDBMS.');
         }
 
         return $this->connection;
     }
 
+    /* public function __destruct()
+    {
+        $this->close();
+    } */
+
     /**
      * [close description]
      * @return [type] [description]
@@ -40,7 +45,7 @@ class CustomDB
         if ($this->connected && $this->connection->close()) {
             $this->connected = false;
         } else {
-            die('Fail to close the connection to the RDBMS');
+            die('Fail to close the connection to the RDBMS.');
         }
     }
 
@@ -51,10 +56,10 @@ class CustomDB
      */
     public function query($sql_query)
     {
-        if ($this->connected && !($query_result = $this->connection->query($sql_query))) {
-            echo "Fail to execute the SQL query : " . $sql_query;
+        if ($this->connected && !($this->current_result = $this->connection->query($sql_query))) {
+            echo "Fail to execute the SQL query : " . $sql_query . "<br>";
         }
-        return $query_result;
+        return $this->current_result;
     }
 
     /**
@@ -68,7 +73,7 @@ class CustomDB
         if ($this->connected && !($this->current_stmt = $this->connection->prepare($this->current_pquery))) {
             // Empty the currently stored prepared query in the failure case
             $this->current_pquery = "";
-            echo "Fail to prepare SQL query : (" . $this->connection->errno . ") " . $this->connection->error . " - " . $this->current_pquery;
+            echo "Fail to prepare SQL query : (" . $this->connection->errno . ") " . $this->connection->error . " - " . $this->current_pquery . "<br>";
         }
         return $this->current_stmt;
     }
@@ -78,11 +83,11 @@ class CustomDB
      * @param  [type] $params [description]
      * @return [type]         [description]
      */
-    public function prepared_query_bind_param(...$params)
+    public function prepared_query_bind_param($types, $params)
     {
-        $rt_val = $this->current_stmt->bind_param($params);
+        $rt_val = $this->current_stmt->bind_param($types, ...$params);
         if (!$rt_val) {
-            echo "Fail to link parameters to SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery;
+            echo "Fail to link parameters to SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
         }
         return $rt_val;
     }
@@ -95,7 +100,25 @@ class CustomDB
     {
         $rt_val = $this->current_stmt->execute();
         if (!$rt_val) {
-            echo "Fail to execute SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery;
+            echo "Fail to execute SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
+        }
+        return $rt_val;
+    }
+
+    public function get_pquery_result()
+    {
+        $rt_val = $this->current_result = $this->current_stmt->get_result();
+        if (!$rt_val) {
+            echo "Fail to fill SQL query result : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
+        }
+        return $rt_val;
+    }
+
+    public function get_result_array()
+    {
+        $rt_val = $this->current_result->fetch_array();
+        if (!$rt_val) {
+            echo "Fail to build SQL query result array : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
         }
         return $rt_val;
     }
@@ -108,7 +131,7 @@ class CustomDB
     {
         $rt_val = $this->current_stmt->close();
         if (!$rt_val) {
-            echo "Fail to close SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery;
+            echo "Fail to close SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
         }
         return $rt_val;
     }