How to get array values to laravel controller and insert into the database

Question

I can get array values on scrpit array .

Script is


 $(document).on('click', '#bulk_delete', function()
    {
        var id = [];

        if(confirm("Are you sure you want to  Delete this data?"))
        {
            $('.student_checkbox:checked').each(function(){
                id.push($(this).val());
            });
            if(id.length > 0)
            {
                $.ajax({
                    url:"del",
                    method:"get",
                    data:{id:id},
                    success:function(data)
                    {
                        alert(data);
                        $('#dTable').DataTable().ajax.reload();
                    }
                });
            }
            else
            {
                alert("Please select atleast one checkbox");
            }
        }
    });

How to get these array values to laravel controller and insert into the database

Route is

Route::get('/del', 'AjaxdataController@ins');

and AjaxdataController.php is

 public function ins(Request $request )
    {

    }

Did you call the controller? Here as per the above code you are calling the route.Right? Provide code of route as well as controller so it will be helpful. — Sohil Chamadia
– Sohil Chamadia, Commented Jan 16, 2020 at 4:37
Please check the answer that i had written.That may help you. — Sohil Chamadia
– Sohil Chamadia, Commented Jan 16, 2020 at 5:09
You need to pass this as a post request and change your route as well. Right now you are doing a get request so ideally the id will be passed in the URL to which your route is not capturing. — AyB
– AyB, Commented Jan 16, 2020 at 5:14

Qonvex620 · Accepted Answer · 2020-01-16 05:47:43Z

1

try to change method type of your ajax from get to post like this.

method="POST"

and change your route to post like this

Route::post('/del', 'AjaxdataController@ins');

and call id in your controller like this

public function ins(Request $request )
{
    $id = $request->id;
}

.

edited Jan 16, 2020 at 5:47

answered Jan 16, 2020 at 5:42

Qonvex620

3,9801 gold badge12 silver badges17 bronze badges

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

Comments

Sohil Chamadia · Accepted Answer · 2020-01-16 06:22:39Z

0

Just write the below code in the controller.You will retrieve the id over there that is passed from ajax.

public function ins(Request $request )
    {
       print_r($request->id);
    }

You will get the id and then you can use the method of laravel to insert that data into the database.

Use this code in routes file instead of your code :

Route::post('/del/{id}', 'AjaxdataController@ins');

edited Jan 16, 2020 at 6:22

answered Jan 16, 2020 at 4:50

Sohil Chamadia

4261 gold badge6 silver badges18 bronze badges

5 Comments

Sohil Chamadia Over a year ago

Change the method from get to post in your ajax script code as well as in your route file also.

Test Check Over a year ago

all changed but no result.

user8034901 Over a year ago

What's the use of {id} in the route? OP obviously wants to insert multiple ids

Sohil Chamadia Over a year ago

As per the code of ajax script @TestCheck is trying to pass array of id so it can be pass as a parameter.

user8034901 Over a year ago

Parameters will be passed in the request. '/del/{id}' requires one parameter 'id' to be present in the URL, calling just /del will probably result in the URL not being found

Collectives™ on Stack Overflow

How to get array values to laravel controller and insert into the database

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related