summaryrefslogtreecommitdiffstats
path: root/app/class/mysql.class.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/class/mysql.class.php')
-rw-r--r--app/class/mysql.class.php74
1 files changed, 0 insertions, 74 deletions
diff --git a/app/class/mysql.class.php b/app/class/mysql.class.php
deleted file mode 100644
index 90a4016..0000000
--- a/app/class/mysql.class.php
+++ /dev/null
@@ -1,74 +0,0 @@
-<?php
-
-/*
- * SCROTT IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
- * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
- * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
- * IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
- * OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
- * ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
- * OTHER DEALINGS IN THE SOFTWARE.
- *
- * For more information, please refer to UNLICENSE
- */
-
-require_once "class/database.class.php";
-
-/*
- * This class implements support for MySQL and MariaDB via PHP's mysqli
- * driver.
- */
-class Mysql extends Database
-{
- /*
- * Constructor
- */
- public function __construct(string $host, string $username, string $password, string $dbName)
- {
- $this->db = new mysqli($host, $username, $password, $dbName);
-
- if ($this->db->connect_error)
- throw new Exception("Can not connect to MySQL database. Please check your configuration.");
- }
-
- /*
- * Destructor
- */
- public function __destruct()
- {
- $this->close();
- }
-
- /*
- * Close connection to DB
- */
- public function close()
- {
- $this->db->close();
- }
-
- /*
- * Make a query of the database. Return data as an array of arrays.
- */
- public function query(string $query) : array
- {
- $arr = array();
- $res = $this->db->query($query);
-
- if ($res === true || $res === false)
- return $arr;
-
- while (($arr[] = $res->fetch_assoc()));
- return $arr;
- }
-
- /*
- * Escape a string for use in a query
- */
- public function esc(string $str) : string
- {
- return $this->db->real_escape_string($str);
- }
-}
-
-?>