<?php
require_once 'DB.php';

function get_db()
{
	$user = 'root';
	$pass = '';
	$host = 'localhost';
	$db_name = 'dbarticle';
	
	$dsn = "mysql://$user:$pass@$host/$db_name";
	
	$db = DB::connect($dsn);

	return $db;
}

function db_query_block( $sql, $args )
{
	$db = get_db();
	$block = array();
	$result = $db->query( $sql, $args );
	while ($row = $result->fetchRow( DB_FETCHMODE_ASSOC )) { $block[] = $row; }
	return $block;
}

function db_query_row( $sql, $args )
{
	$db = get_db();
	$block = array();
	$result = $db->query( $sql, $args );
	return $result->fetchRow( DB_FETCHMODE_ASSOC );
}

function db_query_column( $sql, $args )
{
	$db = get_db();
	$block = array();
	$result = $db->query( $sql, $args );
	while ($row = $result->fetchRow()) { $block[] = $row[0]; }
	return $block;
}

function db_query_single( $sql, $args )
{
	$db = get_db();
	$block = array();
	$result = $db->query( $sql, $args );
	$row = $result->fetchRow();
	return $row[0];
}

function db_command( $sql, $vars )
{
	$db = get_db();
	$db->execute( $sql, $vars );
	return True;
}

function db_insert( $sql, $args )
{
	db_command( $sql, $vars );
	return db_query_single( "SELECT LAST_INSERT_ID()", array() );
}

function db_delete( $sql, $args ) { db_command( $sql, $vars ); }
function db_update( $sql, $args ) { db_command( $sql, $vars ); }
?>