Combining three mysql queries into one json array in php

Question

I have a php script that has three queries that are each returning a set of results.
Now i want to combine the results from the three queries into a single JSON array.

Anyone knows how to achieve this?
The queries can't be joined.

Thanks.

What are you using to retrieve the data? mysql_*, mysqli_*, PDO... — Tomás
– Tomás, Commented Jan 14, 2014 at 13:50

hanzi · Accepted Answer · 2014-01-14 13:52:38Z

6

You might want to look into array_merge().

A simple example:

<?php
$result = array_merge($array_result_of_query1, $array_result_of_query2, $array_result_of_query3);
echo json_encode($result);
?>

answered Jan 14, 2014 at 13:52

hanzi

2,98720 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Combining three mysql queries into one json array in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related