Database update in laravel using Ajax

Question

I was following this tutorial to update or edit database table in Laravel. I have implemented the insertion section as follows:

$(document).on('click', '.edit', function(){
            var id = $(this).attr("id");
            $('#form_output').html('');
            $.ajax({
                url:"{{route('ajax_data_manage.fetchdata')}}",
                method:'get',
                data:{id:id},
                dataType:'json',
                success:function(data)
                {
                    $('#player_name').val(data.player_name);
                    $('#player_country').val(data.player_country);
                    $('#player_age').val(data.player_age);

                    $('#player_id').val(id);
                    $('#playerModal').modal('show');
                    $('#action').val('Edit');
                    $('.modal-title').text('Edit Data');
                    $('#button_action').val('update');
                }
            })
        });

in controller file:

function fetchdata(Request $request)
{
    $id = $request->input('id');
    $player = Player::find($id);
    $output = array(
        'player_name'    =>  $player->player_name,
        'player_country' =>  $player->player_country,
        'player_age'     =>  $player->player_age
    );
    echo json_encode($output);
}

I think the error is in fetching the data. My Player table in the database has three columns (name, country, age) and the id and name of text-box in the form group:

<div class="form-group">
                        <label>Enter Player Name</label>
                        <input type="text" name="player_name" id="player_name" class="form-control" />
                    </div>
                    <div class="form-group">
                        <label>Enter Player Country</label>
                        <input type="text" name="player_country" id="player_country" class="form-control" />
                    </div>
                    <div class="form-group">
                        <label>Enter Player Age</label>
                        <input type="text" name="player_age" id="player_age" class="form-control" />
                    </div>

when I click the edit button, nothing is happen. I have also edited the web.php file

Route::get('ajaxdatamanage','AdminController@index')->name('ajax_data_manage');
Route::get('ajaxdatamanage/getdata', 'AdminController@getdata')->name('ajax_data_manage.getdata');
Route::post('ajaxdatamanage/postdata', 'AdminController@postdata')->name('ajax_data_manage.postdata');

Route::get('ajaxdatamanage/fetchdata', 'AdminController@fetchdata')->name('ajax_data_manage.fetchdata')

1. check data is coming from controller by putting console.log (data) in success function — arun
– arun, Commented Dec 26, 2019 at 15:42

Priyank Panchal · Accepted Answer · 2019-12-27 10:37:39Z

1

You will get full demo for this and it will help full for you.

https://github.com/PriyankPanchal/AJAX-CRUD-Laravel

Please clone project from using above link and after clone fire some command as below.

1) composer update 2) Set Up env file and set database details in .env file. 3) php artisan migrate

Hope this demo project will help you. Thanks PHPanchal

answered Dec 27, 2019 at 10:37

Priyank Panchal

1196 bronze badges

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

Comments

user12606897 · Accepted Answer · 2019-12-27 10:53:51Z

0

function fetchdata(Request $request)
{
    $id = $request->input('id');
    $player = Player::find($id);
    $output = array(
        'player_name'    =>  $player->player_name,
        'player_country' =>  $player->player_country,
        'player_age'     =>  $player->player_age
    );
    // try this 
    $update = Player::where('id',$id)->update($output);
    // or 
    $player->player_name;
    $player->player_country;
    $player->player_age;
    $player->save();
    echo json_encode($player);
}

answered Dec 27, 2019 at 10:53

user12606897

1 Comment

Pratik Bhavsar Over a year ago

Explaining why/how your code solves the issue posted by OP would be more helpful to future visitors.

Collectives™ on Stack Overflow

Database update in laravel using Ajax

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related