我在嘗試通過將用戶輸入與資料庫中的資料進行比較來獲取 id 時遇到了這個問題。我是新手,我嘗試了一些根本沒有幫助的解決方案。
下面是我的控制器代碼:
public function assign(Request $request)
{
$courselist = new Courselist;
$coursecode = $request->input('coursecode');
$courseid = DB::select("select id from course where course_code = '$coursecode'");
$courselist -> course_id = $courseid;
$courselist -> coordinator = $request->input('coordinatorname');
$courselist -> internal = $request->input('imname');
$courselist -> external = $request->input('exname');
$courselist -> dean = $request->input('deanname');
$courselist -> save();
return back()-> with('alert-success','Data successfully added!');
}
uj5u.com熱心網友回復:
$course = DB::table("your table name")->where("course_code ", "=", $coursecode)->first();
$courselist -> course_id = $course->id;
試試這個我希望它會起作用。
轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/344432.html
