Method |
Description |
|
__construct ( ) |
|
|
all ( $fields = self::ALL_COLUMNS_SELECTION, $condition = '', $start, $limit = null, $tableName = null ) |
|
|
assoc ( $fields = self::ALL_COLUMNS_SELECTION, $condition = '', $tableName = null, $start, $limit = null ) |
|
|
bind ( &$sql, $values ) |
|
|
cascadeDelete ( $tbl, $where = '' ) |
|
|
convertIds ( $ids, $columnName = 'id', $equal = true ) |
|
|
delete ( $condition, $tableName = null, $values = [] ) |
|
|
describe ( $tableName = null, $addPrefix = true ) |
|
|
exists ( $where, $values = [], $tableName = null ) |
|
|
fetchRow ( $result ) : array | null |
Fetches one row of data from the result set and returns it as an enumerated array |
|
foundRows ( ) |
|
|
getAffected ( ) |
|
|
getAll ( $sql, $start, $limit ) |
|
|
getAssoc ( $sql, $singleRow = false ) |
|
|
getCount ( ) |
|
|
getEnumValues ( $table, $field ) |
|
|
getError ( ) : string |
Returns the error text from the last MySQL function |
|
getErrorNumber ( ) |
|
|
getFieldNames ( $result ) : array | boolean |
Returns an array of objects which contains field definition information or FALSE if no field information is available |
|
getInfo ( $type ) : string |
Returns a string that represents various information on a connected database |
|
getInsertId ( ) |
|
|
getKeyValue ( $sql ) |
|
|
getLastQuery ( ) |
|
|
getMaxOrder ( $table = null, $condition = null ) |
|
|
getNextId ( $table = null ) |
Returns the ID using auto increment value for a table |
|
getNumFields ( ) : integer |
Retrieves the number of fields from a query |
|
getNumFields ( $result ) : integer |
Retrieves the number of fields from a query |
|
getNumRows ( $resource ) |
|
|
getOne ( $sql ) |
|
|
getPrefix ( ) |
|
|
getQueriesList ( ) |
|
|
getRow ( $sql ) |
|
|
init ( ) |
|
|
insert ( array $values, $rawValues = null, $tableName = null ) |
|
|
keyvalue ( $fields = self::ALL_COLUMNS_SELECTION, $condition = null, $tableName = null, $start, $limit = null ) |
|
|
mysqli_result ( $result, $row, $field ) |
|
|
one ( $field, $condition = '', $tableName = null, $start ) |
|
|
one_bind ( $field, $condition, array $values, $tableName = null, $start ) |
|
|
onefield ( $field = self::ID_COLUMN_SELECTION, $condition = null, $start, $limit = null, $tableName = null ) |
|
|
orderByRand ( $max, $id_name = '`id`', $pieces = 12, $delimiter = 100 ) |
|
|
printf ( $pattern, array $replacements ) |
|
|
query ( $sql ) |
|
|
replace ( array $values, $rawValues = null, $tableName = null ) |
|
|
resetTable ( ) |
|
|
row ( $fields = self::ALL_COLUMNS_SELECTION, $condition = '', $tableName = null, $start ) |
|
|
row_bind ( $fields, $condition, array $values, $tableName = null, $start ) |
|
|
setTable ( $tableName, $addPrefix = true ) |
|
|
setTimezoneOffset ( $offset ) |
|
|
sql ( string $string = '' ) : string |
Escapes string using valid connection |
|
truncate ( $table = null ) |
|
|
update ( $values, $condition = null, $rawValues = null, $tableName = null ) |
|
|