Laravel array how to save to database

Question

Question is I want to store that array to database to like this and topics can be more or less.

Database Choice table

|----|---------|----------|------------------|
| id | user_id | topic_id | question_number  |
|----|---------|----------|------------------|
|  1 |   1     |1st array |        21        |
|----|---------|----------|------------------|
|  2 |   1     |2nd array |        5         |
|----|---------|----------|------------------|
|  3 |   1     |3rd array |        3         |
|----|---------|----------|------------------|
..............................................
| 34 |   1     |34  array |        5         |
|----|---------|----------|------------------|

dd

array:3 [▼
"_token" => "HhR1wmjgJUvmnRsoYxcg3yezqzq7ORKqX6dAHzCD"
"time" => "30:01"
"number" => array:34 [▼
1 => "21"
2 => "5"
3 => "3"
4 => "0"
5 => "0"
6 => "0"
........
34 => "5"
]

Controller store function

public function store(Request $request){
    $time = $request->input('time');
    foreach ($request->input('number') as $key => $value) {
        Choice::create([
            'user_id' => Auth::id(),
            'time'  => $time,
            'topic_id' => $key,
        ]);
}}

No. because i didn't found how to take arrays datas. but I'm still searching — Elliot
– Elliot, Commented Jun 6, 2018 at 7:15

Davit Zeynalyan · Accepted Answer · 2018-06-06 07:19:26Z

2

public function store(Request $request) {
    $time = $request->input('time');
    foreach ($request->input('number') as $key => $value) {
        Choice::create([
            'user_id' => Auth::id(),
            'time'  => $time,
            'topic_id' => $key, // or  $key . 'st array';
            'question_number' => $value,
        ]);
    }
}}

edited Jun 6, 2018 at 7:19

answered Jun 6, 2018 at 7:16

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges

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

4 Comments

Davit Zeynalyan Over a year ago

what is dd($request->input('number'));

Elliot Over a year ago

Of course. i was just waiting 10 minutes. for accept your answer.

Davit Zeynalyan Over a year ago

Thanks. You whant save 'topic_id' => 1, or 'topic_id . '1st array'?;

Elliot Over a year ago

No I can handle that. I guess.

Collectives™ on Stack Overflow

Laravel array how to save to database

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related