Methods summary
public
|
#
__construct( array $dbCfg )
Constructor to create an instance of this class.
Constructor to create an instance of this class.
The given configuration will be aggregated.
Parameters
- $dbCfg
array
$dbCfg database configuration
|
public
|
|
public
cDbDriverHandler|null
|
#
getHandler( )
Returns the database driver handler instance.
Returns the database driver handler instance.
Returns
|
abstract public
boolean
|
#
check( )
Abstract method for checking database driver base functions. If this check
fails, the database connection will not be established.
Abstract method for checking database driver base functions. If this check
fails, the database connection will not be established.
Returns
boolean
|
abstract public
object|resource|integer|null
|
#
connect( )
Connects to the database.
Connects to the database.
Returns
object|resource|integer|null
value depends on used driver and is NULL in case of an error
|
abstract public
string
|
#
buildInsert( string $tableName, array $fields )
Builds a insert query. String values in passed fields parameter will be
escaped automatically.
Builds a insert query. String values in passed fields parameter will be
escaped automatically.
Parameters
- $tableName
string
$tableName The table name- $fields
array
$fields Associative array of fields to insert Returns
string
The INSERT SQL query
|
abstract public
string
|
#
buildUpdate( string $tableName, array $fields, array $whereClauses )
Builds a update query. String values in passed fields and whereClauses
parameter will be escaped automatically.
Builds a update query. String values in passed fields and whereClauses
parameter will be escaped automatically.
Parameters
- $tableName
string
$tableName The table name- $fields
array
$fields Assoziative array of fields to update- $whereClauses
array
$whereClauses Assoziative array of field in where clause. Multiple entries will
be concatenated with AND. Returns
string
The UPDATE query
|
abstract public
|
#
query( string $statement )
Executes the query.
Parameters
- $statement
string
$statement The query to execute
|
abstract public
integer
|
#
nextRecord( )
Moves the result to the next record, if exists and returns the status of the
movement
Moves the result to the next record, if exists and returns the status of the
movement
Returns
integer
Flag about move status 1 on success or 0
|
abstract public
object
|
#
getResultObject( string $className = NULL )
This method returns the current result set as object or NULL if no result set
is left. If optional param $className is set, the result object is an instance
of class $className.
This method returns the current result set as object or NULL if no result set
is left. If optional param $className is set, the result object is an instance
of class $className.
Parameters
- $className
string
$className [optional] Returns
object
|
abstract public
integer
|
#
affectedRows( )
Returns number of affected rows from last executed query (update, delete)
Returns number of affected rows from last executed query (update, delete)
Returns
integer
Number of affected rows
|
abstract public
integer
|
#
numRows( )
Returns the number of rows from last executed select query.
Returns the number of rows from last executed select query.
Returns
integer
The number of rows from last select query result
|
abstract public
integer
|
#
numFields( )
Returns the number of fields (columns) from current record set
Returns the number of fields (columns) from current record set
Returns
integer
Number of fields
|
abstract public
|
|
abstract public
string
|
#
escape( string $string )
Escape string for using in SQL-Statement.
Escape string for using in SQL-Statement.
Parameters
- $string
string
$string The string to escape Returns
string
Escaped string
|
abstract public
integer
|
#
seek( integer $iPos = 0 )
Moves the cursor (position inside current result sets).
Moves the cursor (position inside current result sets).
Parameters
- $iPos
integer
$iPos [optional] The positon to move to inside the current result set Returns
integer
|
abstract public
array
|
#
getMetaData( string $tableName, boolean $full = false )
Parses the table structure and generates metadata from it.
Parses the table structure and generates metadata from it.
Due to compatibility problems with table we changed the behavior of
metadata(). Depending on $full, metadata returns the following values:
$result[]: [0]["table"] table name [0]["name"] field name [0]["type"] field
type [0]["len"] field length [0]["flags"] field flags
$result[]: ["num_fields"] number of metadata records [0]["table"] table name
[0]["name"] field name [0]["type"] field type [0]["len"] field length
[0]["flags"] field flags ["meta"][field name] index of field named "field name"
This last one could be used if you have a field name, but no index. Test: if
(isset($result['meta']['myfield'])) { ...
Parameters
- $tableName
string
$tableName The table to get metadata or empty string to retrieve metadata of all
tables.- $full
boolean
$full [optional] Flag to load full metadata. Returns
array
Depends on used database and on parameter $full
|
abstract public
array
|
|
abstract public
array
|
#
getServerInfo( )
Fetches server information.
Fetches server information.
Returns
array
|
abstract public
integer
|
#
getErrorNumber( )
Returns error code of last occured error by using databases interface.
Returns error code of last occured error by using databases interface.
Returns
integer
|
abstract public
string
|
#
getErrorMessage( )
Returns error message of last occured error by using databases interface.
Returns error message of last occured error by using databases interface.
Returns
string
|
abstract public
|
#
disconnect( )
Closes the connection and frees the query id.
Closes the connection and frees the query id.
|