How to insert multi IDs and save in database

Question

Categories: php, database, laravel, multi-select, laravel-7

How to insert multi IDs and save in database

Waltun. The question was asked: Apr 15, 2020. 06:03

1 answer

im using Laravel 7 and im trying to make a automation system. For send Letters, i have to be able to choose a few receivers. Here is Letter table : Letter_Table as you can see i have recieve_id i can get IDs, but i dont know how i can save IDs in my database. This is my Select :

<select class="col-12 border mt-2 pt-2" multiple="multiple" name="recieve_id[]">     @foreach($users as $user)          <option value="{{ $user->id }}">{{ $user->name }}</option>     @endforeach </select>

This is my Controller:

Letter::create([         'indicator_id' => $request['indicator_id'],         'sender_id' => auth()->user()->id,         'recieve_id' => $request['recieve_id'],         'title' => $request['title'],         'image' => 'default.png',         'description' => $request['description'],         'date' => $request['date'],         'text' => $request['text'],     ]);     return redirect(route('Letter.index'));

Thanks for your help <3

Edit:

Here is Table structure : Table Structure

All answers to this question, which has the identifier 61235532

Chaitanya Ambardekar The answer was posted: Apr 15, 2020. 06:28 · Accepted Answer

If I am understanding your question right, the code you have written in the controller is not working well or not creating database entry. Is it right?

If yes, then can you provide me with the table structure you are using for Letter as well as the migration you have written for that particular table?

I am not sure but it seems like you are passing an array $reciever_id instead of string and/or JSON string.

Also, if the table in the screenshot you provided, is to be used as the log, then I would suggest to iterate through $receiver_id and make a separate entry for each of the receiver if possible. This could be a better approach I think.

EDIT: After reading your comment, I am modifying my answer as below: In that case, you should either handle the request with foreach loop as below:

$receiver_ids = $request->receive_ids foreach($receiver_ids as $receiver_id) {     Letter::create([         'indicator_id' => $request['indicator_id'],         'sender_id' => auth()->user()->id,         'recieve_id' => $receiver_id,         'title' => $request['title'],         'image' => 'default.png',         'description' => $request['description'],         'date' => $request['date'],         'text' => $request['text'],     ]); }

Put this code in your controller. And let me know.

How to insert multi IDs and save in database

All answers to this question, which has the identifier 61235532

Last questions