coderboy

ChatApp - backend

May 20th, 2016
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.96 KB | None | 0 0
  1. <?php
  2. #define server variable / login info
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "1234";
  6. $dbname = "apps";
  7.  
  8. #get variables
  9. $user = $_GET["user"];
  10. $message = $_GET["msg"];
  11.  
  12. #connect to database
  13. $conn = new mysqli($servername, $username, $password, $dbname);
  14. if ($conn->connect_error) {
  15.     die("Connection failed: " . $conn->connect_error);
  16. }
  17. #listen and reply to client requests
  18. $mode = $_GET["mode"];
  19. if ($mode == "send") {
  20.     $sql = "INSERT INTO chat (user, message)
  21. VALUES ('$user', '$message')";
  22. if ($conn->query($sql) === TRUE) {
  23. } else {
  24.     echo "Error: " . $sql . "<br>" . $conn->error;
  25. }
  26. }
  27. if ($mode == "get") {
  28. $sql = "SELECT timestamp, user, message FROM chat";
  29. $result = $conn->query($sql);
  30. if ($result->num_rows > 0) {
  31.     while($row = $result->fetch_assoc()) {
  32.         echo "[" . $row["user"] . "] " . $row["message"];    
  33.     }
  34.     } else {
  35.         echo "[Server] Be the first to make a message!";
  36.     }
  37. }
  38. $conn->close();
  39. ?>
Add Comment
Please, Sign In to add comment