Laravel, blank record using create method

Question

I have a problem with create() method in Laravel. Every time when I try to create new record in database using this code:

    $website = Website::create([
        'user_id' => auth()->user()->id,
        'name' => $request->name,
        'url' => $request->url,
        'description' => $request->description,
        'subcategory_id' => $request->subcategory_id,
        'user_id' => $request->subcategory_extra_id,
    ]);

the column user_id (in database) equals to 0 whereas my id is 1. Of course I have fillable variable in my model:

    protected $fillable = [
    'user_id',
    'name',
    'url',
    'description',
    'subcategory_id',
];

I tried to use constant value instead of auth()->user()->id but I still have 0 as user_id in database. Using save() method solves this problem but I prefer to use create().

try dd(auth()->user()->id) or dd(auth()->id()) is it give you correct value? — bhill77
– bhill77, Commented Aug 3, 2017 at 16:47

Ohgodwhy · Accepted Answer · 2017-08-03 16:47:44Z

0

You have listed user_id twice in your keys. The 2nd time, the integer is empty.

'user_id' => $request->subcategory_extra_id,
//observe

answered Aug 3, 2017 at 16:47

Ohgodwhy

50.8k11 gold badges86 silver badges114 bronze badges

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

1 Comment

Bart Over a year ago

Didn't noticed that... Thank you!

Md. Abutaleb · Accepted Answer · 2017-08-03 16:53:03Z

0

Why you used 'user_id two times in your code? one is

'user_id' => auth()->user()->id,

and another one is

'user_id' => $request->subcategory_extra_id,

Just use one instead of two. And try to use the follwing way:

'user_id' => Auth::user()->id;

Remember: in this case you have to use the namespace of Auth class.

Hope it will work

answered Aug 3, 2017 at 16:53

Md. Abutaleb

1,6551 gold badge15 silver badges24 bronze badges

Comments

piyush · Accepted Answer · 2018-06-08 05:44:47Z

0

try to use this use Auth namespace and then

$website = Website::create([
        'user_id' => Auth::user()->id,
        'name' => $request->name,
        'url' => $request->url,
        'description' => $request->description,
        'subcategory_id' => $request->subcategory_id,
    ]);

answered Jun 8, 2018 at 5:44

piyush

851 silver badge5 bronze badges

Collectives™ on Stack Overflow

Laravel, blank record using create method

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related