Return values of sql into a JSON array

Question

I have a SQL query, I use a foreach to return these values into a JSON array. Here is how my code looks like:

$sql = "SELECT SUM(sales) from sales ... blah blah";
$result = mysqli_query($connection, $sql);
$output = array();

foreach(result as $row) {
    $output[] = $row;
}

$json = json_encode($output);
echo $json; // Returns the array

The array currently looks like this:

[{"SUM(sales)}"."10000"},[{"SUM(sales)}"."51221"},[{"SUM(sales)}"."2351"}]

I want it to be like this: [10000, 51221, 2351]

When I use decode($output) it returns NULL.

(*) If your sql has user input (like from a GET or POST var), then you need to change to using a prepared statement, execute, with fetch. Otherwise you are open to sql injection attacks. — IncredibleHat
– IncredibleHat, Commented Jan 27, 2018 at 2:56
What do you mean by decode($output) ? That isn't any php function I am aware of. — IncredibleHat
– IncredibleHat, Commented Jan 27, 2018 at 3:00

Roman Vynohradov · Accepted Answer · 2018-01-27 01:45:19Z

2

try this

$result = mysqli_query($connection, $sql);
$output = array();
foreach($result as $row){
    array_push($output, $row['SUM(sales)']);
}
$json = json_encode($output);
echo $json;

answered Jan 27, 2018 at 1:45

Roman Vynohradov

363 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

FilipRistic Over a year ago

Giving some information about your solution will help a lot more to OP and to other people that visit SO, so please update your answer.

Roman Vynohradov Over a year ago

sure, i can do it tomorrow, currently I have a late evening

IncredibleHat Over a year ago

Also a way to make the row field selection clearer, is to adjust it in the SQL like so: SELECT SUM(sales) as SumSales FROM sales ... That way you can use $row['SumSales'] (if thats more readable for you, personally I always name SUM() and COUNT(*) and the like).

Collectives™ on Stack Overflow

Return values of sql into a JSON array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related