Result into array

Question

I want to put the result of an sqli-query into an array, but I have absolutley no idea how to do that.

In the example code are 2 results, but only one of them ends up in the array.

Can't wait to hear your ideas!

$result = runSQL("SELECT `trackingnumber` FROM `tracking` WHERE `chat_id`=$chatId");                
        while ($row = $result->fetch_assoc())  {
               $res = $row['trackingnumber']; 
               $info = array($res); 
            }
        print_r($info);

@executable so runSQL returns 2 trackingnumbers, but in $info is only one of them — Justin, Oct 14 '20 at 08:24
Your query is open to [SQL injection](https://stackoverflow.com/questions/601300/what-is-sql-injection) — DarkBee, Oct 14 '20 at 08:25
Depending on your API (MySQLi/PDO), there's a `fetchAll()` you can use, so that you don't have to iterate over it, which might be easier. — Qirel, Oct 14 '20 at 08:27
@DarkBee Don't know how this should help me with this point :D — Justin, Oct 14 '20 at 08:28

score 3 · Accepted Answer · answered Oct 14 '20 at 08:24

3

You are overwriting the variable info with each iteration. You need to append your results, e.g.

$info = [];
while ($row = $result->fetch_assoc())  {
    $info[] = $row['trackingnumber']; 
}

answered Oct 14 '20 at 08:24

DarkBee

16,592
6
46
58

Result into array

1 Answers1