The easiest way to insert multiple tables from one form

Question

in laravel i want to insert into two tables the data from one form.

my forms are:

<input type="text" name="name"class="form-control">
<input type="text" name="age"class="form-control">
<input type="text" name="sex"class="form-control">
<input type="text" name="location"class="form-control">

i want to insert the name, age, and sex to table details. and input location to table locations

location model belongsTo detail model.

how to insert them at the same time? and how to automatically match the id of detail with detail_id of location?

i have search but too difficult to follow. i wish there's an easy way to follow.

save to details at first and then location. what's the problem. — Sagar Gautam
– Sagar Gautam, Commented Jul 13, 2017 at 15:48

Daddi Al Amoudi · Accepted Answer · 2017-07-13 15:51:05Z

5

You didn't show us your model relationships and what you have in your controller so far. But assuming your models are correctly related and your table field names are the same names as your form names, you could try this in your controller:

 public function store(Request $request)
  {
  $detail = new detail();
  $detail->name = $request->input("name");
  $detail->age = $request->input("age");
  $detail->sex = $request->input("sex");
  $detail->save();

 $location = new location();
 $location->detail_id = $detail->id;
 $location->location = $request->input("location");
 $location->save();
 }

hope this help.

answered Jul 13, 2017 at 15:51

Daddi Al Amoudi

9641 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Adriani Umar Over a year ago

Thanks i will try first

Adriani Umar Over a year ago

It give blank page. Please help.

Sagar Gautam Over a year ago

check your data base, there is no redirect route here that's why it's black page

Daddi Al Amoudi Over a year ago

redirect your page after saving. add this return view(wherever page you want it to be redirected);

Adriani Umar Over a year ago

How to accepting it? I am sorry iam new to this site

|

Collectives™ on Stack Overflow

The easiest way to insert multiple tables from one form

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related