php - 向 MYSQL 添加变量

Question

我需要将“seatid”添加到mysql数据库...“seatid”变量在另一个函数中检索...换句话说，我需要向mysql添加一个在表单中找不到但找到的变量在另一个函数中

 $("#reserveid").click(function()
{
    addSeat();

});

function addSeat()
{
var t_name    = $("#btnShowNew ['seatid']").val(); //btnShowNew is the id of the form that output the seatid variable
var errors  = '';

$.ajax({
    type    : "POST",
    url     : "INSERT.php",
    data    : { seatid  : t_name,
       },
    cache   : false, timeout: 10000,

    success  : function() {
        alert("WORKED!");
    },
    error    : function() {
        alert("DIDN'T WORK!");
    },
    complete : function() {
    }
});
}

php 文件:

<?php

$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="seat"; // Table name 

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$seatid = mysql_real_escape_string($_POST['seatid']);
$error = '';

$query = "INSERT INTO seat ( seatNo ) VALUES ('{$seatid}')";

if (!mysql_query($query, $conn))
{
$error = mysql_error();
$return['error'] = $error;
echo json_encode($return);
mysql_close($conn);
}
else
{
$success = "Seat Successfully Added!";
$return['mysql'] = $success;
echo json_encode($return);
mysql_close($conn);
} 

？>

Answer 1

有些浏览器不理解这一点

data : { 
  seatid  : t_name,
},

尝试

data : {
  seatid  : t_name
},

删除多余的逗号。

像这样使用php

<?php

$return['error'] = $error;
echo json_encode($return);

?>

也在js中写下这个，看看会得到什么。

complete : function(data) {
     alert('complete');
}