From bf43e62c1961fefa61430b150ec3c3df45e9a530 Mon Sep 17 00:00:00 2001
From: filippo.bertilotti <filippobertilotti@gmail.com>
Date: Thu, 02 May 2024 12:54:33 +0200
Subject: [PATCH] Modifica query e prova stampa
---
htdocs/contact.php | 14 ++++++++++++--
1 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/htdocs/contact.php b/htdocs/contact.php
index 0c0a7bd..dbfb973 100644
--- a/htdocs/contact.php
+++ b/htdocs/contact.php
@@ -47,14 +47,24 @@
function controlloSpamEmail(mysqli $connection, string $email) {
$esitoSpamEmail = false;
- $query = "SELECT email, dtm_richiesta FROM Contact WHERE email = '$email' AND dtm_richiesta BETWEEN CURDATE() AND DATE_SUB(CURDATE(), INTERVAL 1 DAY);";
+ $query = "SELECT email, dtm_richiesta FROM Contact WHERE email = '$email' AND dtm_richiesta BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) AND NOW();";
-
+
$result = $connection->query($query);
while ($row = $result->fetch_assoc()) {
echo $row['email']."<br />\n";
+ echo $row['dtm_richiesta']."<br />\n";
}
+
+
+ while ($row = $result->fetch_assoc()) {
+ if(count($row['email']) > 0) {
+ $esitoSpamEmail = true;
+ }
+ }
+
+ if($esitoSpamEmail == true) {echo "email spammata";}
--
Gitblit v1.8.0