SuperMonkey

chat php

Jun 23rd, 2013
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.43 KB | None | 0 0
  1. <?php
  2.  
  3. session_start();
  4.  
  5. $_SESSION["latest_view_id"] = (isset($_SESSION["latest_view_id"])) ? $_SESSION["latest_view_id"] : 0;
  6.  
  7. $db = new PDO("mysql:host=localhost;dbname=pokemon-trash", "root", "");
  8.  
  9. $req = $db->query("SELECT * FROM messages_chat WHERE id > ".$_SESSION["latest_view_id"]);
  10. while($msg = $req->fetch()) {
  11.     //// affichage des messages
  12.    
  13.     $_SESSION["latest_view_id"] = $msg["id"];
  14. }
  15. $req->closeCursor();
  16.  
  17. ?>
Advertisement
Add Comment
Please, Sign In to add comment