summaryrefslogtreecommitdiff
path: root/includes/database.mysql.inc
diff options
context:
space:
mode:
Diffstat (limited to 'includes/database.mysql.inc')
-rw-r--r--includes/database.mysql.inc56
1 files changed, 56 insertions, 0 deletions
diff --git a/includes/database.mysql.inc b/includes/database.mysql.inc
new file mode 100644
index 000000000..1b14da5cd
--- /dev/null
+++ b/includes/database.mysql.inc
@@ -0,0 +1,56 @@
+<?php
+
+function db_connect($url) {
+ $url = parse_url($url);
+
+ mysql_pconnect($url["host"], $url["user"], $url["pass"]) or die(mysql_error());
+ mysql_select_db(substr($url["path"], 1)) or die ("unable to select database");
+
+ // NOTE: we are using a persistent connection!
+}
+
+function db_query($query, $debug = 0) {
+
+ $result = mysql_query($query);
+
+ if ($debug) {
+ print "<p>query: $query<br />error:". mysql_error() ."</p>";
+ }
+
+ if ($result) {
+ return $result;
+ }
+ else {
+ watchdog("error", "database: ". mysql_error() ."\nquery: ". htmlspecialchars($query));
+ }
+}
+
+function db_fetch_object($result) {
+ if ($result) {
+ return mysql_fetch_object($result);
+ }
+}
+
+function db_fetch_array($result) {
+ if ($result) {
+ return mysql_fetch_array($result, MYSQL_ASSOC);
+ }
+}
+
+function db_num_rows($result) {
+ if ($result) {
+ return mysql_num_rows($result);
+ }
+}
+
+function db_result($result, $row = 0) {
+ if ($result && mysql_num_rows($result) > $row) {
+ return mysql_result($result, $row);
+ }
+}
+
+function db_error() {
+ return mysql_errno();
+}
+
+?> \ No newline at end of file