PHP MYSQL Json问题

Question

We have a simple php mysql json api to provide data to android app

We have a fix categories.

so we just check if category is this then fetch result from mysql database and convert in json

Everything is working fine. Fetching url from mysql

$stm_row = $stm->fetchAll(PDO::FETCH_ASSOC);

Till here all is working fine. data is coming from every category

Then, we convert data to JSON:

print(json_encode($stm_row));

But the problem is that only 1 catgory data is printing using json, rest category data showing blank

Can you please check what can be issue

Answer 1

i am giving you simple demonstration how to work with json.you can try like that

$data=array();
while($row = mysqli_fetch_array($query)) {
  $data[] = $row['your field name'];
}
echo json_encode(array("response"=>$data));