How to add an array to a nested array

Question

My PHP Code is the following, I need some assistance please:

//DB connection
$result = mysqli_query($con,"SELECT * FROM `clients`");
$info = array();
$count = 0;
$meta = array('page' => 1, 'pages' => 1, 'perpage' => -1, 'total' => 14, 'sort' => "asc", 'field' => "ID");

while ($row = $result->fetch_array(MYSQLI_ASSOC)) {

    $info[$row['clientid']]['id'] = $row['id'];
    $info[$row['clientid']]['name'] = $row['name'];
    $info[$row['clientid']]['email'] = $row['email'];
    $info[$row['clientid']]['cell'] = $row['cell'];

    $count++;
}

$data = json_encode(array_values($info));

echo $data;

My Result;

[{"ID":1,"name":"A","email":"[email protected]","cell":"082"}, 
 {"ID":2,"name":"B","email":"[email protected]","cell":"083"}, 
 {"ID":3,"name":"C","email":"[email protected]","cell":"079"}]

The JSON should add the meta array with the following result:

{"meta": 
       {"page": 1,"pages": 1,"perpage": -1,"total": 3,"sort": "asc","field": ID"},
 "data": [{"ID":1,"name":"A","email":"[email protected]","cell":"082"}, 
          {"ID":2,"name":"B","email":"[email protected]","cell":"083"}, 
          {"ID":3,"name":"C","email":"[email protected]","cell":"079"}]
},

u_mulder · Accepted Answer · 2018-09-06 06:25:15Z

3

Create array of required structure and json_encode it:

$data = json_encode(array(
    'meta' => $meta,
    'data' => array_values($info),
));

answered Sep 6, 2018 at 6:25

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

1 Comment

Janp Over a year ago

Thanks u_mulder for the quick response, it works 100%!

Collectives™ on Stack Overflow

How to add an array to a nested array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related