updateOrCreate - Ajax only trying to create

@oli_d111

But this means that a User with the dealerApp_id does not exists yet, that's why it tries to insert, but you are missing some fields, like the lname which does not have a default value and it is not nullable.

Make sure that this $request->dealerApp_id has a value as well, and that the user really exists.

Ah amazing, thanks @nakov. This now update & submits to the DB, however the table doesn't update unless i refresh the page.

In regards to the table, please can you suggest the best way to refresh the table after an update?

I did put an ID on the body of the table and tried to get it to reset but it doesn't seem to work.

The body id was #updateTable and i tried to use

$('#updateTable').trigger("reset");

but no joy, for reference, its a bootstrap table not Datatables etc.

Thanks in advance.

Unless you are manually updating the cells in your table, then there is no way that using AJAX you can refresh it unless you reload the page. So in this cases, I do refresh the page in the success callback using:

window.location.href = window.location.href;

// or

window.location.reload();

Awesome thank you. Shame, i thought it would have been possible. Great suggestion on the window.location.reload(). Thanks for your help much appreciated. :)

Sorry to be that guy, but why would it only allow me to update only the fname and none of the other fields?

/* When click edit user */
    $('body').on('click', '#edit-user', function () {
      var dealerApp_id = $(this).data('id');
      $.get('dealerApp/' + dealerApp_id +'/edit', function (data) {
         $('#userCrudModal').html("Edit User");
          $('#btn-save').val("edit-user");
          $('#ajax-crud-modal').modal('show');
          $('#user_id').val(data.id);
          $('#fname').val(data.fname);
          $('#lname').val(data.lname);
          $('#email').val(data.email);
          $('#status').val(data.status);
      })
   });

This outputs data from the table into the modal but if i amend any of the fields except for the fname it doesn't update. I've tried outputting to the console and checking the error logs but its not giving me a reason as to why.

public function store(Request $request)
    {  
        $dealerApp = \App\User::updateOrCreate(
            ['id' => $request->user_id],
            [
                'fname' => $request->fname, 
                'email' => $request->email,
                'status' => $request->status,

            ]
        );
        return Response::json($dealerApp);
    }
    
    
    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\User  $User
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {   
        $where = array('id' => $id);
        $dealerApp  = \App\User::where($where)->first();
 
        return Response::json($dealerApp);
    }

Please can you advise.

Thanks in advance.

@oli_d111 but in your controller, you are not even adding the lname for example:

 [
   'fname' => $request->fname, 
   'email' => $request->email,
   'status' => $request->status,
]

The first array in the updateOrCreate is to find a matching row, and the second is to fields used to update or create. Am I misunderstanding your question?

That's a fair point however the main one i'm trying to update is status. In the modal i've got a dropdown but it won't take the values from the dropdown and update the DB?

<div class="row">
  <div class="col-sm-12">
     <label>Status</label>
     <select type="text" class="form-control" id="status" name="status">
         <option hidden>Select</option>
         <option value="Approved">Approved</option>
         <option value="Rejected">Rejected</option>
     </select>
  </div><!-- end col -->
</div><!-- end row -->

@oli_d111 well for this one you need to check if your data contains the Status. I usually debug JavaScript code using console.log and checking the Console tab in the browser.

So add console.log(data); and make sure that data.status contains the correct value. Or explore the Network tab for the request that you make, and make sure that the new value is there.

Also in your User model, make sure that you have status in the $fillable array.

Thanks @nakov appreciate your help. Feel like a complete tool now as it was missing from the User Model. Not sure why i didn't check there... DOH!.

Thanks again :)