I want to store my query result in an array, so that I can convert this to Json. At the moment my result is stored in q. How can I get the result to an array`?
$sqlQuery ="SELECT * FROM data2";
$q = $pdo->query($sqlQuery);
Asked
Active
Viewed 388 times
0
-
You should google for the `fetch()` method – Twinfriends Nov 14 '17 at 10:36
-
I've removed the `json` tag since it doesn't really have anything to do with the question on `how can I get the result to an array` and added the `pdo` tag instead. – Xatenev Nov 14 '17 at 10:38
-
1$result = $query->fetch(PDO::FETCH_ASSOC); – Milan Chheda Nov 14 '17 at 10:39
-
->fetchAll(PDO::FETCH_ASSOC) – Daniel E. Nov 14 '17 at 10:40
-
With the ->fetch() I can save the data. Now I want to see If all row values are included. How can I cycle trugh the array, if the array is an associative one? – marciano Nov 14 '17 at 10:52
-
Are you talking of one row or of several rows? from your query you should get multiple rows – Your Common Sense Nov 14 '17 at 10:56
-
Either way, use foreach to iterate any arrays – Your Common Sense Nov 14 '17 at 11:02