我正试图制作一个json列表,用于我正在忙的练习应用程序。它应该看起来像这样
{
"title": "District 9",
"image": "http://api.androidhive.info/json/movies/2.jpg",
"rating": 8,
"releaseYear": 2009,
"genre": ["Action", "Sci-Fi", "Thriller"]
},<---comma is present here
{
"title": "Transformers: Age of Extinction",
"image": "http://api.androidhive.info/json/movies/3.jpg",
"rating": 6.3,
"releaseYear": 2014,
"genre": ["Action", "Adventure", "Sci-Fi"]
}
,这是我当前使用的代码
<?php
require '../../scripts/connect.php';
$y="";
$book ="";
if($result = $db->query("SELECT * FROM posts") or die ($db->error)){
if($count = $result->num_rows) {
while($row = $result->fetch_object()){
$y .= json_encode(array(
"title"=> $row->title,
"image"=>"http://www.mywebsite.com/posts/img/" . $row->id. ".jpg",
"rating"=> $row->rating,
"releaseYear"=> $row->date_added,
"genre"=> [$row->category, $row->subcategory]
), JSON_PRETTY_PRINT);
}
}
}
echo '[' .$y. ']';
?>
然而,我得到这个…单个数组之间不用逗号
分隔。[
{ "title": "This is a test",
"image": "http:'/'/www.mywebsite.com'/posts'/img'/1.jpg",
"rating": 8.7,
"releaseYear": "2015-09-02 02:19:10",
"genre": [ "genre", "genre" ]
}<---no comma here is the problem
{
"title": "This is another test",
"image": "http:'/'/www.mywebsite.com'/posts'/img'/1.jpg",
"rating": 7.7,
"releaseYear": "2015-09-03 02:19:10",
"genre": [ "genre", "genre" ]
}
]
我的问题是如何在这个实例中添加逗号来分隔每个json对象。由于
您实际json_encode()
的唯一东西是单个图书数组。因为您只是简单地将所有这些JSON
块粘贴在彼此后面,所以没有为您添加逗号。
你应该把所有的书放在一个数组中,json_encode()
是整个图书数组,而不是手动添加逗号。
这确保您在整个输出中有正确的JSON
。
$books = []; // I renamed $y to $books, seems clearer.
$book = ""; // This doesn't do anything remove it.
if($result = $db->query("SELECT * FROM posts") or die ($db->error)){
if($count = $result->num_rows) {
while($row = $result->fetch_object()){
$books[] = [
"title" => $row->title,
"image" =>"http://www.mywebsite.com/posts/img/" . $row->id. ".jpg",
"rating" => $row->rating,
"releaseYear" => $row->date_added,
"genre" => [$row->category, $row->subcategory]
];
}
}
}
echo json_encode($books, JSON_PRETTY_PRINT);