Guest User

Untitled

a guest
Dec 2nd, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. <?php
  2. $db_host = "localhost";
  3. $db_user = "root";
  4. $db_pass = "";
  5. $db_name = "chat";
  6.  
  7. if($connection = mysqli_connect($db_host, $db_user, $db_pass)){
  8. echo ("connected to server");
  9. if($database = mysqli_select_db( $connection, $db_name )){
  10. echo "connected to database";
  11. }else{
  12. echo "dtabase error";
  13. }
  14. }else{
  15. echo "sever error";
  16. }
  17. ?>
  18.  
  19. <?php
  20. require('../database/connect.db.php');
  21.  
  22. function get_msg(){
  23. $query = "SELECT Sender,Message from chat";
  24.  
  25. **$run = mysqli_query($query);**
  26.  
  27. $messages = array();
  28.  
  29. while($message = mysqli_fetch_assoc($run)){
  30. $messages[] = array('sender'=>$message['Sender'],'message'=>$message['Message']);
  31. }
  32.  
  33. return $messages;
  34. }
  35.  
  36. function send_msg($sender,$message){
  37. if(!empty($sender) && !empty($message)){
  38. $sender = mysqli_real_escape_string($sender);
  39. $message = mysqli_real_escape_string($message);
  40.  
  41. $query = "INSERT INTO chat VALUES({$sender},{$message})";
  42.  
  43. if(mysqli_query($query)){
  44. return true;
  45. }else{
  46. return false;
  47. }
  48. }else{
  49. return false;
  50. }
  51. }
  52.  
  53. ?>
Add Comment
Please, Sign In to add comment