$(function() {
$('#subscribe-form').submit(function(e) {
e.preventDefault();
$.ajax({
type: 'POST',
url: 'subscribe.php',
data: $(this).serialize(),
success: function(data) {
if (data === 'subscribed') {
alert('Subscribe successful!');
} else if (data === 'already_subscribed') {
alert('You have already subscribed!');
} else {
alert('Subscribe failed. Please try again later.');
}
},
error: function() {
alert('Subscribe failed. Please try again later.');
}
});
});
});
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// check if email already exists in database
$stmt = $conn->prepare('SELECT COUNT(*) FROM emails WHERE email = :email');
$stmt->bindParam(':email', $email);
$stmt->execute();
$result = $stmt->fetchColumn();
if ($result == 0) {
// insert new email into
下一篇:Ajax和REST的区别