ajax提交到mysql_从PHP插入到MySQL(jQuery / AJAX)

嗨,这里只是一个简单的例子：

HTML：

Quick JQuery Ajax Request

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;

}

onSubmit="return ajaxSubmit(this);">

Value:

process.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);

?>

请注意,这些都没有被测试.我希望它能帮助你.