| commit | author | age | ||
| a13080 | 1 | <?php |
| F | 2 | namespace App\Models; |
| 3 | ||
| 4 | use PDO; | |
| 5 | use Framework\Model; | |
| 6 | class Contact extends Model { | |
| 7 | //protected ?string $table = "product"; | |
| 8 | ||
| 9 | public function controlloSpamEmail(string $email, ): bool { | |
| 10 | $spam = false; | |
| 11 | $query = "SELECT email, dtm_richiesta FROM Contact WHERE email = '$email' AND dtm_richiesta BETWEEN DATE_SUB(NOW(), INTERVAL 1 DAY) AND NOW();"; | |
| 12 | $connection = $this->database->getConnection(); | |
| 13 | ||
| 14 | $result = $connection->query($query); | |
| 15 | ||
| 16 | $rowcount = count($result->fetchAll(PDO::FETCH_ASSOC)); | |
| 17 | var_dump($rowcount); | |
| 18 | ||
| 19 | ||
| 20 | if ($rowcount > 0) { | |
| 21 | $spam = true; | |
| 22 | } | |
| 23 | ||
| 24 | return $spam; | |
| 25 | } | |
| 26 | protected function validate(array $data): void { | |
| 27 | ||
| 28 | if(empty($data["email"])) { | |
| 29 | $this->addError("email","email is required"); | |
| 30 | } | |
| 31 | if(empty($data["telefono"])) { | |
| 32 | $this->addError("telefono","cell number is required"); | |
| 33 | } | |
| 34 | if($this->controlloSpamEmail($data["email"])) { | |
| 35 | $this->addError("spam", "non puoi mandare la stessa mail, aspetta un pò di tempo"); | |
| 36 | } | |
| 37 | } | |
| 38 | ||
| 39 | ||
| 40 | ||
| 41 | } | |
