Laravel - Remove JSON header before saving to DB

Question

I am fairly new to Laravel and Json.

I am looking to save JSON data directly to MYSQL table. Everything is working fine but this is the output I am getting which is being stored:

HTTP/1.0 200 OK
Cache-Control: no-cache, private
Content-Type:  application/json
Date:          Sun, 01 Oct 2017 04:10:34 GMT

{"_token":"53jnwIYCnLu1jeHdSVcL75Mgw2OD6RmZAh7Ojdyy","name":"adfadfdafd"}

I would like this to be the output saved in the db and everything else ignored:

{"_token":"53jnwIYCnLu1jeHdSVcL75Mgw2OD6RmZAh7Ojdyy","name":"adfadfdafd"}

Here is my controller:

public function addleads(Request $request)
    {
        $lead = new Lead;
        $lead->lead_data = response()->json($request);
        $lead->save();   
    }

View

           <!-- load jQuery -->
            <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>

            <!-- provide the csrf token -->
            <meta name="csrf-token" content="{{ csrf_token() }}" />
            <input class="name"></input>
            <button class="postbutton">Post via ajax!</button> 
            <script>
                $(document).ready(function(){
                    var CSRF_TOKEN = $('meta[name="csrf-token"]').attr('content');
                    $(".postbutton").click(function(){
                        $.ajax({
                            /* the route pointing to the post function */
                            url: "{{ route('addleads') }}",
                            type: 'POST',
                            /* send the csrf-token and the input to the controller */
                            data: {_token: CSRF_TOKEN, name:$(".name").val()},
                            dataType: 'JSON',
                            /* remind that 'data' is the response of the AjaxController */
                            success: function (data) { 
                                console.log(JSON.parse(data)); 
                            }
                        }); 
                    });
               });    
            </script>

Hanlin Wang · Accepted Answer · 2017-10-01 04:33:10Z

1

based on your code, you can use this

public function addleads(Request $request)
{
    $lead = new Lead;
    $lead->lead_data = response()->json($request)->getContent();
    $lead->save();   
}

if you are not actually want to get response json, but request json, you can call $request->json() or json_encode($request->all())

edited Oct 1, 2017 at 4:33

answered Oct 1, 2017 at 4:20

Hanlin Wang

7794 silver badges17 bronze badges

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

4 Comments

Raja Abbas Over a year ago

getting this error: file : "D:\xampp\htdocs\leadcapture\vendor\laravel\framework\src\Illuminate\Support\Str.php" line : 334 message : "Object of class Symfony\Component\HttpFoundation\ParameterBag could not be converted to string"

Milan Chheda Over a year ago

I think, instead of $request->json(), you can use $request->all() to fetch all parmeters.

Hanlin Wang Over a year ago

@RajaAbbas i've updated the code based on your old code, it's a symfony function

Raja Abbas Over a year ago

Thank You @HanlinWang you are awesome. I used the json_encode($request->all()) method.

Deepansh Sachdeva · Accepted Answer · 2017-10-01 05:03:18Z

0

You just need to extract the required data from request and save, like this:

public function addleads(Request $request) { 
    $lead = new Lead; 
    $lead->lead_data = json_encode($request->only('_token', 'name'));
    $lead->save(); 
}

edited Oct 1, 2017 at 5:03

answered Oct 1, 2017 at 4:30

Deepansh Sachdeva

1,1989 silver badges16 bronze badges

Collectives™ on Stack Overflow

Laravel - Remove JSON header before saving to DB

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related