1getAll / PgetAll
2================
3
4Executes the SQL and returns the all the rows as a 2-dimensional array. If an
5error occurs, false is returned.
6
7Parameters
8..........
9
10::
11
12    getAll($sql)
13
14:$sql: The MySQL query to perfom on the database.
15
16Prepared statements Parameters
17..............................
18
19::
20
21    PgetAll($sql, $varN)
22
23:$sql: The MySQL query to perfom on the database
24:$varN: The variable(s) that will be placed instead of the **?** placeholder separated by a ',' or it can be the method `Prepare </en/latest/database/Prepare.html>`_.
25
26Example
27.......
28
29.. code-block:: php
30   :linenos:
31   :emphasize-lines: 15, 20
32
33   <?php
34
35   require_once 'dalmp.php';
36
37   $user = getenv('MYSQL_USER') ?: 'root';
38   $password = getenv('MYSQL_PASS') ?: '';
39
40   $DSN = "utf8://$user:$password".'@127.0.0.1/test';
41
42   $db = new DALMP\Database($DSN);
43
44   /**
45    * GetAll
46    */
47   rs = $db->FetchMode('ASSOC')->GetAll('SELECT name, continent FROM Country WHERE Region ="Caribbean"');
48
49   /**
50    * Prepared statements
51    */
52   $rs = $db->FetchMode('ASSOC')->PGetAll('SELECT name, continent FROM Country WHERE Region = ?', 'Caribbean');
53
54
55Output of ``print_r($rs)``:
56
57.. code-block:: rest
58   :linenos:
59
60   Array
61   (
62       [0] => Array
63           (
64               [name] => Aruba
65               [continent] => North America
66           )
67
68       [1] => Array
69           (
70               [name] => Anguilla
71               [continent] => North America
72           )
73
74       [2] => Array
75           (
76               [name] => Netherlands Antilles
77               [continent] => North America
78           )
79
80       [3] => Array
81           (
82               [name] => Antigua and Barbuda
83               [continent] => North America
84           )
85
86       [4] => Array
87           (
88               [name] => Bahamas
89               [continent] => North America
90           )
91
92       [5] => Array
93           (
94               [name] => Barbados
95               [continent] => North America
96           )
97
98       [6] => Array
99           (
100               [name] => Cuba
101               [continent] => North America
102           )
103
104       [7] => Array
105           (
106               [name] => Cayman Islands
107               [continent] => North America
108           )
109
110       [8] => Array
111           (
112               [name] => Dominica
113               [continent] => North America
114           )
115
116       [9] => Array
117           (
118               [name] => Dominican Republic
119               [continent] => North America
120           )
121
122       [10] => Array
123           (
124               [name] => Guadeloupe
125               [continent] => North America
126           )
127
128       [11] => Array
129           (
130               [name] => Grenada
131               [continent] => North America
132           )
133
134       [12] => Array
135           (
136               [name] => Haiti
137               [continent] => North America
138           )
139
140       [13] => Array
141           (
142               [name] => Jamaica
143               [continent] => North America
144           )
145
146       [14] => Array
147           (
148               [name] => Saint Kitts and Nevis
149               [continent] => North America
150           )
151
152       [15] => Array
153           (
154               [name] => Saint Lucia
155               [continent] => North America
156           )
157
158       [16] => Array
159           (
160               [name] => Montserrat
161               [continent] => North America
162           )
163
164       [17] => Array
165           (
166               [name] => Martinique
167               [continent] => North America
168           )
169
170       [18] => Array
171           (
172               [name] => Puerto Rico
173               [continent] => North America
174           )
175
176       [19] => Array
177           (
178               [name] => Turks and Caicos Islands
179               [continent] => North America
180           )
181
182       [20] => Array
183           (
184               [name] => Trinidad and Tobago
185               [continent] => North America
186           )
187
188       [21] => Array
189           (
190               [name] => Saint Vincent and the Grenadines
191               [continent] => North America
192           )
193
194       [22] => Array
195           (
196               [name] => Virgin Islands, British
197               [continent] => North America
198           )
199
200       [23] => Array
201           (
202               [name] => Virgin Islands, U.S.
203               [continent] => North America
204           )
205   )