PHP Get multiple data from mysql in array

Question

I am trying to get multiple columns data in a array fromate form data base like for example

[{"id":"3","category":"Name","text":"text with some data","image":"http:\/\/examole.net\/folder\/images\/category1.jpg"},{"id":"4","category":"Name","text":"text with some data","image":"http:\/\/examole.net\/folder\/images\/category1.jpg"}]

using for each statement i am not able to do it as a json response

$response = array();
if(isset($_REQUEST['action']) && $_REQUEST['action']=='test'){
        $query="select * from exampledb where id='".$db->escape($_REQUEST['id'])."'";
        $num= $db->num_rows($query);          
        if($num)
        {
            $rows = $db->get_results($query);

            foreach($rows as $row1) { 

                $response['id'] = $row1['id'];
                $response['category'] = $row1['category'];
                $response['text'] = $row1['text'];
                $response['image'] = $row1['image'];
            }       
        }
        else{
            $response['message']='No user Found';
            $response['status']='fail';
        }

    }

there are 4 rows data that needs to be shown but i am getting only one last rows {"id":"4","category":"90","text":"4","image":"Test4"} — Shaik
– Shaik, Commented Feb 6, 2017 at 18:21

Oscar Zarrus · Accepted Answer · 2017-02-06 18:25:52Z

3

after your else

else{
            $response['message']='No user Found';
            $response['status']='fail';
        }

echo json_encode($response) //<---- here convert array to json text

PHP json_encode

UPDATE

foreach($rows as $k=>$row1) { //add index $k to use an automatic autoincrement for the key
//and put it inside each fields
                $response[$k]['id'] = $row1['id'];
                $response[$k]['category'][] = $row1['category'];
                $response[$k]['text'] = $row1['text'];
                $response[$k]['image'] = $row1['image'];
            }

edited Feb 6, 2017 at 18:25

answered Feb 6, 2017 at 18:10

Oscar Zarrus

8101 gold badge10 silver badges18 bronze badges

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

3 Comments

Oscar Zarrus Over a year ago

can you post the json response ?

Shaik Over a year ago

{"id":"4","category":"90","text":"4","image":"Test4"}

Shaik Over a year ago

stackoverflow.com/questions/42077446/…

Collectives™ on Stack Overflow

PHP Get multiple data from mysql in array

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related