Interface

SQLQuerier

Package: IO\DB Copyright: © 2005-2019 PHPBoost License: GNU/GPL-3.0 Author: Loic ROUCHON horn@phpboost.com Version: PHPBoost 5.2 - last update: 2014 12 22 Since: PHPBoost 3.0 - 2009 10 01 Located at: io/db/SQLQuerier.class.php
Direct known implementers
AbstractSQLQuerier, DBQuerier
Indirect known implementers
MySQLQuerier, PDOQuerier
Methods summary
public SelectQueryResult
# select( string $query, string[string] $parameters = array(), $fetch_mode = SelectQueryResult::FETCH_ASSOC )

executes the

$query

sql request and returns the query result.

Query will first be converted into the specific sgbd dialect.

Next query functions will be converted into the specific sgbd dialect.

Then query vars ":sample_query_var" will be replaced by the value of the

$parameters['sample_query_var']
variable if existing. If not (there's a lot of chance that you have forgotten to register this query var in the
$parameters
map), the query var won't be replaced

public InjectQueryResult
# inject( string $query, string[string] $parameters = array() )

executes the

$query

sql request.

Query will first be converted into the specific sgbd dialect.

Next query functions will be converted into the specific sgbd dialect.

Then query vars ":sample_query_var" will be replaced by the value of the

$parameters['sample_query_var']
variable if existing. If not (there's a lot of chance that you have forgotten to register this query var in the
$parameters
map), the query var won't be replaced

public
public
public
Constants summary
string ORDER_BY_ASC
# 'ASC'
string ORDER_BY_DESC
# 'DESC'