Saving data into database using create function laravel

Question

I am having trouble saving this into database. When I submit my data into database it will only show name_of_bear and all the many relationship stuff(type_of_fish) but not the type_of_bear

Can someone explain to me why it can't work and also maybe give me an example on how it should be done. Thank you

Controller: (this works)

public function submit(Request $request)
{
    $fishType= $request->input('type_of_fish');
    $Name = $request->input('Name');
    $bearType = $request->input('bearType');

    $bear = Bear::create(['Name' => $request->input('name_of_bear')]);
    $bear->fishs()->create(['type_of_fish' => json_encode($fishType)]);

    return ('thank you');

}

But if I were to do this:

Controller : (doesn't work)

public function submit(Request $request)
{
    $fishType= $request->input('type_of_fish');
    $Name = $request->input('Name');
    $bearType = $request->input('bearType');

    $bear = Bear::create(['Name' => $Name]);
    $bear = Bear::create(['bearType' => $bearType]); --> doesn't  work if add in this
    $bear->fishs()->create(['type_of_fish' => json_encode($fishType)]);

    return ('thank you');

}

or this:

Controller: (doesn't work)

public function submit(Request $request)
{
    $fishType= $request->input('type_of_fish');
    $Name = $request->input('Name');
    $bearType = $request->input('bearType');

    $bear = Bear::create(['Name' => $Name], ['bearType' => $bearType]); --> doesn't work
    $bear->fishs()->create(['type_of_fish' => json_encode($fishType)]);

    return ('thank you');

}

try $bear = Bear::create(['Name' => $Name , 'bearType' => $bearType]); — Jigar Shah
– Jigar Shah, Commented Oct 11, 2017 at 7:18
there is another way to inserting data to data base if you need i can share it with you — Gaurav Gupta
– Gaurav Gupta, Commented Oct 11, 2017 at 7:19
@Jigar Yup it works thanks a lot. Sure I would love to know more about it (to Gaurav) — blastme
– blastme, Commented Oct 11, 2017 at 7:20

Jigar Shah · Accepted Answer · 2017-10-11 07:27:44Z

1

You can add it like this

$bear = Bear::create(['Name' => $Name , 'bearType' => $bearType]);

full code:

public function submit(Request $request)
{
    $fishType= $request->input('type_of_fish');
    $Name = $request->input('Name');
    $bearType = $request->input('bearType');

    $bear = Bear::create(['Name' => $Name , 'bearType' => $bearType]);
    return ('thank you');
} // removed extra }

For further information you can read documentation

edited Oct 11, 2017 at 7:27

answered Oct 11, 2017 at 7:22

Jigar Shah

6,2332 gold badges32 silver badges41 bronze badges

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

5 Comments

blastme Over a year ago

Tks but the documentation I had read it already and I find it a little difficult to understand. Is there possibly another resource where they would give more examples?

Jigar Shah Over a year ago

Yes there may be , you just need to google with specific topic. You can accept as answer if found useful :) .

blastme Over a year ago

$bear = Bear::create(['Name' => $Name , 'bearType' => $bearType]); is there any limit in using this? Because when I try add another field example $bear = Bear::create(['Name' => $Name, bearType=> $bearType, 'bearLocation' => $bearLocation]); it only show name and type and not the location in the database

blastme Over a year ago

Oh nvm I forgot to put protected fillable inside my model hahaha tks :)

Jigar Shah Over a year ago

Glad to help you :)

Blues Clues · Accepted Answer · 2017-10-11 07:29:16Z

1

You can just use:

$bear = Bear::create(['Name' => $Name, 'bearType' => $bearType]);

For more info, visit this link.

answered Oct 11, 2017 at 7:29

Blues Clues

1,9084 gold badges40 silver badges84 bronze badges

Comments

Sunny Doshi · Accepted Answer · 2017-10-11 07:45:56Z

1

You can insert data like this:

public function submit(Request $request)
{
    $data = array();
    $data['type_of_fish']= $request->type_of_fish;
    $data['Name'] = $request->Name;
    $data['bearType'] = $request->bearType;

    $bear = Bear::create($data);

    return ('thank you');

}

For more information read Documentation

answered Oct 11, 2017 at 7:45

Sunny Doshi

3732 silver badges11 bronze badges

Comments

Raza Mehdi · Accepted Answer · 2017-10-11 10:33:47Z

1

I would do it like this, assuming that post array keys matches column names.

$bear = Bear::create($request->all()->except(['_token', 'type_of_fish']));

answered Oct 11, 2017 at 10:33

Raza Mehdi

9415 silver badges7 bronze badges

Collectives™ on Stack Overflow

Saving data into database using create function laravel

4 Answers 4

5 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related