以自定义格式对php记录集进行编码
我目前有一个使用Dreamweaver创建的记录集,并且以json格式对结果进行编码,该结果工作正常。以自定义格式对php记录集进行编码
记录
$maxRows_rs_feeds = 3;
$pageNum_rs_feeds = 0;
if (isset($_GET['pageNum_rs_feeds'])) {
$pageNum_rs_feeds = $_GET['pageNum_rs_feeds'];
}
$startRow_rs_feeds = $pageNum_rs_feeds * $maxRows_rs_feeds;
mysql_select_db($database_vivalooks, $vivalooks);
$query_rs_feeds = "SELECT fname,lname FROM profile";
$query_limit_rs_feeds = sprintf("%s LIMIT %d, %d", $query_rs_feeds, $startRow_rs_feeds, $maxRows_rs_feeds);
$rs_feeds = mysql_query($query_limit_rs_feeds, $vivalooks) or die(mysql_error());
$row_rs_feeds= mysql_fetch_assoc($rs_feeds);
if (isset($_GET['totalRows_rs_feeds'])) {
$totalRows_rs_feeds = $_GET['totalRows_rs_feeds'];
} else {
$all_rs_feeds = mysql_query($query_rs_feeds);
$totalRows_rs_feeds = mysql_num_rows($all_rs_feeds);
}
$totalPages_rs_feeds = ceil($totalRows_rs_feeds/$maxRows_rs_feeds)-1;
do {
echo json_encode($row_rs_feeds);
} while ($row_rs_feeds = mysql_fetch_assoc($rs_feeds));
mysql_free_result($rs_feeds);
记录结果
{"fname":"Benjamin","lname":"Blay"}{"fname":"Alfread","lname":"Mark"}{"fname":"yaa","lname":"tiwaa"}
但我想要的结果进行编码这样而
[{"fname":"Benjamin","lname":"Blay"},{"fname":"Alfred","lname":"Mark"},{"fname":"yaa","lname":"tiwaa"}]
尝试
do {
$json[]=json_encode($row_rs_feeds);
} while ($row_rs_feeds = mysql_fetch_assoc($rs_feeds));
echo "[".implode(", ", $json)."]";
OR
do {
$rows[] = $row_rs_feeds;
} while ($row_rs_feeds = mysql_fetch_assoc($rs_feeds));
echo json_encode($rows);
尝试:
do {
$rows[] = $row_rs_feeds;
} while ($row_rs_feeds = mysql_fetch_assoc($rs_feeds));
echo json_encode($rows);
谢谢,但它不工作,这是结果如何显示:[“{\”fname \“:\”Benjamin \“,\”lname \“:\”Blay \“}”,“{\”fname \ “:\”Alfred \“,\”lname \“:\”Mark \“}”,“{\”fname \“:\”yaa \“,\”lname \“:\”tiwaa \“}想用这种格式[{“fname”:“Benjamin”,“lname”:“Blay”},{“fname”:“Alfred”,“lname”:“Mark”},{“fname”:“yaa “,”lname“:”tiwaa“}] – neiza
请将您的新实施粘贴到此处,请 –
执行如下?我不明白 – neiza
你可以改变你的循环看起来像这样:
echo "[";
$count = 0;
do {
if($count !== 0)
echo ",";
$count++;
echo json_encode($row_rs_feeds);
} while ($row_rs_feeds = mysql_fetch_assoc($rs_feeds));
echo "]";
$ count是那里只是第一跳 “” 所以你不” t得到[,{...},{...}]或者你可以把它当作假/真...我现在不记得什么更好的情况下,你有10k步骤循环...
您应该了解[为什么不应该使用mysql_ *函数](http://*.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php)。 – Ekin