How do I update user profile? Laravel-5

Question

Just want to start by saying I have no clue what I'm doing... I have a user_info table that looks like this

    Schema::create('user_info', function(Blueprint $table){
        $table->increments('id');
        $table->unsignedInteger('user_id');
        $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade')->onUpdate('cascade');
        $table->string('address');
        $table->string('city');
        $table->string('state');
        $table->string('zip');
        $table->text('description');
        $table->text('experience');
        $table->timestamps();
    });

I'm having trouble creating the update controller which looks like this right now.

public function update(Request $request)
{

  $user = $request->user();
  $data['description'] = $request->input('description');
  $data['experience']=$request->input('experience');

  $user->user_info -> $data->save();
}

again...no clue what I'm doing...

and this be my form:

    <div class='col-md-10 well form-well'>
        {!! Form::open(['method' => 'PATCH', 'action'=> ['UserController@update', Request::user()->id]]) !!}
        <div class='row'>
                <div class='form-group'>
                    <div class='col-md-2'>
                        {!! Form::label('description', 'About You')!!}
                    </div>
                    <div class='col-md-7'>
                        {!! Form::textarea('description', null, ['class'=>'form-control', 'rows'=>'3'])!!}
                    </div>
                </div>
        </div>
        <div class='row'>
                <div class='form-group'>
                    <div class='col-md-2'>
                        {!! Form::label('experience', 'Experience and Skills')!!}
                    </div>
                    <div class='col-md-7'>
                        {!! Form::text('experience', null, ['class'=>'form-control'])!!}
                    </div>
                </div>
        </div>
        <div class='form-group'>            
            {!! Form::submit('Save Changes',['class'=> 'btn btn-md btn-success']) !!}
            {!! Form::close()!!}
    </div>

Update: I was able to update it like this:

$user->user_info->description = $data['description'];
  $user->user_info->experience = $data['experience'];
  $user->user_info->save();

But is there a way I can do something like :

$user->user_info->$request::Input::all();
$user->user_info->save();

Well, that - `$user->user_info -> $data->save();` is a very strange line... Does page report about any errors ? — BlitZ, Sep 26 '15 at 06:27
i get an error exception: array to string conversion. How would it usually be written? — jackjoesmith, Sep 26 '15 at 06:40
I have no experence in Laravel, however, it is pure PHP message. I would suggest to look through manuals how it should be done properly. Also I would suggest to try something like just `$data->save()` or `$user->user_info = $data->save();`. — BlitZ, Sep 26 '15 at 06:49
I get this error when i try that `Call to a member function save() on a non-object` — jackjoesmith, Sep 26 '15 at 06:51
Well, as of your latest update, you may try to loop through `$request->input(...)` and assign their values to `$user->user_info`, then commit it to `$user->user_info->save();`. — BlitZ, Sep 26 '15 at 06:54
I suggest you to read [this question](http://stackoverflow.com/questions/22279435/what-does-mass-assignment-mean-in-laravel). The feature you asking is called *"mass assignment"*. Here is [general approach](http://stackoverflow.com/questions/17076156/how-to-mass-assign-an-update-in-laravel-4), but for laravel 4, however I think, that it might work for Laravel 5 as well. — BlitZ, Sep 26 '15 at 07:07

num8er · Accepted Answer · 2015-09-26T08:14:07.787

2

Try this:

public function update(Request $request, $id)
{
  $User = User::with('user_info')->find($id);
  if(!$User) {
    return response('User not found', 404);
  }

  $UserInfo = $User->user_info;
  if(!$UserInfo) {
    $UserInfo = new UserInfo();
    $UserInfo->user_id = $id;
    $UserInfo->save();
  }

  try {
    $values = Input::only($UserInfo->getFillable());
    $UserInfo->update($values);
  } catch(Exception $ex) {
    return response($ex->getMessage(), 400);
  }
}

also in Your UserInfo model add this:

protected $fillable = array('description', 'experience');
public function getFillable() {
  return $this->fillable;
}

edited Sep 26 '15 at 08:14

answered Sep 26 '15 at 06:56

num8er

18,604
3
43
57

Is there a way I can do mass assignment instead? Something like : ```UserInfo ->request::input->all()->save()->``` – jackjoesmith Sep 26 '15 at 06:58
Also, my model includes address but that's to be submitted from another form. I don't want to have to use a different controller action for it. – jackjoesmith Sep 26 '15 at 07:02
I get user info does not exist – jackjoesmith Sep 26 '15 at 07:11
Have You defined relation in User model? – num8er Sep 26 '15 at 07:12
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/90669/discussion-between-num8er-and-jack-duong). – num8er Sep 26 '15 at 07:13
so i should probably do something like ``` if !UserInfo{ UserInfo->user_id=$id```? – jackjoesmith Sep 26 '15 at 07:13
i get an error saying Class 'App\Http\Controllers\UserInfo' not found – jackjoesmith Sep 26 '15 at 07:19
funny :) You see that UserInfo not found so in You controller file add: user App\UserInfo; – num8er Sep 26 '15 at 07:24
lol that is funny. but now i get this : SQLSTATE[42S22]: Column not found: 1054 Unknown column '_method' in 'field list' (SQL: update `user_info` set `_method` = PATCH, `_token` = ' Is it saying i don't have a token column in my model? – jackjoesmith Sep 26 '15 at 07:27
that's because You're sending Input::all() to update :) – num8er Sep 26 '15 at 07:29
Jack, have You checked? – num8er Sep 26 '15 at 07:45
yeah sorry it still doesn't work. I'm still getting ```QLSTATE[42S22]: Column not found: 1054 Unknown column '_method' in 'field list' (SQL: update `user_info` set `_method` = PATCH, `_token` = VKUWdhmhflCenZVpGGL7iJ4Wkx0SSAasflu4Vdl6, `description` = fsdf, `experience` = fsef, `3` = , `updated_at` = 2015-09-26 07:53:04)``` – jackjoesmith Sep 26 '15 at 07:52
And I think one of the columns: '3' is the id number of the user. – jackjoesmith Sep 26 '15 at 07:54
have You added fillable to Your model? – num8er Sep 26 '15 at 07:55
is this line ` $UserInfo = ($User->user_info)? $User->user_info : new UserInfo(); ` saying 'does user -> user_info exists? if not create one?' – jackjoesmith Sep 26 '15 at 07:56
yes, but now issue is when You're doing update(Input::all()) – num8er Sep 26 '15 at 07:57
Yeah I added the fillable alreadyy. I actually did this when I first made the model. – jackjoesmith Sep 26 '15 at 07:57
Now I'm not getting any errors, but its also not updating – jackjoesmith Sep 26 '15 at 08:05
I did var_dump(UserInfo->user_id) after the update and it returns null. – jackjoesmith Sep 26 '15 at 08:08

How do I update user profile? Laravel-5

1 Answers1