From 147f5632281b0da6f4232b5d8f4e6998ebf1e40b Mon Sep 17 00:00:00 2001 From: Craig Meyer Date: Thu, 11 Aug 2011 18:51:00 -0400 Subject: Extended Actions to include Select by tag (add local modifications, fix display for tags starting with a number) --- db.php | 22 +++++++++++++--------- 1 file changed, 13 insertions(+), 9 deletions(-) (limited to 'db.php') diff --git a/db.php b/db.php index 9b1ce5d84..81da431b9 100644 --- a/db.php +++ b/db.php @@ -3,14 +3,14 @@ require_once "config.php"; function db_connect($host, $user, $pass, $db) { - if (DB_TYPE == "pgsql") { - + if (DB_TYPE == "pgsql") { + $string = "dbname=$db user=$user"; - + if ($pass) { - $string .= " password=$pass"; + $string .= " password=$pass"; } - + if ($host) { $string .= " host=$host"; } @@ -30,10 +30,10 @@ function db_connect($host, $user, $pass, $db) { } else if (DB_TYPE == "mysql") { $link = mysql_connect($host, $user, $pass); if ($link) { - $result = mysql_select_db($db, $link); + $result = mysql_select_db($db, $link); if (!$result) { die("Can't select DB: " . mysql_error($link)); - } + } return $link; } else { die("Connection failed: " . mysql_error($link)); @@ -44,7 +44,7 @@ function db_connect($host, $user, $pass, $db) { function db_escape_string($s, $strip_tags = true) { if ($strip_tags) $s = strip_tags($s); - if (DB_TYPE == "pgsql") { + if (DB_TYPE == "pgsql") { return pg_escape_string($s); } else { return mysql_real_escape_string($s); @@ -57,7 +57,7 @@ function db_query($link, $query, $die_on_error = true) { if (!$result) { $query = htmlspecialchars($query); // just in case if ($die_on_error) { - die("Query $query failed [$result]: " . pg_last_error($link)); + die("Query $query failed [$result]: " . pg_last_error($link)); } } return $result; @@ -131,4 +131,8 @@ function db_last_error($link) { } } +function db_quote($str){ + return("'$str'"); +} + ?> -- cgit v1.2.3-54-g00ecf