You can use the getJobDB and getDBConnection methods to get a JobDB object that allows you to create database queries.
The object provides the following methods:
Method |
Paremeter |
Return |
Description |
|---|---|---|---|
query |
$statement |
Result object |
Use this method to read data by passing an SQL select statement. |
exec |
$statement |
Integer |
Use this method to change data by passing an insert / update or delete statement. |
quote |
$value |
String |
Converts the passed value to a DBMS-specific format suitable for query statements. |
fetchAll |
$result |
Array |
This method returns all rows of the query result. |
fetchRow |
$result |
Array | false |
This method returns the next record as an associative array. If no more records are available the method returns false. |
fetchOne |
$result |
String |
This method returns the first column of the next record. |
getErrorMessage |
- |
String |
Returns the last error. |
