jDbWidget
in package
Tags
Table of Contents
- $_conn : mixed
- a jDbConnection object.
- __construct() : mixed
- Constructor.
- fetchAll() : array<string|int, object>
- Get all results of a query.
- fetchAllInto() : array<string|int, object>
- Get all results of a query and store values into objects which have the given class.
- fetchFirst() : object
- Run a query, and return only the first result.
- fetchFirstInto() : object
- Run a query, and store values of the first result, into an object which has the given class.
Properties
$_conn
a jDbConnection object.
private
mixed
$_conn
Methods
__construct()
Constructor.
public
__construct(mixed $connection) : mixed
Parameters
- $connection : mixed
Return values
mixed —fetchAll()
Get all results of a query.
public
fetchAll(string $query[, int $limitOffset = null ][, int $limitCount = null ]) : array<string|int, object>
Parameters
- $query : string
-
SQL query
- $limitOffset : int = null
-
the first number of the results or null
- $limitCount : int = null
-
number of results you want, or null
Return values
array<string|int, object> —array of objects which contains results values
fetchAllInto()
Get all results of a query and store values into objects which have the given class.
public
fetchAllInto(string $query, mixed $className[, int $limitOffset = null ][, int $limitCount = null ]) : array<string|int, object>
Parameters
- $query : string
-
SQL query
- $className : mixed
- $limitOffset : int = null
-
the first number of the results or null
- $limitCount : int = null
-
number of results you want, or null
Return values
array<string|int, object> —array of objects which contains results values
fetchFirst()
Run a query, and return only the first result.
public
fetchFirst(string $query) : object
Parameters
- $query : string
-
SQL query (without LIMIT instruction !)
Return values
object —the object which contains values of the record
fetchFirstInto()
Run a query, and store values of the first result, into an object which has the given class.
public
fetchFirstInto(string $query, string $classname) : object
Parameters
- $query : string
-
SQL query (without LIMIT instruction !)
- $classname : string
-
class name of the future object
Return values
object —the object which contains values of the record