从 PHP (jQuery/AJAX) 插入 MySQL [英] Inserting into MySQL from PHP (jQuery/AJAX)
问题描述
我看过很多教程，但它们太令人困惑了，为了做我想做的事，我只是不知道如何使用这些教程中的现有内容并让它们按照我希望的方式工作.
I have seen many tutorials, but they're so confusing, and to do what I want to do, I just don't get how to use existing stuff from those tutorials and make them work they way I want them to.
我有一个非常简单的表单，包含一个文本框、标签和一个提交按钮.当用户在表单中输入内容，然后点击提交时，我想使用php和ajax(使用jquery)将表单的结果插入到mysql数据库中.
I have a very simple form, containing a textbox, label and a submit button. When the user enters something into the form, then clicks submit, I would like to use php and ajax (with jquery) to insert the result of the form into a mysql database.
有人可以告诉我这是如何实现的吗?我所追求的只是一些非常基本的东西，让我开始.任何帮助表示赞赏.
Can someone please show me how this can be achieved? Just something very basic is all i'm after to get me started. Any help is appreciated.
谢谢
推荐答案
您好，这里只是一个简单的示例:
Hi here is just a quick example of how one might do it:
HTML:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Quick JQuery Ajax Request</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!-- include the jquery lib -->
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
var ajaxSubmit = function(formEl) {
// fetch where we want to submit the form to
var url = $(formEl).attr('action');
// fetch the data for the form
var data = $(formEl).serializeArray();
// setup the ajax request
$.ajax({
url: url,
data: data,
dataType: 'json',
success: function() {
if(rsp.success) {
alert('form has been posted successfully');
}
}
});
// return false so the form does not actually
// submit to the page
return false;
}
</script>
</head>
<body>
<form method="post" action="process.php"
onSubmit="return ajaxSubmit(this);">
Value: <input type="text" name="my_value" />
<input type="submit" name="form_submit" value="Go" />
</form>
</body>
</html>
process.php 脚本:
The process.php script:
<?php
function post($key) {
if (isset($_POST[$key]))
return $_POST[$key];
return false;
}
// setup the database connect
$cxn = mysql_connect('localhost', 'username_goes_here', 'password_goes_here');
if (!$cxn)
exit;
mysql_select_db('your_database_name', $cxn);
// check if we can get hold of the form field
if (!post('my_value'))
exit;
// let make sure we escape the data
$val = mysql_real_escape_string(post('my_value'), $cxn);
// lets setup our insert query
$sql = sprintf("INSERT INTO %s (column_name_goes_here) VALUES '%s';",
'table_name_goes_here',
$val
);
// lets run our query
$result = mysql_query($sql, $cxn);
// setup our response "object"
$resp = new stdClass();
$resp->success = false;
if($result) {
$resp->success = true;
}
print json_encode($resp);
?>
请注意，这些都没有经过测试.希望对你有帮助.
Please note that none of this has been tested. I hope it helps you thou.
这篇关于从 PHP (jQuery/AJAX) 插入 MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
