php – mysql_fetch_array echo to json

发布时间：2020-12-13 22:14:42 所属栏目：PHP教程来源：网络整理

导读：我试图弄清楚如何输出我的 PHP回声我的json文件. ?php$sql_query = "SELECT * FROM some_data";$result = mysql_query($sql_query);$total_rows = mysql_num_rows($result);$dataList_desc = '';$dataList_view = ''; while($row = mysql_fetch_array($resul

我试图弄清楚如何输出我的 PHP回声我的json文件.

<?php
$sql_query = "SELECT * FROM some_data";
$result = mysql_query($sql_query);
$total_rows = mysql_num_rows($result);
$dataList_desc = '';
$dataList_view = '';
    while($row = mysql_fetch_array($result)) {
            $video_desc = $row["video_desc"];
            $video_views = $row["video_views"];
            $dataList_desc .= '' . $video_desc . '';
            $dataList_view .= '' . $video_views . '';
            echo "[[" ","" . $dataList_desc . "",],[" ","" . $dataList_view . "",]";

    }
  mysql_close($con);
?>

我的输出是：

[[" ","Title 1",[" ","1000",][[" ","Title 1Title 2","1000906","Title 1Title 2Title 3","10009061150","Title 1Title 2Title 3Title 4","100090611501800","Title 1Title 2Title 3Title 4Title 5","100090611501800756","Title 1Title 2Title 3Title 4Title 5Title 6","100090611501800756558",]

我需要的是：

[["","Title 2","Title 3","Title 4","Title 5","Title 6"],["",1000,903,1150,1800,756,558]]

请帮忙.

解决方法

$desc = array(); $views = array();
while($row = mysql_fetch_array($result)) {
        $desc[] = $row["video_desc"]; // or smth like $row["video_title"] for title
        $views[] = $row["video_views"];
}
$res = array($desc,$views);
echo json_encode($res);

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!