Constructor
jDbWidget
__construct
( $connection)
Get all results of a query
array
fetchAll
(string $query, [integer $limitOffset = null], [integer $limitCount = null])
-
string
$query: SQL query
-
integer
$limitOffset: the first number of the results or null
-
integer
$limitCount: number of results you want, or null
Get all results of a query and store values into objects which have the given class
array
fetchAllInto
(string $query, $className, [integer $limitOffset = null], [integer $limitCount = null], string $classname)
-
string
$query: SQL query
-
string
$classname: class name of future objects
-
integer
$limitOffset: the first number of the results or null
-
integer
$limitCount: number of results you want, or null
-
$className
Run a query, and return only the first result.
object the
fetchFirst
(string $query)
-
string
$query: SQL query (without LIMIT instruction !)
Run a query, and store values of the first result, into an object which has the given class
object the
fetchFirstInto
(string $query, string $classname)
-
string
$query: SQL query (without LIMIT instruction !)
-
string
$classname: class name of the future object