Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host = "localhost";
- $db_user = "root";
- $db_pass = "";
- $db_name = "chat";
- if($connection = mysqli_connect($db_host, $db_user, $db_pass)){
- echo ("connected to server");
- if($database = mysqli_select_db( $connection, $db_name )){
- echo "connected to database";
- }else{
- echo "dtabase error";
- }
- }else{
- echo "sever error";
- }
- ?>
- <?php
- require('../database/connect.db.php');
- function get_msg(){
- $query = "SELECT Sender,Message from chat";
- **$run = mysqli_query($query);**
- $messages = array();
- while($message = mysqli_fetch_assoc($run)){
- $messages[] = array('sender'=>$message['Sender'],'message'=>$message['Message']);
- }
- return $messages;
- }
- function send_msg($sender,$message){
- if(!empty($sender) && !empty($message)){
- $sender = mysqli_real_escape_string($sender);
- $message = mysqli_real_escape_string($message);
- $query = "INSERT INTO chat VALUES({$sender},{$message})";
- if(mysqli_query($query)){
- return true;
- }else{
- return false;
- }
- }else{
- return false;
- }
- }
- ?>
Add Comment
Please, Sign In to add comment