How to insert form values into database via jquery ajax using laravel?

Question

controller: UserController.php

<?php
    namespace App\Http\Controllers;
    use Illuminate\Http\Request;
    use DB;
    use App\Http\Requests;
    use App\Http\Controllers\Controller;

    class UserController extends Controller {
        public function insertform() {
            return view('contact-us');
        }
        public function enq()
        {
            $name = $this->input->post('name');
            $phone = $this->input->post('phone');
            $email = $this->input->post('email');
            $msg = $this->input->post('msg');
            $data=array('name'=>$name,"phone"=>$phone,"email"=>$email,"msg"=>$msg);
            DB::table('enquiry')->insert($data);
            echo "Record inserted successfully";
        }
    }

View: Contact-us.blade.php

<script>
    $(document).ready(function(){
        $("#submit").click(function(e){
            e.preventDefault();
            name = $("#name").val(); 
            phone = $("#phone").val();
            email = $("#email").val();
            msg = $("#msg").val();
            $.ajax({
                type:"POST",
                data:{"name":name,"phone":phone,"email":email,"msg":msg},
                url:"/enq",
                success:function(data){
                    $("#success").html(data);
                }
            });
        });
    });
</script>
<div id="success"></div>
<form method="post">
    <input type="text" placeholder="Your Name" name="name" id="name">
    <input type="text" placeholder="Phone Number" name="phone" id="phone">
    <input type="text" placeholder="Email Adress" name="email" id="email">
    <textarea placeholder="Massege" name="msg" id="msg"></textarea>
    <input type="submit" name="submit" id="submit" value="submit now" class="btn-blue">
</form>

web.php

<?php
Route::get('contact-us', function () {
    return view('contact-us');
});
Route::post('enq','UserController@enq');

I am new in laravel Here what am I doing I am going to insert a simple form value into database. Now, what happen when I click on submit button it show nothing. I have no idea about that. So, How can I do this? Please help me.

Thank You

press F12 on keyboard, if using chrome, inspect tool will open. Go to Network tab. click on XHR sub tab. You will see your enq url call and now debug. If still ain't see anything then, in .env file APP_DEBUG set this to true. Don't forget to fire terminal command, php artisan config:cache to reflect config changes throughout the project. — Rahul
– Rahul, Commented May 7, 2019 at 10:42
I have already check as per your instruction but unable to insert form value what happen with my code @RahulMeshram — steave
– steave, Commented May 7, 2019 at 10:48
Where are you stuck? Your ajax call working fine? If Yes, do you get data in enq method()? — Rahul
– Rahul, Commented May 7, 2019 at 10:49

Yegor Keller · Accepted Answer · 2019-05-07 10:49:24Z

1

Change your enq function

public function enq(Request $request)
       {
           $name  = $request->name;
           $phone = $request->phone;
           $email = $request->email;
           $msg   = $request->msg;
           $data=array('name'=>$name,"phone"=>$phone,"email"=>$email,"msg"=>$msg);
           DB::table('enquiry')->insert($data);
           echo "Record inserted successfully";
       }

And also configure CSRF token

add <meta name="_token" content="{!! csrf_token() !!}"/> in your head section

and then

 $.ajaxSetup({
        headers:
            {'X-CSRF-TOKEN': $('meta[name="_token"]').attr('content')}
    });

Add this code before your ajax call

answered May 7, 2019 at 10:49

Yegor Keller

415 bronze badges

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

Comments

akhil · Accepted Answer · 2019-05-07 11:10:15Z

0

Add an additional data, token in ajax request.

    $.ajax({
        type:"POST",
        data:{"name":name,"phone":phone,"email":email,"msg":msg,"_token":"{{csrf_token()}}"},
        url:"{{URL::to('enq')}}",
        success:function(data){
            $("#success").html(data);
        }
    });

To check for errors, you can press F12 in keyboard and see the console. Error are showed in red color and if the error code is 500, then its related to php

edited May 7, 2019 at 11:10

answered May 7, 2019 at 11:03

akhil

1067 bronze badges

2 Comments

steave Over a year ago

Failed to load resource: the server responded with a status of 404 (Not Found) i.e. /enq

akhil Over a year ago

change url:"/enq" to url:"{{URL::to('enq')}}"

Collectives™ on Stack Overflow

How to insert form values into database via jquery ajax using laravel?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related