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 )