File manager - Edit - /home/missmand/public_html/admin/script/cron/notificationCommentaireProjet.php
Back
<?php include '../../lib/init.php'; /* La liste des projets */ $sql = $bdd->query("SELECT * FROM projet WHERE projetEtat = 1 AND projetEmail IS NOT NULL "); while($data = $sql->fetchObject()){ $projetId = $data->projetId; /* Retourne la liste des commentaires pour chaque projet de la derniére semaine */ $sql2 = $bdd->query("SELECT * FROM commentaire WHERE commentaireParent = $projetId AND commentaireType = 'projet' AND commentaireEtat = 1 AND DATE(commentaireCreated) BETWEEN DATE_ADD(CURDATE(), INTERVAL -7 DAY) AND CURDATE()"); /* Si au moins 1 commentaire alors notification */ if($sql2->rowCount() != 0){ /** * Notitication * Info actualite * Info commentaire * Contenu notification */ } } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings