如何限制php中的问题？

Question

我使用flutter和php，我只需要从数据库中获取40个随机问题，但我是php的初学者！我该怎么做？见下面的代码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);      }}

Answer 1

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);  

    }

}

Answer 2

尝试这个：

$questions = Question::where('topic_id', $id)->inRandomOrder()->take(40)->get();

有关更多信息，请参阅Laravel 文档。

Answer 3

 $topic_ques = Question::where('topic_id', $id)->limit(40)->get()->shuffle();

只需使用限制功能。