Question

PHP输出JSON问题

<?php
require_once 'fuc.php';
$conn = connectdb();
mysql_query("set names 'utf8'");
mysql_select_db("empirecms");
$q=mysql_query('select title,kisim,id,titlepic from phome_ecms_movie ORDER BY newstime LIMIT 20');
$json=array();
$arr=array();
while($row = mysql_fetch_array($q)){
$arr["title"]=$row["title"];
$arr["kisim"]=$row["kisim"];
$arr["id"]=$row["id"];
$arr["pic"]=$row["titlepic"];
$json[]=$arr;
}
echo json_encode($json);
?>
上面是我的代码

我想仿 http://kino.nazirkom.com/jsont.php 这个样式 我看他是嵌套的 有RESULT TOP DATA 这几个Key 怎么写才能跟他一样呢 求大神帮忙

Answer 1

<?php
require_once 'fuc.php';
$conn = connectdb();
mysql_query("set names 'utf8'");
mysql_select_db("empirecms");
$q=mysql_query('select title,kisim,id,titlepic from phome_ecms_movie ORDER BY newstime LIMIT 20');
$data=array();
$arr=array();
$top=array();

$i=1;
while($row = mysql_fetch_array($q)){
$arr[]["title"]=$row["title"];
$arr[]["kisim"]=$row["kisim"];
$arr[]["id"]=$row["id"];
$arr[]["pic"]=$row["titlepic"];
if ($i<=3)
{
$top[]=$row;
}

$i++;
}
$data['data']=$arr;
$data['top']=$top;
$data['elan']=$top;
$data['result']='ok';
echo json_encode($data);
?>

Answer 2

都是数组啊，添加键值不就可以了么。

追问

我刚学PHP 你能详细点吗？

Answer 3

$json['DATA'][]=$arr;