AJAX POST到PHP脚本

Question

I'm trying to POST from my program to a separate PHP file, then grab that data and store it into my SQL database. I've checked my code over and over and can't' find what I'm doing wrong. Any help would be appreciated.

AJAX

$(".btn btn-success last").click(function(){
        $.post("go2.php",
        {
             name: "Donald Duck",
             city: "Duckburg"
        },
        function(data, status){
             alert("Data: " + data + "
Status: " + status);
            });
    });

---

PHP file (go2.php) w/ SQL code

    <?php

include 'connection.php';

$x = $_POST["name"];
$sql = "INSERT INTO users (Username) VALUES ('$x') ";
$query = mysql_query($sql);



?>

Answer 1

Try the long version of ajax request

$(document).ready( function () { 
        $(".btn btn-success last").click(function(){                        
            $.ajax({ 
               type: "POST",
               url: "go2.php", 
               data: {name:"Donald Duck", city:"Duckburg"},
               success: function(data){
                    document.getElementById('divId').html(data);
               }
            });
        });
    });

For the echo data, you have to echo a message in your go2.php like "Success"