我使用flutter和php，我只需要從數(shù)據(jù)庫中獲取40個(gè)隨機(jī)問題，但我是php的初學(xué)者！我該怎么做？見下面的代碼public function index(){$user = Auth::user();$topics = Topic::all()->toArray();$questions = Question::all()->toArray(); return response()->json(array('users' =>$user,'topics'=>$topics,'questions'=>$questions), 200);// return response()->json(['data' => $posts], 200, [], JSON_NUMERIC_CHECK);}public function show_question($id){ $topic = Topic::findOrFail($id); $user_id = Auth::user()->id; $existing = Answer::where('user_id',$user_id)->where('topic_id',$id)->first(); if($existing == ""){ $topic_ques = Question::where('topic_id', $id)->get()->shuffle(); $questions = $topic_ques->only(40); return response()->json(array('topic'=>$topic,'questions' => $questions), 200); } else{ return response()->json("test already given", 300); }}
3 回答
慕運(yùn)維8079593
TA貢獻(xiàn)1876條經(jīng)驗(yàn) 獲得超5個(gè)贊
public function index(){
$user = Auth::user();
$topics = Topic::all()->toArray();
$questions = Question::all()->random(40)->toArray();
return response()->json(array('users' =>$user,'topics'=>$topics,'questions'=>$questions), 200);
// return response()->json(['data' => $posts], 200, [], JSON_NUMERIC_CHECK);
}
public function show_question($id){
$topic = Topic::findOrFail($id);
$user_id = Auth::user()->id;
$existing = Answer::where('user_id',$user_id)->where('topic_id',$id)->first();
if($existing == ""){
$topic_ques = Question::where('topic_id', $id)->get()->shuffle();
$questions = $topic_ques->only(40);
return response()->json(array('topic'=>$topic,'questions' => $questions), 200);
}
else{
return response()->json("test already given", 300);
}
}
Helenr
TA貢獻(xiàn)1780條經(jīng)驗(yàn) 獲得超4個(gè)贊
嘗試這個(gè)：
$questions = Question::where('topic_id', $id)->inRandomOrder()->take(40)->get();有關(guān)更多信息，請(qǐng)參閱Laravel 文檔。
蕪湖不蕪
TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超7個(gè)贊
$topic_ques = Question::where('topic_id', $id)->limit(40)->get()->shuffle();只需使用限制功能。
- 3 回答
- 0 關(guān)注
- 149 瀏覽
添加回答
舉報(bào)
0/150
提交
取消