getChatHistory.php 690 B

1234567891011121314151617181920212223242526
  1. <?php
  2. session_start();
  3. include_once("requestDB.php");
  4. if(isset($_POST['message']))
  5. {
  6. $sql = "INSERT INTO `chat` (`fromuser`, `touser`, `content`, `sendtime`)
  7. VALUES ( '"
  8. .$_POST['fromuser']."','"
  9. .$_POST['touser']."','"
  10. .$_POST['message']
  11. . "',CURRENT_TIMESTAMP)";
  12. queryw($sql, "teabag");
  13. }
  14. $chatsql = "select * from chat where
  15. (touser='" . $_POST['fromuser'] . "' and fromuser='".$_POST['touser']."') or
  16. (touser='" . $_POST['touser'] . "' and fromuser='".$_POST['fromuser']."') ORDER BY sendtime";
  17. $chatdata = query($chatsql,"teabag");
  18. foreach ($chatdata as $chat){
  19. echo '<a>'.$chat['fromuser']."(".$chat['sendtime']."):</a><br/>".$chat['content']."<br/>";
  20. }
  21. ?>