summaryrefslogtreecommitdiff
path: root/classes/db
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2013-03-15 19:54:08 +0400
committerAndrew Dolgov <[email protected]>2013-03-15 19:54:08 +0400
commita48d8533bf6a353972248720cf19ffb5ba55041f (patch)
treebfcfe3fbd0346250a1c635245393ecd1b7ad8176 /classes/db
parente600dbd44ac9d702bfad9d77f164cc0b358dc0b9 (diff)
Revert "db: use builtin classloader, lowercase class files"
This reverts commit 57b8469e674ef082c30b7d1de40d5d53d50b251b.
Diffstat (limited to 'classes/db')
-rw-r--r--classes/db/abstract.php56
-rw-r--r--classes/db/interface.php18
-rw-r--r--classes/db/mysql.php71
-rw-r--r--classes/db/pgsql.php80
4 files changed, 0 insertions, 225 deletions
diff --git a/classes/db/abstract.php b/classes/db/abstract.php
deleted file mode 100644
index d84701fd7..000000000
--- a/classes/db/abstract.php
+++ /dev/null
@@ -1,56 +0,0 @@
-<?php
-
-abstract class Db_Abstract implements Db_Interface
-{
- private $dbconn;
- protected static $instance;
-
- private function __construct() { }
-
- public static function instance()
- {
- if (is_null(static::$instance)) {
- static::$instance = new static();
- }
-
- return static::$instance;
- }
-
- public function connect($host, $user, $pass, $db) { }
-
- public function getLink()
- {
- return $this->dbconn;
- }
-
- public function init() { }
-
- public function escape_string($s, $strip_tags = true) { }
-
- public function query($query, $die_on_error = true) { }
-
- public function fetch_assoc($result) { }
-
- public function num_rows($result) { }
-
- public function fetch_result($result, $row, $param) { }
-
- public function unescape_string($str)
- {
- $tmp = str_replace("\\\"", "\"", $str);
- $tmp = str_replace("\\'", "'", $tmp);
- return $tmp;
- }
-
- public function close() { }
-
- public function affected_rows($result) { }
-
- public function last_error() { }
-
- public function quote($str)
- {
- return("'$str'");
- }
-
-} \ No newline at end of file
diff --git a/classes/db/interface.php b/classes/db/interface.php
deleted file mode 100644
index c5bfad56f..000000000
--- a/classes/db/interface.php
+++ /dev/null
@@ -1,18 +0,0 @@
-<?php
-
-interface Db_Interface
-{
- public function connect($host, $user, $pass, $db);
- public function getLink();
- public function init();
- public function escape_string($s, $strip_tags = true);
- public function query($query, $die_on_error = true);
- public function fetch_assoc($result);
- public function num_rows($result);
- public function fetch_result($result, $row, $param);
- public function unescape_string($str);
- public function close();
- public function affected_rows($result);
- public function last_error();
- public function quote($str);
-}
diff --git a/classes/db/mysql.php b/classes/db/mysql.php
deleted file mode 100644
index 170628304..000000000
--- a/classes/db/mysql.php
+++ /dev/null
@@ -1,71 +0,0 @@
-<?php
-
-class Db_Mysql extends Db_Abstract
-{
- public function connect($host, $user, $pass, $db)
- {
- $link = mysql_connect($host, $user, $pass);
- if ($link) {
- $result = mysql_select_db($db, $link);
- if (!$result) {
- die("Can't select DB: " . mysql_error($link));
- }
- $this->dbconn = $link;
- return $link;
- } else {
- die("Unable to connect to database (as $user to $host, database $db): " . mysql_error());
- }
- }
-
- public function init()
- {
- db_query($this->dbconn, "SET time_zone = '+0:0'");
-
- if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) {
- db_query($this->dbconn, "SET NAMES " . MYSQL_CHARSET);
- }
- }
-
- public function escape_string($s, $strip_tags = true)
- {
- if ($strip_tags) $s = strip_tags($s);
- return mysql_real_escape_string($s);
- }
-
- public function query($query, $die_on_error = true)
- {
- $result = mysql_query($query, $this->dbconn);
- if (!$result) {
- $query = htmlspecialchars($query);
- if ($die_on_error) {
- die("Query <i>$query</i> failed: " . ($this->dbconn ? mysql_error($this->dbconn) : "No connection"));
- }
- }
- return $result;
- }
-
- public function fetch_assoc($result) {
- return mysql_fetch_assoc($result);
- }
-
- public function num_rows($result) {
- return mysql_num_rows($result);
- }
-
- public function fetch_result($result, $row, $param) {
- // I hate incoherent naming of PHP functions
- return mysql_result($result, $row, $param);
- }
-
- public function close() {
- return mysql_close($this->dbconn);
- }
-
- public function affected_rows($result) {
- return mysql_affected_rows($this->dbconn);
- }
-
- public function last_error() {
- return mysql_error($this->dbconn);
- }
-}
diff --git a/classes/db/pgsql.php b/classes/db/pgsql.php
deleted file mode 100644
index 39ed181d7..000000000
--- a/classes/db/pgsql.php
+++ /dev/null
@@ -1,80 +0,0 @@
-<?php
-
-class Db_Pgsql extends Db_Abstract
-{
- public function connect($host, $user, $pass, $db)
- {
- $string = "dbname=$db user=$user";
-
- if ($pass) {
- $string .= " password=$pass";
- }
-
- if ($host) {
- $string .= " host=$host";
- }
-
- if (defined('DB_PORT')) {
- $string = "$string port=" . DB_PORT;
- }
-
- $link = pg_connect($string);
-
- if (!$link) {
- die("Unable to connect to database (as $user to $host, database $db):" . pg_last_error());
- }
-
- $this->dbconn = $link;
- return $link;
- }
-
- public function init()
- {
- pg_query($this->dbconn, "set client_encoding = 'UTF-8'");
- pg_set_client_encoding("UNICODE");
- pg_query($this->dbconn, "set datestyle = 'ISO, european'");
- pg_query($this->dbconn, "set TIME ZONE 0");
- }
-
- public function escape_string($s, $strip_tags = true)
- {
- if ($strip_tags) $s = strip_tags($s);
- return pg_escape_string($s);
- }
-
- public function query($query, $die_on_error = true)
- {
- $result = pg_query($this->dbconn, $query);
- if (!$result) {
- $query = htmlspecialchars($query); // just in case
- if ($die_on_error) {
- die("Query <i>$query</i> failed [$result]: " . ($this->dbconn ? pg_last_error($this->dbconn) : "No connection"));
- }
- }
- return $result;
- }
-
- public function fetch_assoc($result) {
- return pg_fetch_assoc($result);
- }
-
- public function num_rows($result) {
- return pg_num_rows($result);
- }
-
- public function fetch_result($result, $row, $param) {
- return pg_fetch_result($result, $row, $param);
- }
-
- public function close() {
- return pg_close($this->dbconn);
- }
-
- public function affected_rows($result) {
- return pg_affected_rows($result);
- }
-
- public function last_error() {
- return pg_last_error($this->dbconn);
- }
-}