How to store array in Laravel?

Question

There are two mysql tables 1.seats (id,number), 2.reservedseats(id,seat_id,sceering_id). I show all the seats of a specific sceering as checkboxes in show.blade:

{!!Form::model($screening,['method'=>'post', 'action'=> 
['ReserveController@store',$screening->auditorium->id]])!!}

<input type="hidden" name="screening_id" value="{{$screening->id}}">

@foreach($seats as $seat)

<label class="checkbox-inline">

{!!Form::checkbox('seat_id[]',$seat->id,null)!!} Number: {{$seat->number}}  

</label>

@endforeach

<div class='form-group'>

{!!Form::submit('Create Post',['class'=>'btn btn-primary '])!!}

</div>

{!!Form::close()!!}

When I click a checkbox it goes the the seat_id[] array. So I send a hidden input and an array with the seat_ids then I want to store in the reservedseats Mysql table. But in the store controller I have the problem. I'm trying something like:

public function store(Request $request){

 $screening_id = $request->screening_id;

 $seat_ids = $request->seat_id;

  foreach($seat_ids as $seat_id){

    Seatreserved::create($seat_id,$screening_id);

   }
}

So it not working but how can I solve that?

Rana Nadeem · Accepted Answer · 2020-07-08 12:31:45Z

6

Try this code

public function store(Request $request)
{
    $screening_id = $request->screening_id;
    $seat_ids = $request->seat_id;

    foreach($seat_ids as $seat_id) {
        Seatreserved::create([
            'seat_id' => $seat_id,
            'screening_id' => $screening_id
        ]);
    }
}

Also you can use

public function store(Request $request)
{
    $screening_id = $request->screening_id;
    $seat_ids = $request->seat_id;
    
    $data = [];
    foreach($seat_ids as $seat_id) {
        $data[] = [
            'seat_id' => $seat_id,
            'screening_id' => $screening_id
        ];
    }
    Seatreserved::insert($data);
}

That is better way to perform this as it will interact with database for once.

edited Jul 8, 2020 at 12:31

Rana Nadeem

1,2551 gold badge11 silver badges17 bronze badges

answered Jul 13, 2018 at 16:23

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges

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

Comments

JPark · Accepted Answer · 2018-07-13 16:26:10Z

0

You can also create a new instance of your model to store values.

Example:

foreach($seat_ids as $seat_id) {
    $reserved = new Seatreserved();

    $reserved->seat_id = $seat_id;
    $reserved->screening_id = $screening_id;

    $reserved->save();
}

answered Jul 13, 2018 at 16:26

JPark

7894 silver badges6 bronze badges

Comments

vivek thummar · Accepted Answer · 2023-05-03 07:32:36Z

0

    $input = $request->all();
        
    $invoice = Invoice::create($input);
    
    foreach($input['products'] as $key => $value){            
        $product['product_id'] = $value['product_id'];
        $product['amount'] = $value['amount']; 
        $product['invoice_id'] = $invoice->id;
        InvoiceProducts::create($product);
    }

    return redirect()->route('invoices.index')->with('success', 'Invoice Added Successfully');

}

answered May 3, 2023 at 7:32

vivek thummar

11 bronze badge

2 Comments

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

General Grievance Over a year ago

There is a return here without a function definition, which makes this look incomplete. Please fix it.

Collectives™ on Stack Overflow

How to store array in Laravel?

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related