ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:getall

This is an old revision of the document!


getAll

syntax
 mixed getAll {
       mixed $sql
       optional string[] $bindvars
       }

Description

The function executes a statement and returns a the entire recordset in an array or false if the statement execution fails. The presentation of the returned data can be modified by the variables $ADODB_FETCH_MODE and $ADODB_ASSOC_CASE and the function setFetchMode().

For a detailed description of the parameters passed, see execute().

Usage

/*
 * DB2 Connection assumed
*/
$ar = $db->getAll("SELECT * FROM ACT");
 
/*
 * $ar returns:
Array
(
    [0] => Array
        (
            [0] => 10
            [1] => MANAGE
            [2] => MANAGE/ADVISE
        )
 
    [1] => Array
        (
            [0] => 20
            [1] => ECOST
            [2] => ESTIMATE COST
        )
 
    [2] => Array
        (
            [0] => 30
            [1] => DEFINE
            [2] => DEFINE SPECS
 
.......
*/
 
v5/reference/connection/getall.1437490496.txt.gz · Last modified: 2017/04/21 11:35 (external edit)