php 邮件 存入数据库,php - 如何将电子邮件输入mysql数据库 - SO中文参考 - www.soinside.com...

所以我试图存储来自Gmail的电子邮件，我已经连接了一切，我设法将所有的电子邮件内容存储到数据库中，但现在我有问题，每次刷新页面时，相同的电子邮件都存储在数据库中。

$bodyText = imap_fetchbody($inbox,$email_number,1.2);

if(!strlen($bodyText)>0){

$bodyText = imap_fetchbody($inbox,$email_number,1);

}

$subject = imap_headerinfo($inbox,$email_number);

$subject = $subject->subject;

$stripped = str_replace('*', '
', $bodyText);

$sql = "SELECT id, subject, body FROM emails";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while($row = $result->fetch_assoc()) {

$email_subject = $row['subject'];

if ($subject == $email_subject) {

echo "Email already in database";

}else{

$sql = "INSERT INTO emails (subject, body)

VALUES ('".$subject."', '".$stripped."')";

if ($conn->query($sql) === TRUE) {

echo "New record created successfully";

} else {

echo "Error: " . $sql . "
" . $conn->error;

}

}

}

} else {

echo "0 results";

}

所以我尝试使用它

if ($subject == $email_subject) {

echo "Email already in database";

}else{

$sql = "INSERT INTO emails (subject, body)

VALUES ('".$subject."', '".$stripped."')";

if ($conn->query($sql) === TRUE) {

echo "New record created successfully";

} else {

echo "Error: " . $sql . "
" . $conn->error;

}

}

用于检查数据库中是否存在具有相同主题的电子邮件，如果有，则显示“已在数据库中的电子邮件”，如果没有显示“已成功创建新记录”

把东西放错了，我一直在数据库中收到相同的电子邮件，所以每次我重新打开我的电子邮件的整个收件箱进入数据库