*/
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;
return $this->connection;
}
+ /**
+ * [__destruct description]
+ */
/* public function __destruct()
{
$this->close();
/**
* [prepared_query_bind_param description]
+ * @param [type] $types [description]
* @param [type] $params [description]
* @return [type] [description]
*/
return $rt_val;
}
+ /**
+ * [get_pquery_result description]
+ * @return [type] [description]
+ */
public function get_pquery_result()
{
$rt_val = $this->current_result = $this->current_stmt->get_result();
return $rt_val;
}
+ /**
+ * [get_result_array description]
+ * @return [type] [description]
+ */
public function get_result_array()
{
- $rt_val = $this->current_result->fetch_array();
- if (!$rt_val) {
+ $row = $this->current_result->fetch_array();
+ if (is_null($row)) {
+ $rt_val = [];
+ } elseif (!isset($row)) {
echo "Fail to build SQL query result array : (" . $this->current_stmt->errno . ") " . $this->current_stmt->error . " - " . $this->current_pquery . "<br>";
+ $rt_val = false;
+ } else {
+ $rows[] = $row;
+ while ($row = $this->current_result->fetch_array()) {
+ $rows[] = $row;
+ }
+ $rt_val = $rows;
}
return $rt_val;
}
return $rt_val;
}
}
+
?>