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: