我试图通过the将来自Mysql数据库的数据编码成JSON格式。下面是代码段:
try
{
$statement = $db->prepare($query);
$result = $statement->execute($query_params);
$rows = $statement->fetchAll();
echo print_r($rows)."<br/>";
foreach($rows as $row)
{
foreach($row as $a)
{
$studentInfo = array();
$studentInfo["course"] = $a["coursename"];
$studentInfo["grade"] = $a["grade"];
array_push($response['info'], $studentInfo);
}
}
echo json_encode($response);
}但是我无法将这个数组编码成JSON。print_r($rows)打印以下内容:
Array (
[0] => Array (
[id] => 22222
[coursename] => sp1
[grade] => B
)
[1] => Array (
[id] => 22222
[coursename] => sw1
[grade] => A-
)
[2] => Array (
[id] => 22222
[coursename] => sw2
[grade] => B+
)
)
1回波json_encode($response)打印以下内容:
{"info":null}有人能告诉我如何将这个数组解析成JSON吗?我想以JSON格式介绍每门课程及其成绩。
发布于 2014-02-26 16:22:41
try
{
$statement = $db->prepare($query);
$result = $statement->execute($query_params);
$rows = $statement->fetchAll();
echo print_r($rows)."<br/>";
$response=array();
$info=array();
foreach($rows as $row)
{
$studentInfo = array();
$studentInfo["id"]=$row["id"];
$studentInfo["course"] = $row["coursename"];
$studentInfo["grade"] = $row["grade"];
array_push($info, $studentInfo);
}
$response['info']=$info;
echo json_encode($response); // or echo json_encode($info);// whatever you want
}发布于 2014-02-25 01:31:00
我会这样做:
try {
$statement = $db->prepare($query);
$result = $statement->execute($query_params);
if($result) {
$arr = Array();
while ($row = $result->fetch_assoc()) {
$arr[] = $row;
}
echo json_encode($arr);
}
}发布于 2016-02-10 04:57:26
json_encode()可以直接对数组进行编码。
在您的代码第8行,可以这样做
echo json_encode($rows);请点击这里获取更多信息http://php.net/manual/en/function.json-encode.php
<?php
$arr = array('a' => 1, 'b' => 2, 'c' => 3, 'd' => 4, 'e' => 5);
echo json_encode($arr);
?>输出:
{"a":1,"b":2,"c":3,"d":4,"e":5}
https://stackoverflow.com/questions/22002462
复制相似问题