Modifica query e prova stampa

filippo.bertilotti

2024-05-02 bf43e62c1961fefa61430b150ec3c3df45e9a530

Modifica query e prova stampa

 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";}