使用php中的ajax将数据插入mysql数据库

问题描述：

I am trying to insert value using ajax in php, but data is not inserted in database. I have taken this code from the questions answered in other question from this site. Can anyone suggest where am I making mistake..?

<script>
  $("#submit").click(function() {
                var name= $("#name").val();
                var password= $("#password").val();

                $.ajax({
                    type: "POST",
                    url: "insert.php",
                    data: "name=" + name+ "&password=" + password,
                    success: function(data) {
                       alert("sucess");
                    }
                });


            });

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.0/jquery.min.js"></script>

<?php
    //------insert.php------
     $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "dbname";

    // Create connection
    $conn = new mysqli($servername, $username, $password,$dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 


          $name=$_POST['name'];
            $pass=$_POST['password'];
             $sql= mysqli_query($conn,"INSERT INTO insert_tbl(name,pass) VALUES('".$name."','".$pass."')");

 ?>

我试图在php中使用ajax插入值，但数据未插入数据库中。我从本网站的其他问题中回答了这些代码。任何人都可以建议我在哪里犯错..？ p>

 ＆lt; script＆gt; 
 $（“＃submit”）。click（function（）{
 var name =  $（“＃name”）。val（）; 
 var password = $（“＃password”）。val（）; 
 
 $ .ajax（{
 type：“POST”，
 url：  “insert.php”，
 data：“name =”+ name +“＆amp; password =”+ password，
 success：function（data）{
 alert（“sucess”）; 
} 
}）  ; 
 
 
}）; 
 
＆lt; script src =“https://ajax.googleapis.com/ajax/libs/jquery/1.10.0/jquery.min.js”＆gt;＆lt; / 脚本＆gt; 
 
＆lt;？php 
 //------insert.php------ 
 $ servername =“localhost”; 
 $ username =“username”; 
 $ password  =“password”; 
 $ dbname =“dbname”; 
 
 //创建连接
 $ conn = new mysqli（$ servername，$ username，$ password，$ dbname）; 
 
 //检查 connection 
 if（$ conn-＆gt; connect_error）{
 die（“Connection failed：”。  $ conn-＆gt; connect_error）; 
} 
 
 
 $ name = $ _ POST ['name']; 
 $ pass = $ _ POST ['password']; 
 $ sql = mysqli_query（$ conn  ，“INSERT INTO insert_tbl（name，pass）VALUES（'”。$ name。“'，'”。$ pass。“'）”）; 
 
？＆gt; 
  code>  pre>  
  div>

答

<script>
  $("#FORM_ID").submit(function() {
                var name= $("#name").val();
                var password= $("#password").val();

                $.ajax({
                    type: "POST",
                    url: "insert.php",
                    data: "name=" + name+ "&password=" + password,
                    success: function(data) {
                       alert("sucess");
                    }
                });


            });
</script>

and also either load

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.10.0/jquery.min.js"></script>

before your script tag or use

 <script>
$(document).ready(function(){
      $("#FORM_ID").submit(function() {
                    var name= $("#name").val();
                    var password= $("#password").val();

                    $.ajax({
                        type: "POST",
                        url: "insert.php",
                        data: "name=" + name+ "&password=" + password,
                        success: function(data) {
                           alert("sucess");
                        }
                    });


                });
        });
    </script>

答

This is html form for insert data

<form id="frmrecord" method="post">
    <input type="text" name="txtusermame" />
    <input type="password" name="txtpassword" />
    <input type="submit" value="Insert" />
</form>

Use this code for call insert.php file to insert data

jQuery(document).ready(function ($) {

    $("#frmrecord").submit(function (event) {
                event.preventDefault();
                //validation for login form
        $("#progress").html('Inserting <i class="fa fa-spinner fa-spin" aria-hidden="true"></i></span>');

            var formData = new FormData($(this)[0]);
            $.ajax({
                url: 'insert.php',
                type: 'POST',
                data: formData,
                async: true,
                cache: false,
                contentType: false,
                processData: false,
                success: function (returndata) 
                {
                    //show return answer
                    alert(returndata);
                },
                error: function(){
                alert("error in ajax form submission");
                                    }
        });
        return false;
    });
});

After calling file you can receive data in php file Insert.php

<?php 
  $usernmae=$_POST['txtusername']; 
  $password=$_POST['password']; 
  $sql= mysqli_query($conn,"INSERT INTO insert_tbl(name,pass) 
    VALUES('".$usernmae."','".$password."')");
 ?>

Download Demo

使用php中的ajax将数据插入mysql数据库

相关推荐