Can not insert a new text input value into db from laravel register form

Question

In a laravel app I had run the command

php artisan make:auth

and a laravel register form created successfully.

In mysql users' table I had added a proffession field of varchar datatype column and 190 length.

And I updated Auth/register.blade.php page to the following

register.blade.php

<div class="form-group">
<label for="proffession" class="col-md-4 control-label"> proffession </label>
 <div class="col-md-6">
 <input id="proffession" type="text" class="form-control" name="porffession" 
 value="{{ old('proffession') }}" required>
 </div>
 </div>

My RegisterController.php class

    protected function validator(array $data)
        {
          return Validator::make($data, [
               'name' => 'required|string|max:255',
               'phone' => 'required|string|max:255',
              'email' => 'required|string|email|max:255|unique:users',
               'password' => 'required|string|min:6|confirmed',
         ]);
    }

    protected function create(array $data)
    {
        return User::create([
            'name' => $data['name'],
             'phone' => $data['phone'],
            'email' => $data['email'],
            'password' => bcrypt($data['password']),
        ]);
    }
}

but when I click the submit button the proffession column value is always null although a new user added.

Automatically I am drawn to: name="porffession" typo.. surely should be name="proffession" no? — Option
– Option, Commented Mar 28, 2018 at 12:17
@Option It seems the problem from mission of proffession RegistereController.php — Webdev
– Webdev, Commented Mar 28, 2018 at 12:28

Option · Accepted Answer · 2018-03-28 12:45:59Z

1

Looking at your view code I can see that name="porffession" should surely be name="proffession"

Change your controller code from:

return User::create([
            'name' => $data['name'],
             'phone' => $data['phone'],
            'email' => $data['email'],
            'password' => bcrypt($data['password']),
        ]);

to:

return User::create([
    'name' => $data['name'],
    'phone' => $data['phone'],
    'email' => $data['email'],
    'password' => bcrypt($data['password']),
    'proffession' => $data['proffession'],
]);

and fix the typo as mentioned above.

Also within the User.php model add proffession to the $fillable if you haven't already.

edited Mar 28, 2018 at 12:45

answered Mar 28, 2018 at 12:20

Option

2,6452 gold badges21 silver badges29 bronze badges

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

8 Comments

Webdev Over a year ago

Option Over a year ago

@WebDev, For testing purposes I wouldn't touch verification for now. Get it working first and then you can add it after.

Webdev Over a year ago

'profession' => $request->get('profession') where this statement to be?

Option Over a year ago

@WebDev, I have revised and edited. I added that initially because you had no controller code. I have now removed. Replace the block coding as given above.

Option Over a year ago

@webdev, my mistake sorry.. I put profession where as you are using proffession I have adjusted the code block accordingly. Please edit the code block with the updated version and then retry

|

Collectives™ on Stack Overflow

Can not insert a new text input value into db from laravel register form

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related