filter(array $request, array $columns, array $bindings, $dsphinXArrayParam = NULL) : string
Searching / Filtering
Construct the WHERE clause for server-side processing SQL query.
NOTE this does not match the built-in DataTables filtering which does it word by word on any field. It's possible to do here performance on large databases would be very poor
| array | $request | Data sent to server by DataTables |
| array | $columns | Column information array |
| array | $bindings | Array of values for PDO bindings, used in the sql_exec() function |
| $dsphinXArrayParam |
SQL where clause
simple(array $request, string $table, string $primaryKey, array $columns, $dsphinXArrayParam = NULL) : array
Perform the SQL queries needed for an server-side processing requested, utilising the helper functions of this class, limit(), order() and filter() among others. The returned array is ready to be encoded as JSON in response to an SSP request, or can be modified if needed before sending back to the client.
| array | $request | Data sent to server by DataTables |
| string | $table | SQL table to query |
| string | $primaryKey | Primary key of the table |
| array | $columns | Column information array |
| $dsphinXArrayParam |
Server-side processing response array
sql_exec(resource $db, array $bindings, string $sql = null) : array
Execute an SQL query on the database
| resource | $db | Database handler |
| array | $bindings | Array of PDO binding values from bind() to be used for safely escaping strings. Note that this can be given as the SQL query string if no bindings are required. |
| string | $sql | SQL query to execute. |
Result from the query (all rows)
bind( $a, \* $val, integer $type) : string
Create a PDO binding key which can be used for escaping variables safely when executing a query with sql_exec()
| $a | ||
| \* | $val | Value to bind |
| integer | $type | PDO field type |
Bound key to be used in the SQL where this parameter would be used.