diff options
author | Andrew Dolgov <[email protected]> | 2013-04-17 13:08:36 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-04-17 13:08:36 +0400 |
commit | 9594791782bb9adbf29018c444ea427fbaeb5ee4 (patch) | |
tree | 03bf4eddfb7b3333e6bfe1eaf3e3ea08aa2e818a /classes/db/mysql.php | |
parent | 857efe49e653787f5408fc014ae71efec68494d5 (diff) |
experimental singleton-based Db connection
Diffstat (limited to 'classes/db/mysql.php')
-rw-r--r-- | classes/db/mysql.php | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/classes/db/mysql.php b/classes/db/mysql.php new file mode 100644 index 000000000..512ea3894 --- /dev/null +++ b/classes/db/mysql.php @@ -0,0 +1,59 @@ +<?php +class Db_Mysql implements IDb { + private $link; + + function connect($host, $user, $pass, $db, $port) { + $this->link = mysql_connect($host, $user, $pass); + if ($this->link) { + $result = mysql_select_db($db, $this->link); + if (!$result) { + die("Can't select DB: " . mysql_error($this->link)); + } + return $this->link; + } else { + die("Unable to connect to database (as $user to $host, database $db): " . mysql_error()); + } + } + + function escape_string($s, $strip_tags = true) { + return mysql_real_escape_string($s, $this->link); + } + + function query($query, $die_on_error = true) { + $result = mysql_query($query, $this->link); + if (!$result) { + $query = htmlspecialchars($query); + if ($die_on_error) { + die("Query <i>$query</i> failed: " . ($this->link ? mysql_error($link) : "No connection")); + } + } + return $result; + } + + function fetch_assoc($result) { + return mysql_fetch_assoc($result); + } + + + function num_rows($result) { + return mysql_num_rows($result); + } + + function fetch_result($result, $row, $param) { + return mysql_result($result, $row, $param); + } + + function close() { + return mysql_close($this->link); + } + + function affected_rows($result) { + return mysql_affected_rows($this->link); + } + + function last_error() { + return mysql_affected_rows($this->link); + } + +} +?> |