Question 421372 in Laravel Question posted in
The official Laravel Documentation can be found here.

Laravel 9 Ajax Update Record Returning 404 error

I am trying to update a database record with ajax. The code below is returning a 404 error code.

Javascript

 data = {
         id: item_id,
         our_cost: new_price,
         _token: "{{csrf_token()}}",
      };

 $.ajax({
        url: '/change_item_price/{id}/{our_cost}',
        data: data,
        type: 'POST',
        success: function( data ) {
             console.log(data);
        }
      });

Route

Route::post('/change_item_price/{id}/{our_cost}',[itemController::class, 'change_item_price'])->name('change_item_price');

Controller

    public function change_item_price($id, $our_cost){
        $get_id = Item::findOrFail($id);
        DB::table('items')
            ->where('id', $get_id)
            ->update([
                'our_cost' => $our_cost
            ]);
        return Item::where('id',$id)->first();
    }
Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    @Olumuyiwa Thank you for your input. Your comment about the variables not being set was spot on. I changed the Ajax call as you suggested. I included the whole function:

                $('#price').on('blur', function(){
              var get_pn = document.getElementById('search_item').value;
              var new_price = document.getElementById('price').value;

                $.ajax({
                    url: "/search_item_new_price",
                    data: { search_item: get_pn},
                    type: 'GET',
                    success: function(data){
                        var our_cost = data.our_cost;
                        var item_id = data.id
                        if (new_price !== our_cost) {
                            let result = confirm("Change the price for item number " + get_pn + " to " + '$'+ new_price + "?");
                            if (result === true){

                                data = {
                                    id: item_id,
                                    our_cost: new_price,
                                    _token: "{{csrf_token()}}",
                                };
                                $.ajax({
                                    url: "/change_item_price/" + item_id,
                                    data: data,
                                    type: 'POST',
                                    success: function( data ) {
                                       //  console.log(data);
                                    }
                                });
                            }
                        }
                    }
                });
            })

  2. 0

    My assumption is the id and our_cost variables weren’t set before the Ajax call except on the data object. In that case, you might want to change how you construct your url in your Ajax call. If item_id and new_price are variables also, then your url can be

    url: `/change_item_price/${item_id}/${new_price}`

    But, if the item_id and new_price are hardcoded values , then you might want to make the id and our_cost variables first before calling them in your url.

    var {id, our_cost} = data;
url: `/change_item_price/${id}/${our_cost}`
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search