note 65425 deleted from function.time by bjori

From: Date: Sun, 30 Apr 2006 17:38:30 +0000
Subject: note 65425 deleted from function.time by bjori
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-110204@lists.php.net to get a copy of this message
Note Submitter: zerog2006 at hotmail dot com Reason: non-english ---- *Voici un exemple de l'utilisation de time(). *Je mee sert de ce code pour afficher les utilisateurs en ligne. $now = date('Y-m-j H:i:s'); $timel = time($now)-600; //maintenant - 10 minutes // on efface ceux donc le temp de champ time < $timel $query = "DELETE FROM table WHERE TIME(champdatetime) < '$timel'";; $result = mysqli_query($this->conn,$query); // on selectionne ceux qui on un TIME(champdatetime) > que $timel $query = "SELECT * FROM table WHERE TIME(champdatetime) > '$timel' AND lacondition ='vrai'"; $result = mysqli_query($this->conn,$query); $num_result = mysqli_num_rows($result); // on affiche le nombre de resulta donc les cahmp ou TIME(champdatetime) n'est pas plus vieux que $ltime. echo " ".$num_result." le nombre de résulta<br />";

« previous php.notes (#110204) next »