Inherits PntDao.
Inherited by QueryHandler.
|
| | __construct ($connection=null) |
| |
| | getDbmsName () |
| |
| | supportsSelectRowCount () |
| |
| | _runQuery ($error="Query error") |
| |
| | getFieldNames () |
| |
| | getInsertId ($sequenceName=null) |
| |
| | dataSeek ($index) |
| |
| | getSingleValue ($query='', $error="Query error") |
| |
| | quote ($value) |
| |
| | getAssocRows ($max=null) |
| |
| | getAssocRow () |
| |
| | release () |
| |
| | connect () |
| |
| | beginTransaction () |
| |
| | commit () |
| |
| | rollBack () |
| |
| | __construct ($connection=null) |
| |
| | getDbmsName () |
| |
| | supportsSelectRowCount () |
| |
| | runQuery ($query='', $error="Query error") |
| |
| | _runQuery ($error="Query error") |
| |
| | getFieldNames () |
| |
| | getRowCount () |
| |
| | getColumnCount () |
| |
| | getError () |
| |
| | getErrNo () |
| |
| | dataSeek ($index) |
| |
| | getSingleValue ($query='', $error="Query error") |
| |
| | getInsertId () |
| |
| | prefixColumnNames ($colNames, $prefix) |
| |
| | select_from ($columnNames, $tableName, $distinct=false) |
| |
| | where_equals ($columnName, $value, $placeholder='?') |
| |
| | limit ($rowCount, $offset=0) |
| |
| | joinAllById ($tableMap, $baseTable) |
| |
| | in ($columnName, $values) |
| |
| | convertToSql ($value) |
| |
| | convertConditionArgumentToSql ($value) |
| |
| | quote ($string) |
| |
| | setQueryToInsertObject_table_fieldMap ($anObject, $tableName, $fieldMap) |
| |
| | setQueryToSaveObject_table_fieldMap ($anObject, $tableName, $fieldMap, $insert) |
| |
| | setQueryToDeleteFrom_where_equals ($tableName, $columnName, $value) |
| |
| | addSqlFromSpec ($spec, $groupBy=false) |
| |
| | getAssocRows ($max=null) |
| |
| | getAssocRow () |
| |
| | release () |
| |
| | getConnection () |
| |
| | setConnection ($value) |
| |
| | setDefaultConnection () |
| |
| | connect () |
| |
| | beginTransaction () |
| |
| | commit () |
| |
| | rollBack () |
| |
| | param ($value, $placeholder='?') |
| |
| | clearParams () |
| |
| | replacePlaceholders () |
| |
| | addFieldPropsTo_table ($obj, $tableName, $includeList=null) |
| |
| | addFieldPropTo_row ($obj, $row) |
| |
| | getPropertyType ($mySqlType) |
| |
| __construct |
( |
|
$connection = null | ) |
|
| _runQuery |
( |
|
$error = "Query error" | ) |
|
Connects to the DBMS and selects the database Stores the resulting resource on $this->connection PRECONDITION: $this->connection must be a valid DatabaseConnection instance
Gets next row as associative array, or false if none
| getAssocRows |
( |
|
$max = null | ) |
|
Gets rows starting at current rerord position
- Parameters
-
| number | $max | The maximum number of rows to get. If null all remaining rows are returned. Returns an array of associative row arrays (indexed[rowIndex][rowName]) |
| getInsertId |
( |
|
$sequenceName = null | ) |
|
Return the id of the new record after an insert, or the last value from a sequence object, depending on the underlying driver
- Parameters
-
| String | $sequenceName | name of sequence |
| static getParamType |
( |
|
$prop | ) |
|
|
static |
| getSingleValue |
( |
|
$query = '', |
|
|
|
$error = "Query error" |
|
) |
| |
Ececutes the query and returns the value of the first column of the first row or null if no row. !does no longer reset the record pointer
Return the $value quoted and with special characters escaped Not all PDO drivers implement this method (notably PDO_ODBC). For those drivers subclasses will have to be used overriding this method
| supportsSelectRowCount |
( |
| ) |
|
- Returns
- boolean wheather this does support rowcount with SELECT For some drivers/dsbs this may actually depend on the cursor type used. If this function returns true, dataSeek should be supported too
Holds parameter values that have been collected through calls to ::convertToSql and ::convertConditionArgumentToSql
PDOStatement Prepared statement
The documentation for this class was generated from the following file:
Public Member Functions inherited from PntDao
1.8.3.1
