summaryrefslogtreecommitdiffstats
path: root/examples/class/mysql.class.php
diff options
context:
space:
mode:
Diffstat (limited to 'examples/class/mysql.class.php')
-rw-r--r--examples/class/mysql.class.php77
1 files changed, 0 insertions, 77 deletions
diff --git a/examples/class/mysql.class.php b/examples/class/mysql.class.php
deleted file mode 100644
index f8f456a..0000000
--- a/examples/class/mysql.class.php
+++ /dev/null
@@ -1,77 +0,0 @@
-<?php
-
-/*
- * SCROTT Copyright (C) 2016 Malf Furious
- *
- * Scrott is free software: you can redistribute it and/or modify
- * it under the terms of the GNU General Public License as published
- * by the Free Software Foundation, either version 3 of the License,
- * or (at your option) any later version.
- *
- * Scrott is distributed in the hope that it will be useful, but
- * WITHOUT ANY WARRANTY; even the implied warranty of MERCHANTABILITY
- * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public
- * License for more details.
- */
-
-require_once "class/database.iface.php";
-
-/*
- * MySQL support for Scrott
- */
-class Mysql implements Database
-{
- /*
- * Constructor
- */
- function __construct($host, $username, $password, $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 Scrott configuration.");
- }
-
- /*
- * Destructor
- */
- function __destruct()
- {
- $this->close();
- }
-
- /*
- * Close connection to DB
- */
- function close()
- {
- $this->db->close();
- }
-
- /*
- * Make a query of the database. Return data as an array of arrays
- */
- function query($query)
- {
- $arr = array();
- $res = $this->db->query($query);
-
- if ($res === true || $res === false)
- return $arr;
-
- while ($r = $res->fetch_assoc())
- $arr[] = $r;
-
- return $arr;
- }
-
- /*
- * Escape a string for use in a query
- */
- function esc($string)
- {
- return $this->db->real_escape_string($string);
- }
-}
-
-?>