$(document).ready(function(){ $("form").submit(function(event){ //阻止表单的默认行为 event.preventDefault(); //获取表单数据 var formData = { 'name' : $('input[name=name]').val(), 'value' : $('input[name=value]').val() };
//发送Ajax请求
$.ajax({
type: "POST",
url: "insert.php",
data: formData,
dataType: 'json',
encode: true,
success: function(result) {
console.log(result);
}
});
});
});
$conn = new mysqli($servername, $username, $password, $dbname);
//检查连接是否成功
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
//获取表单数据并插入数据库
$name = $_POST['name'];
$value = $_POST['value'];
//设置限制条件:插入到数据库的名称必须是MyName,值必须大于0
if($name == "MyName" && $value >