My PHP Code is the following, I need some assistance please:
我的PHP代码如下,我需要一些帮助:
//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":"a@a.com","cell":"082"},
{"ID":2,"name":"B","email":"b@b.com","cell":"083"},
{"ID":3,"name":"C","email":"c@c.com","cell":"079"}]
The JSON should add the meta array with the following result:
JSON应该添加元数组,结果如下:
{"meta":
{"page": 1,"pages": 1,"perpage": -1,"total": 3,"sort": "asc","field": ID"},
"data": [{"ID":1,"name":"A","email":"a@a.com","cell":"082"},
{"ID":2,"name":"B","email":"b@b.com","cell":"083"},
{"ID":3,"name":"C","email":"c@c.com","cell":"079"}]
},
1 个解决方案
#1
3
Create array of required structure and json_encode
it:
创建所需结构的数组并将其json_encode:
$data = json_encode(array(
'meta' => $meta,
'data' => array_values($info),
));
#1
3
Create array of required structure and json_encode
it:
创建所需结构的数组并将其json_encode:
$data = json_encode(array(
'meta' => $meta,
'data' => array_values($info),
));