gpt4 book ai didi

javascript - HTML5 Ajax JQuery PHP MySQL 插入

转载 作者:行者123 更新时间:2023-11-29 08:06:05 24 4
gpt4 key购买 nike

谁能告诉我,为什么我在按下提交按钮后仍然被重定向到 insertInput.php。我尝试了一些方法,但没有成功,比如将类型从“提交”更改为“按钮”等等。

HTML:

<!DOCTYPE html>
<html>
<head>
<title>Barocker's Song Voting</title>
<link href="vote.css" type="text/css" rel="stylesheet">
<script src="jquery-1.11.0.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#insert").click(function(){
var url = "insertInput.php";
var data = $("#form :input").serializeArray();
alert("Button clicked");
$.post(
url,
data,
function(info){
$("#result").html(info);
}
);
clearInput();
});
function clearInput(){
$("#form :input").each(function(){
$(this).val("");
});
}
});
</script>
</head>
<body>
<div id="insertBanner">
<form id="form" action="javascript:void(0);" method="post">
<input type="text" id="title" name="title" style="width: 300px;" placeholder="Titel" autofocus required>
<input type="url" id="url" name="url" style="width: 300px;" placeholder="Link (Youtube, etc.)">
<button id="insert">Hinzufügen</button>
</form>
<span id="result"></span>
</div>

</body>
</html>
PHP:

    /*
* Connect to MySQL
*/

$con = mysqli_connect("localhost", "@", "", "test");

/*
* Check Connection
*/

if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$title = $_POST['title'];
$url = $_POST['url'];
$sql = "INSERT INTO barocker (title, url) VALUES ('" . $title . "', '" . $url . "')";

if (!mysqli_query($con,$sql)){
echo "Error";
} else {
echo "Success";
}

/*
* Close Connection
*/

mysqli_close($con);

?>

谢谢你们。一如既往地非常感谢任何帮助。

最佳答案

据我了解,您需要#insert click禁用

$("#insert").click(function(){
return false;
});

关于javascript - HTML5 Ajax JQuery PHP MySQL 插入,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/22716982/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com