Some sample mysql connection code

esse quam videri
Jump to: navigation, search
function db_connect() {
	global $MYSQL_ERRNO, $MYSQL_ERROR;

	$link_id = mysql_connect(DB_HOST, DB_USERNAME, DB_USER_PASSWORD);
	mysql_select_db(DB_NAME);
	
	if(mysql_error()) echo mysql_error();
	
	return $link_id;
}

function sql_error() {
	global $MYSQL_ERRNO, $MYSQL_ERROR;

	if(empty($MYSQL_ERROR)) {
		$MYSQL_ERRNO = mysql_errno();
		$MYSQL_ERROR = mysql_error();
	}
	return "$MYSQL_ERRNO: $MYSQL_ERROR";
}