$table
$table :
Class to manage database-based sessions.
The configuration (table, fields, and so on) is in the base configuration (see mymvc.php)
callFinder(string $name, array $fields, string $order = NULL, integer $limit = NULL, integer $offset = NULL) : array
Calls a defined finder (see registerFinder)
| string | $name | The name of the finder |
| array | $fields | An associative array with the fields to use for the search (field => value) |
| string | $order | If not NULL, field(s) to sort data |
| integer | $limit | If not NULL, maximum of the searched data (useful for paging) |
| integer | $offset | If not NULL, offset of the searched data (useful for paging) |
On invalid field
On Problems
The result as array of database class or NULL if no record was found
callIterator(string $name, array $fields, string $order = NULL, integer $limit = NULL, integer $offset = NULL) : resource
Iterate throws a defined finder (see registerFinder)
| string | $name | The name of the finder |
| array | $fields | An associative array with the fields to use for the search (field => value) |
| string | $order | If not NULL, field(s) to sort data |
| integer | $limit | If not NULL, maximum of the searched data (useful for paging) |
| integer | $offset | If not NULL, offset of the searched data (useful for paging) |
On invalid field
On Problems
The result as database resource or NULL if no record was found
callCounter(string $name, array $fields) : integer
Calls a defined counter (see registerCounter)
| string | $name | The name of the counter |
| array | $fields | An associative array with the fields to use for the search (field => value) |
On invalid field
On Problems
The count of the searched records
findAll(string $order = NULL, integer $limit = NULL, integer $offset = NULL) : array
Returns all records
| string | $order | If not NULL, field(s) to sort data |
| integer | $limit | If not NULL, maximum of the searched data (useful for paging) |
| integer | $offset | If not NULL, offset of the searched data (useful for paging) |
On invalid field
On Problems
The result as array of database class or NULL if no record was found
iterateAll(string $order = NULL, integer $limit = NULL, integer $offset = NULL) : resource
Iterate all records
| string | $order | If not NULL, field(s) to sort data |
| integer | $limit | If not NULL, maximum of the searched data (useful for paging) |
| integer | $offset | If not NULL, offset of the searched data (useful for paging) |
On invalid field
On Problems
The result as database resource or NULL if no record was found
sqlExportByParameter(array $param, array $useLike = array(), string $order = NULL, integer $limit = NULL, integer $offset = NULL, boolean $exportToBrowser = true, integer $separateAfter = 50) : string
Export data as SQL queries, using parameters Exportiert Datensätze als SQL anhand der eingegebenen Parametern
| array | $param | The parameters, as associative array field => value |
| array | $useLike | Associative array with the fields that should be search with a LIKE (default: empty) |
| string | $order | If not NULL, field(s) to sort data |
| integer | $limit | If not NULL, maximum of the searched data (useful for paging) |
| integer | $offset | If not NULL, offset of the searched data (useful for paging) |
| boolean | $exportToBrowser | If true (default) data will be exported to the browser If false, data will be exported in the return string |
| integer | $separateAfter | After $separateAfter lines (default 50) a new SQL header (INSERT INTO...) will be added |
On invalid field
On generic problem
The export as SQL queries or NULL if no data is available
registerFinder(string $name, array $fieldsToSearch, array $fixedFields = array())
Register a new finder method.
This can be called with the method callFinder or iterateFinder.
| string | $name | The name of the finder |
| array | $fieldsToSearch | An associative array with the fields to use for the search Format of the array: field => "LIKE" or field => "EQUAL" |
| array | $fixedFields | An associative array with the "fixed" fields for the search (default: empty) Format of the array: field => value |
On Problems
registerCounter(string $name, array $fieldsToSearch, array $fixedFields = array())
Register a new counter method.
This can be called with the method callCounter.
| string | $name | The name of the counter |
| array | $fieldsToSearch | An associative array with the fields to use for the search Format of the array: field => "LIKE" or field => "EQUAL" |
| array | $fixedFields | An associative array with the "fixed" fields for the search (default: empty) Format of the array: field => value |
On Problems
createWhere(array $param, array $useLike = array())
Creates the WHERE-statement for the SQL query, using parameters
| array | $param | The parameters, as associative array field => value |
| array | $useLike | Associative array with the fields that should be search with a LIKE (default: empty) |
findByParameter(array $param, array $useLike = array(), string $order = NULL, integer $limit = NULL, integer $offset = NULL) : resource
Get a record from the database, using parameters
| array | $param | The parameters, as associative array field => value |
| array | $useLike | Associative array with the fields that should be search with a LIKE (default: empty) |
| string | $order | If not NULL, field(s) to sort data |
| integer | $limit | If not NULL, maximum of the searched data (useful for paging) |
| integer | $offset | If not NULL, offset of the searched data (useful for paging) |
On invalid field
On generic problem
The result as database resource or NULL if no data was found
getCountByParameter(array $param, array $useLike = array()) : integer
Get the count of the records, using parameters
| array | $param | The parameters, as associative array field => value |
| array | $useLike | Associative array with the fields that should be search with a LIKE (default: empty) |
On invalid field
On generic problem
The count of the record
quoteSqlStringForLike(string $value, string $prefix = '%', string $suffix = '%') : string
Quotes a string to use in a SQL-Query (with LIKE)
| string | $value | The string with the Query |
| string | $prefix | (normally %) added BEFORE the string |
| string | $suffix | (normally %) added AFTER the string |
A secure SQL-String (quoted)