Posted By

kendsnyder on 05/27/11

Tagged

Versions (?)

Last Edited at 05/27/11 03:13am

Statistics

Viewed 1162 times

Favorited by 0 user(s)

Related snippets

PHP Simplified DB Functions

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

// 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;
}