getAll / PgetAll

Executes the SQL and returns the all the rows as a 2-dimensional array. If an error occurs, false is returned.

Parameters

getAll($sql)
$sql:The MySQL query to perfom on the database.

Prepared statements Parameters

PgetAll($sql, $varN)
$sql:The MySQL query to perfom on the database
$varN:The variable(s) that will be placed instead of the ? placeholder separated by a ‘,’ or it can be the method Prepare.

Example

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
<?php

require_once 'dalmp.php';

$user = getenv('MYSQL_USER') ?: 'root';
$password = getenv('MYSQL_PASS') ?: '';

$DSN = "utf8://$user:$password".'@127.0.0.1/test';

$db = new DALMP\Database($DSN);

/**
 * GetAll
 */
rs = $db->FetchMode('ASSOC')->GetAll('SELECT name, continent FROM Country WHERE Region ="Caribbean"');

/**
 * Prepared statements
 */
$rs = $db->FetchMode('ASSOC')->PGetAll('SELECT name, continent FROM Country WHERE Region = ?', 'Caribbean');

Output of print_r($rs):

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
Array
(
    [0] => Array
        (
            [name] => Aruba
            [continent] => North America
        )

    [1] => Array
        (
            [name] => Anguilla
            [continent] => North America
        )

    [2] => Array
        (
            [name] => Netherlands Antilles
            [continent] => North America
        )

    [3] => Array
        (
            [name] => Antigua and Barbuda
            [continent] => North America
        )

    [4] => Array
        (
            [name] => Bahamas
            [continent] => North America
        )

    [5] => Array
        (
            [name] => Barbados
            [continent] => North America
        )

    [6] => Array
        (
            [name] => Cuba
            [continent] => North America
        )

    [7] => Array
        (
            [name] => Cayman Islands
            [continent] => North America
        )

    [8] => Array
        (
            [name] => Dominica
            [continent] => North America
        )

    [9] => Array
        (
            [name] => Dominican Republic
            [continent] => North America
        )

    [10] => Array
        (
            [name] => Guadeloupe
            [continent] => North America
        )

    [11] => Array
        (
            [name] => Grenada
            [continent] => North America
        )

    [12] => Array
        (
            [name] => Haiti
            [continent] => North America
        )

    [13] => Array
        (
            [name] => Jamaica
            [continent] => North America
        )

    [14] => Array
        (
            [name] => Saint Kitts and Nevis
            [continent] => North America
        )

    [15] => Array
        (
            [name] => Saint Lucia
            [continent] => North America
        )

    [16] => Array
        (
            [name] => Montserrat
            [continent] => North America
        )

    [17] => Array
        (
            [name] => Martinique
            [continent] => North America
        )

    [18] => Array
        (
            [name] => Puerto Rico
            [continent] => North America
        )

    [19] => Array
        (
            [name] => Turks and Caicos Islands
            [continent] => North America
        )

    [20] => Array
        (
            [name] => Trinidad and Tobago
            [continent] => North America
        )

    [21] => Array
        (
            [name] => Saint Vincent and the Grenadines
            [continent] => North America
        )

    [22] => Array
        (
            [name] => Virgin Islands, British
            [continent] => North America
        )

    [23] => Array
        (
            [name] => Virgin Islands, U.S.
            [continent] => North America
        )
)

Thanks Navicat for supporting Open Source projects.

Navicat



A great amount of time has been spent creating, crafting and maintaining this software, please consider donating.

Donating helps ensure continued support, development and availability.

dalmp


comments powered by Disqus