Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
5.3k views
in Technique[技术] by (71.8m points)

laravel - how to get id from url to add it in database as a foreign key in another table

i want to get id form url and use it as a foreign key to put it in table in database when i do it like that a got an error that tour_id column is embty

    public function addtour(Request $request,$id) {
    $form_data = array(

        'user_id' =>  $request->input("user_id",auth::user()->id),
        'tour_id' => $request->input("tour_id",$id),
               );
    tecket::create($form_data);
    return view('submit_tour');
}

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

You want to define a route that has the id as a parameter, so something like:

Route::get('/add-tour/{id}', [TourController::class, 'addTour']);  // Laravel 8
Route::get('/add-tour/{id}', 'TourController@addTour'); // Laravel 7

The {id} parameter in the URL will be passed in as the $id in your addTour function.

What you then do with the $id such as checking it is valid is up to you.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

1.4m articles

1.4m replys

5 comments

57.0k users

...