脚本宝典收集整理的这篇文章主要介绍了php – mysql_fetch_array echo to 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);
以上是脚本宝典为你收集整理的php – mysql_fetch_array echo to json全部内容,希望文章能够帮你解决php – mysql_fetch_array echo to json所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。