getAll / PgetAll¶
Executes the SQL and returns the all the rows as a 2-dimensional array. If an error occurs, false is returned.
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.
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.
comments powered by Disqus