Class

DBQuerier

Package: io Author: loic rouchon <loic.rouchon@phpboost.com> Desc: implements some simple queries Located at io/db/DBQuerier.class.php
DBQuerier implements SQLQuerier
Methods summary
public
# __construct( SQLQuerier $querier )
public SelectQueryResult
# select( string $query, string[string] $parameters = array(), mixed $fetch_mode = SelectQueryResult::FETCH_ASSOC )
public InjectQueryResult
# inject( string $query, string[string] $parameters = array() )
public
public
public
public
# truncate( string $table_name )
public InjectQueryResult
# insert( string $table_name, array $columns )
public InjectQueryResult
# update( string $table_name, array $columns, string $condition, array $parameters = array() )
public
# delete( string $table_name, string $condition, array $parameters = array() )
public mixed[string]
# select_single_row( string $table_name, array $columns, string $condition, array $parameters = array() )
public mixed
# select_single_row_query( string $query, string[string] $parameters = array() )
public boolean
# row_exists( string $table_name, string $condition, array $parameters = array() )
public mixed
# get_column_value( string $table_name, string $column, string $condition, array $parameters = array() )
public mixed[string]
# select_rows( string $table_name, array $columns, string $condition = 'WHERE 1', string[string] $parameters = array() )
public integer
# count( string $table_name, string $condition = 'WHERE 1', string $parameters = array(), string[string] $count_column = '*' )
public
Constants inherited from SQLQuerier
ORDER_BY_ASC, ORDER_BY_DESC