database database(
$db_type
)
|
|
Parameters:
void build_sql_create_db(
$db_name
)
|
|
Parameters:
void connect(
$p_dsn, [
$p_hostname = null], [
$p_username = null], [
$p_password = null], [
$p_database_name = null]
)
|
|
Parameters:
|
|
$p_dsn: |
|
|
|
$p_hostname: |
|
|
|
$p_username: |
|
|
|
$p_password: |
|
|
|
$p_database_name: |
|
void count_unique_queries(
)
|
|
void db_field_exists(
$p_field_name,
$p_table_name
)
|
|
Parameters:
|
|
$p_field_name: |
|
|
|
$p_table_name: |
|
void db_result(
$p_result, [
$p_index1 = 0], [
$p_index2 = 0]
)
|
|
Parameters:
|
|
$p_result: |
|
|
|
$p_index1: |
|
|
|
$p_index2: |
|
void db_table_exists(
$p_table_name
)
|
|
Parameters:
void db_timestamp(
[
$p_date = null]
)
|
|
Parameters:
void db_unixtimestamp(
[
$p_date = null]
)
|
|
Parameters:
void error(
[
$p_query = null]
)
|
|
Parameters:
void exec_query(
$p_query, [
$p_limit = -1], [
$p_offset = -1]
)
|
|
Parameters:
|
|
$p_query: |
|
|
|
$p_limit: |
|
|
|
$p_offset: |
|
array fetchArrayRowsIntoMap(
string
$query, string
$column, [
$limit = -1]
)
|
|
Fetches all rows into a map whose keys are the values of columns
Parameters:
|
string |
$query: |
the query to be executed |
|
string |
$column: |
the name of the column |
|
|
$limit: |
|
API Tags:
| Return: | an assoc array whose keys are the values from the columns of the rows |
array fetchColumnsIntoArray(
string
$query, string
$column, [
$limit = -1]
)
|
|
Fetches all values for a given column of all returned rows
Parameters:
|
string |
$query: |
the query to be executed |
|
string |
$column: |
the name of the column |
|
|
$limit: |
|
API Tags:
| Return: | an enumerated array, which contains all the values |
assoc fetchColumnsIntoMap(
string
$query, string
$column1, string
$column2, [boolean
$cumulative = 0], [
$limit = -1]
)
|
|
Fetches the values of two columns from all rows into a map
Parameters:
|
string |
$query: |
the query to be executed |
|
string |
$column1: |
the name of the column (keys for the map) |
|
string |
$column2: |
the name of the second column (values of the map) |
|
boolean |
$cumulative: |
useful in situations with results set like col1 col2 X A X B Y B cumulative=0 -> return items= array('X' => 'B', 'Y' => 'B') cumulative=1 -> return items= array('X' => array('A','B'), 'Y' => array('B') ) |
|
|
$limit: |
|
API Tags:
| Return: | array whose keys are the values of column1 and the values are: cumulative=0 => the values of column2 cumulative=1 => array with the values of column2 |
array fetchFirstRow(
string
$query
)
|
|
Fetches the first row (in a assoc-array)
Parameters:
|
string |
$query: |
the query to be executed |
API Tags:
mixed fetchFirstRowSingleColumn(
string
$query, string
$column
)
|
|
Fetches the first column first row
Parameters:
|
string |
$query: |
the query to be executed |
|
string |
$column: |
the name of the column which shall be returned |
API Tags:
| Return: | the value of the column |
void fetchMapRowsIntoMap(
$query,
$column_main_key,
$column_sec_key, [
$limit = -1]
)
|
|
Parameters:
|
|
$query: |
|
|
|
$column_main_key: |
|
|
|
$column_sec_key: |
|
|
|
$limit: |
|
string fetchOneValue(
string
$query
)
|
|
Get one value (no array) for example: SELECT COUNT(*) FROM table
Parameters:
|
string |
$query: |
the query to be executed |
API Tags:
| Return: | of one value || null |
| Access: | public |
array fetchRowsIntoMap(
string
$query, string
$column, [booleam
$bCumulative = 0], [
$limit = -1]
)
|
|
Fetches all rows into a map whose keys are the values of columns
Parameters:
|
string |
$query: |
the query to be executed |
|
string |
$column: |
the name of the column |
|
booleam |
$bCumulative: |
default 0 |
|
|
$limit: |
|
API Tags:
| Return: | an assoc array whose keys are the values from the columns of the rows |
void fetch_array(
&$p_result
)
|
|
Parameters:
void getLogEnabled(
$value
)
|
|
Parameters:
void getLogQueries(
$value
)
|
|
Parameters:
void get_recordset(
$sql, [
$fetch_mode = null], [
$limit = -1]
)
|
|
Parameters:
|
|
$sql: |
|
|
|
$fetch_mode: |
|
|
|
$limit: |
|
assoc get_version_info(
)
|
|
database server information
wrapper for adodb method ServerInfo
API Tags:
| Return: | array members 'version' and 'description' |
void insert_id(
[
$p_table = null]
)
|
|
Parameters:
void key_exists_on_field(
$p_table,
$p_field,
$p_key
)
|
|
Parameters:
|
|
$p_table: |
|
|
|
$p_field: |
|
|
|
$p_key: |
|
void num_rows(
$p_result
)
|
|
Parameters:
void prepare_bool(
$p_bool
)
|
|
Parameters:
void prepare_int(
$p_int
)
|
|
Parameters:
void prepare_string(
$p_string
)
|
|
Parameters:
void setLogEnabled(
$value
)
|
|
Parameters:
void setLogQueries(
$value
)
|
|
Parameters: