Print php array values

Question

How do i print array values from this query ? I need something like 6475,7377,6367. (comma separated).

This is what i get when i do a print_r($myarray):

    Array
    (
        [0] => Array
            (
                [gift_product] => 6475
            )

        [1] => Array
            (
                [gift_product] => 7377
            )

        [2] => Array
            (
                [gift_product] => 6367
            )

    )

Thanks alot!

Answer 1

You could have handled this on the MySQL side using GROUP_CONCAT, something like this:

SELECT GROUP_CONCAT(gift_product) AS products
FROM yourTable
GROUP BY id;

Your current output indicates that you are getting back gift_product values over several records, when in fact you wanted to retrieve a CSV string of products.

Answer 2

You can use implode function after you map your array using array_map:

echo implode(', ', array_map(function ($entry) {
  return $entry['gift_product'];
}, $myarray))

Answer 3

Use array_column to fetch column wise data with implode,

echo implode(",", array_column($arr, "gift_product"));

Demo

Output

6475,7377,6367