diff options
Diffstat (limited to 'examples')
-rw-r--r-- | examples/class/database.iface.php | 27 | ||||
-rw-r--r-- | examples/class/mysql.class.php | 77 | ||||
-rw-r--r-- | examples/mysql.class.php | 74 |
3 files changed, 0 insertions, 178 deletions
diff --git a/examples/class/database.iface.php b/examples/class/database.iface.php deleted file mode 100644 index b1427a4..0000000 --- a/examples/class/database.iface.php +++ /dev/null @@ -1,27 +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. - */ - -/* - * Generic interface for the various database drivers Scrott may implement support for - */ -interface Database -{ - function close(); - function query($query); - function esc($string); -} - -?> 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); - } -} - -?> diff --git a/examples/mysql.class.php b/examples/mysql.class.php deleted file mode 100644 index 90a4016..0000000 --- a/examples/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); - } -} - -?> |