这是我的html / ajax / jquery和php文件。我必须在数据库中插入数据
但是数据没有插入我的数据库中
<html>
<head>
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js</script>
<script>
function add() {
$("#register-form").validate({
rules: {
name: "required",
email: {
required: true,
email: true
},
Budget: {
required: true,
},
phone: "required",
budget: "required",
},
messages: {
name: "Please enter your Name",
email: "Please enter a valid Email address",
phone: "Please enter a valid Phone Number",
Budget: "Please Select a Budget",
},
submitHandler: function (form) {
//alert("success")
$.ajax({
url: "insert2.php",
type: "POST",
success: function (response) {
alert("Data Save: " + response)
}
});
}
});
}
</script>
</head>
<body>
<form action="" method="post" id="register-form" >
<div class="label">Name</div><input type="text" id="name" name="name" /><br />
<div class="label">Email</div><input type="text" id="email" name="email" /><br />
<div class="label">Phone Number</div><input type="text" id="phone" name="phone" /><br />
<div class="label">budget</div>
<select id="Budget" name="Budget">
<option value="">select</option>
<option value="1">0-100</option> <!-- first option contains value="" -->
<option value="2">100-200</option>
<option value="3">200-300</option>
</select>
<br />
<div style="margin-left:140px;">
<input type="submit" onclick="add()" name="submit" /></div>
</form>
</body>
这是我的html / ajax / jquery和php文件。我必须在数据库中插入数据
但是数据没有插入我的数据库中。
<?php
$con=mysqli_connect("xxxxxxxx","xxx","xx","xx");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="INSERT INTO form (name, email, phone)
VALUES
('$_POST[name]','$_POST[email]','$_POST[phone]')";
if (!mysqli_query($con,$sql))
{
die('Error: ' . mysqli_error($con));
}
echo "1 record added";
mysqli_close($con);
?>
最佳答案
通过使用此传递表单数据
data:$('#register-form').serialize(),
试试这个代码
$.ajax({
url: "insert2.php",
type: "POST",
data: $('#register-form').serialize(),
success: function (response) {
alert("Data Save: " + response)
}
});
关于php - 使用ajax和php在MYSQL中插入数据，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/21829246/