Class DBQuerier

select(string $query, \string[string] $parameters = array(),  $fetch_mode = \SelectQueryResult::FETCH_ASSOC) : \SelectQueryResult

executes the <code>$query</code> 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

the query result set

inject(string $query, \string[string] $parameters = array()) : \InjectQueryResult

executes the <code>$query</code> 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

the query result

truncate(string $table_name) 

Removes all table rows

insert(string $table_name, \string[string] $columns) : \InjectQueryResult

insert the values into the <code>$table_name</code> table

the query result set

update(string $table_name, \string[string] $columns, string $condition, \string[string] $parameters = array()) : \InjectQueryResult

update the values of rows matching the <code>$condition</code> into the <code>$table_name</code> table

the query result set

delete(string $table_name, string $condition, \string[string] $parameters = array()) 

delete all the row from the <code>$table_name</code> table matching the <code>$condition</code> condition

select_single_row(string $table_name, array<mixed,string> $columns, string $condition, \string[string] $parameters = array()) : \mixed[string]

retrieve a single row from the <code>$table_name</code> table matching the <code>$condition</code> condition

the row returned

select_single_row_query(string $query, \string[string] $parameters = array()) : mixed

retrieve a single row for executes the <code>$query</code> sql request and returns row

the value of the returned row

row_exists(string $table_name, string $condition, \string[string] $parameters = array()) : boolean

Returns true if a or multiple rows match the given condition.

true if a or multiple rows match the given condition.

get_column_value(string $table_name, string $column, string $condition, \string[string] $parameters = array()) : mixed

retrieve a single value of the <code>$column</code> column of a single row from the <code>$table_name</code> table matching the <code>$condition</code> condition.

the value of the returned row

select_rows(string $table_name, array<mixed,string> $columns, string $condition = 'WHERE 1', \string[string] $parameters = array()) : \mixed[string]

retrieve rows from the <code>$table_name</code> table matching the <code>$condition</code> condition

the row returned

count(string $table_name, string $condition = 'WHERE 1', \string[string] $parameters = array(), string $count_column = '*') : integer

count the number of rows from the <code>$table_name</code> table matching the <code>$condition</code> condition

the number of rows returned