我想像這樣動(dòng)態(tài)創(chuàng)建一個(gè) JSON：{"storie":[{"story_id":"111","username":"Username1","profile_photo":"boh.png","copertina":"ok.png","num_elements":"1","rating":"4.5"},{"story_id":"222","username":"Username2","profile_photo":"hello.png","copertina":"hi.png","num_elements":"2","rating":"3.5"}]}我正在嘗試從 MySQL 數(shù)據(jù)庫(kù)獲取值，并且我能夠做到這一點(diǎn)：$response = array();$sql = mysqli_query($conn, "SELECT * FROM storie WHERE userid IN (SELECT following FROM follow WHERE follower='$userid')");while($row = mysqli_fetch_assoc($sql)){ $usern = getuserinfo($row['userid'], "username", $conn); $prof_photo = getuserinfo($row['userid'], "profile_photo", $conn); $idsto=$row['storia_id']; $elem = mysqli_query($conn, "SELECT COUNT(*) AS da_vedere FROM `storie_images` WHERE storia_id='$idsto' AND imm_id NOT IN (SELECT imm_id FROM image_views WHERE viewer='$userid')"); while($ok = mysqli_fetch_assoc($elem)){ $num_elem = $ok['da_vedere']; } //here I put the line that add the array to the json array:}但問(wèn)題是這一行，它應(yīng)該創(chuàng)建一個(gè)新數(shù)組并將其放入 json 中：$response['storie'] = [array("story_id" => $idsto, "username" => $usern, "profile_photo" => $prof_photo, "copertina" => $row['copertina'], "num_elements" => $num_elem, "rating" => "4.5")];當(dāng)只有一條記錄時(shí)它有效，但如果有更多記錄它就不起作用。有人能幫我嗎？
2 回答
拉風(fēng)的咖菲貓
TA貢獻(xiàn)1995條經(jīng)驗(yàn) 獲得超2個(gè)贊
只需替換：
$response['storie'] = [array("story_id" => $idsto, "username" => $usern, "profile_photo" => $prof_photo, "copertina" => $row['copertina'], "num_elements" => $num_elem, "rating" => "4.5")];和
$response['storie'][] = array("story_id" => $idsto, "username" => $usern, "profile_photo" => $prof_photo, "copertina" => $row['copertina'], "num_elements" => $num_elem, "rating" => "4.5");
呼啦一陣風(fēng)
TA貢獻(xiàn)1802條經(jīng)驗(yàn) 獲得超6個(gè)贊
那是因?yàn)槟?while 內(nèi)使用 $response['story'] 來(lái)解決此問(wèn)題：
1-創(chuàng)建另一個(gè)名為 result 的數(shù)組，然后在 while 中使用它
$response = array();
$result = array ()
while (....)
{
//here I put the line that add the array to the json array:
$result[] = array("story_id" => $idsto, "username" => $usern, "profile_photo" => $prof_photo, "copertina" => $row['copertina'], "num_elements" => $num_elem, "rating" => "4.5");
}
2-然后在循環(huán)外使用響應(yīng)數(shù)組：
$response['storie'] = $result;
你的代碼將是這樣的：
$response = array();
$result = array ()
$sql = mysqli_query($conn, "SELECT * FROM storie WHERE userid IN (SELECT following FROM follow WHERE follower='$userid')");
while($row = mysqli_fetch_assoc($sql)){
$usern = getuserinfo($row['userid'], "username", $conn);
$prof_photo = getuserinfo($row['userid'], "profile_photo", $conn);
$idsto=$row['storia_id'];
$elem = mysqli_query($conn, "SELECT COUNT(*) AS da_vedere FROM `storie_images` WHERE storia_id='$idsto' AND imm_id NOT IN (SELECT imm_id FROM image_views WHERE viewer='$userid')");
while($ok = mysqli_fetch_assoc($elem)){
$num_elem = $ok['da_vedere'];
}
//here I put the line that add the array to the json array:
$result[] = array("story_id" => $idsto, "username" => $usern, "profile_photo" => $prof_photo, "copertina" => $row['copertina'], "num_elements" => $num_elem, "rating" => "4.5");
}
$response['storie'] = $result;
- 2 回答
- 0 關(guān)注
- 163 瀏覽
添加回答
舉報(bào)
0/150
提交
取消