lib/db.php

   1 <?php
   2
   3 /**
   4  * [CustomDB description]
   5  */
   6 class CustomDB
   7 {
   8     private $connection;
   9     public $connected;
  10     private $current_pquery;
  11     private $current_stmt;
  12     private $current_result;
  13
  14     /**
  15      * [__construct description]
  16      * @param [type] $host     [description]
  17      * @param [type] $username [description]
  18      * @param [type] $password [description]
  19      * @param [type] $dbname   [description]
  20      */
  21     public function __construct($host, $username, $password, $dbname)
  22     {
  23         $this->connection = new mysqli($host, $username, $password, $dbname);
  24
  25         if (!$this->connection->connect_errno) {
  26             $this->connected = true;
  27         } else {
  28             die('Fail to connect to the RDBMS.');
  29         }
  30
  31         return $this->connection;
  32     }
  33
  34     /* public function __destruct()
  35     {
  36         $this->close();
  37     } */
  38
  39     /**
  40      * [close description]
  41      * @return [type] [description]
  42      */
  43     public function close()
  44     {
  45         if ($this->connected && $this->connection->close()) {
  46             $this->connected = false;
  47         } else {
  48             die('Fail to close the connection to the RDBMS.');
  49         }
  50     }
  51
  52     /**
  53      * [query description]
  54      * @param  [type] $sql_query [description]
  55      * @return [type]            [description]
  56      */
  57     public function query($sql_query)
  58     {
  59         if ($this->connected && !($this->current_result = $this->connection->query($sql_query))) {
  60             echo "Fail to execute the SQL query : " . $sql_query . "<br>";
  61         }
  62         return $this->current_result;
  63     }
  64
  65     /**
  66      * [prepare_query description]
  67      * @param  [type] $prepared_query [description]
  68      * @return [type]                 [description]
  69      */
  70     public function prepare_query($prepared_query)
  71     {
  72         $this->current_pquery = $prepared_query;
  73         if ($this->connected && !($this->current_stmt = $this->connection->prepare($this->current_pquery))) {
  74             // Empty the currently stored prepared query in the failure case
  75             $this->current_pquery = "";
  76             echo "Fail to prepare SQL query : (" . $this->connection->errno . ") " . $this->connection->error . " - " . $this->current_pquery . "<br>";
  77         }
  78         return $this->current_stmt;
  79     }
  80
  81     /**
  82      * [prepared_query_bind_param description]
  83      * @param  [type] $types  [description]
  84      * @param  [type] $params [description]
  85      * @return [type]         [description]
  86      */
  87     public function prepared_query_bind_param($types, $params)
  88     {
  89         $rt_val = $this->current_stmt->bind_param($types, ...$params);
  90         if (!$rt_val) {
  91             echo "Fail to link parameters to SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
  92         }
  93         return $rt_val;
  94     }
  95
  96     /**
  97      * [run_prepared_query description]
  98      * @return [type] [description]
  99      */
 100     public function run_prepared_query()
 101     {
 102         $rt_val = $this->current_stmt->execute();
 103         if (!$rt_val) {
 104             echo "Fail to execute SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
 105         }
 106         return $rt_val;
 107     }
 108
 109     public function get_pquery_result()
 110     {
 111         $rt_val = $this->current_result = $this->current_stmt->get_result();
 112         if (!$rt_val) {
 113             echo "Fail to fill SQL query result : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
 114         }
 115         return $rt_val;
 116     }
 117
 118     public function get_result_array()
 119     {
 120         $row = $this->current_result->fetch_array();
 121         if (is_null($row)) {
 122             $rt_val = [];
 123         } elseif (!isset($row)) {
 124             echo "Fail to build SQL query result array : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
 125             $rt_val = false;
 126         } else {
 127             $rows[] = $row;
 128             while ($row = $this->current_result->fetch_array()) {
 129                 $rows[] = $row;
 130             }
 131             $rt_val = $rows;
 132         }
 133         return $rt_val;
 134     }
 135
 136     /**
 137      * [close_prepared_query description]
 138      * @return [type] [description]
 139      */
 140     public function close_prepared_query()
 141     {
 142         $rt_val = $this->current_stmt->close();
 143         if (!$rt_val) {
 144             echo "Fail to close SQL query : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
 145         }
 146         return $rt_val;
 147     }
 148 }
 149
 150 ?>