Two MySQL output in single JSON encode in PHP

Question

I have two MySQL output which I need to encode in a single JSON output.

Output 1:

$sql = "select * from t1 ORDER BY id DESC LIMIT 25";
$result = $conn->query($sql);

    while($row = $result->fetch_assoc()) {
    $output[] = array_map("nl2br", $row);
    }

Output 2:

$sql2 = "select * from t2 ORDER BY id DESC LIMIT 25";
$result2 = $conn->query($sql2);

    while($row2 = $result2->fetch_assoc()) {
    $output2[] = array_map("nl2br", $row2);
    }

This is what I am doing to get them in single JSON_encode:

echo json_encode($output.$output2);

still not getting both the outputs. I came to know of another solutions i.e. to merge both the queries but I am not able to do that as well. I referred this question also but no luck :(

@PaulBain Thanks for your help But this is giving the output as [[{"id":"1"}],[{"id":"2"}]] and I need the output as [{"id":"1"},{"id":"2"}] — IAmNoob
– IAmNoob, Commented Jul 14, 2015 at 8:56
So just append your stuff to the first array. Instead of $output2[] = array_map("nl2br", $row2); do $output[] = array_map("nl2br", $row2); And finally do json_encode($output) — Marius
– Marius, Commented Jul 14, 2015 at 8:59

Anton · Accepted Answer · 2015-07-14 09:07:21Z

3

How about using UNION in your query? Please check it out here: https://dev.mysql.com/doc/refman/5.0/en/union.html
What about

$fullOutput = array_merge($output1, $output2); echo json_encode($fullOutput);

answered Jul 14, 2015 at 9:07

Anton

1,0518 silver badges21 bronze badges

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

1 Comment

IAmNoob Over a year ago

$fullOutput = array_merge($output1, $output2); did it!! Thanks a lot!!

Collectives™ on Stack Overflow

Two MySQL output in single JSON encode in PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related