Revision: 46879
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at May 27, 2011 03:13 by kendsnyder
Initial Code
// simple DB access functions
function dbGetConn() {
static $conn;
if (!$conn) {
$conn = mysql_connect(DB_HOST, DB_USER, DB_PASS)
or die('Error connecting: ' . mysql_error());
}
return $conn;
}
function dbSelect($sql) {
$rs = mysql_query($sql, dbGetConn());
if (!$rs) {
die('Invalid query: ' . mysql_error());
}
$results = array();
while (($row = mysql_fetch_object($rs))) {
$results[] = $row;
}
return $results;
}
// return a hash of data like array(100,200,300)
// or when two columns are selected, like array('a'=>100,'b'=>200,'c'=>300)
function dbSelectHash($sql) {
$rs = mysql_query($sql, dbGetConn());
if (!$rs) {
die('Invalid query: ' . mysql_error());
}
// get the first row so we can check if there are one or two columns selected
$row = mysql_fetch_array($rs, MYSQL_NUM);
if (!$row) {
return array();
}
$results = array();
if (count($row) == 1) {
// one column selected; just use numeric keys
$results[] = $row[0];
while (($row = mysql_fetch_array($rs, MYSQL_NUM))) {
$results[] = $row[0];
}
}
else {
// two or more columns selected; use the first column value as the key and the second column value as the value
$results[$row[0]] = $row[1];
while (($row = mysql_fetch_array($rs, MYSQL_NUM))) {
$results[$row[0]] = $row[1];
}
}
return $results;
}
Initial URL
Initial Description
Initial Title
PHP Simplified DB Functions
Initial Tags
mysql, database
Initial Language
PHP