Training Institute in Noida | Delhi NCR No.❶ Digital Marketing Training Institute in Noida | Delhi NCR
img

Using AJAX to Insert Data in Database -PHP Training Institute

Using AJAX  to Insert Data in Database
PHP

Using AJAX to Insert Data in Database

   <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<form method="post">
<input id="name" type="text" name="name">
<select id="class" name="class">
<option>
<option value="10">10</option>
<option value="12">12</option>
</select>
</form>
<script>
            $(document).ready(function(){
 
                $("#class").change(function(){
                    var name=$("#name").val();
                    var standard=$("#class").val();
                    $.ajax({
                        url:'add.php',
                        method:'POST',
                        data:{
                            name:name,
                            class:standard,
                        },
                        success:function(response){
                            alert(response);
                        }
                    });
                });
            });
        </script>
<?php
$conn = new mysqli('localhost', 'root', '', 'ajax');
$name=$_POST["name"];
$class=$_POST["class"];
$sql="INSERT INTO users (name,class) VALUES ('$name','$class')";
if($conn->query($sql)===TRUE){
    echo "DATA updated";
}
?>

Let's Update Your Skills with Our Training Professionals...

It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.