嗨,我正在尝试创建一个小的电子邮件订阅者脚本,以将电子邮件地址添加到我的数据库中。我可以使用不推荐使用的功能(例如mysql_connect)使它正常工作,但改用mysqli使其更好。但是由于某种原因,我不再能够将电子邮件地址插入数据库,但可以正常连接到数据库并检查电子邮件地址是否不存在。我想知道为什么我的INSERT似乎不起作用。我对PHP没有太多经验,谢谢。
if (!$link) {
echo "save_failed cannot connect"; //if cant connect show error
return;
}
mysqli_select_db($link,$mydb);
// Clean variables before performing insert
$clean_email = mysqli_real_escape_string($link,$_POST['email']);
$clean_subscriber = mysqli_real_escape_string($link,$_POST['firstname']);
$clean_date = mysqli_real_escape_string($link,$_POST['date']);
$query = "SELECT * FROM EmailList WHERE email = '{$email}'";//check if already in list
$result = mysqli_query($link,$query);
$row_cnt = mysqli_num_rows($result);
if($row_cnt == 0) {
// Perform insert if not in list
$sql = "INSERT INTO EmailList (Email,Name,Date) VALUES
('$clean_email','$clean_subscriber','$clean_date')";
echo "Thank you for Subscribing to my blog!";
} else {
echo "You have subscribed already. Thank you for subscribing";
}
最佳答案
看起来您缺少运行查询的行:
mysqli_query($link,$sql);