get_chats.php

<?php

include('../../includes/config.php');

if(isset($_POST['message']))

{

$user_id = $_POST['user_id'];
    $message = mysqli_real_escape_string($conn,$_POST['message']);
    
    date_default_timezone_set('Asia/Kolkata');
    $created_date = date('d-m-Y');
    
    $insert = "INSERT INTO iv_chats(iv_user_id,iv_message,created_date) VALUES('$user_id','$message','$created_date')";
    $sql = mysqli_query($conn,$insert);
    
   
		 $query = mysqli_query($conn,"SELECT * FROM iv_chats ORDER BY iv_chat_id ASC");
              while($row = mysqli_fetch_assoc($query))
              {
                  $chat_user_id = $row['iv_user_id'];
                  $query1 = mysqli_query($conn,"SELECT * FROM iv_mem_details WHERE iv_mem_details_id='$chat_user_id'");
                  $row1 = mysqli_fetch_assoc($query1);
                  $username = $row1['iv_mem_username'];
                  $image = $row1['iv_mem_thump_photo'];
                  $message = $row['iv_message'];

?>
            <?php
                if($user_id!=$chat_user_id)
                {
                ?>

<div class="d-flex flex-column p-3" id="chats">
                         <div>
                           <?php
                             if($image!='')
                             {
                             ?>
                            <img src="../assets/images/members/thump_images/<?php echo $image; ?>" width="30" height="30">
                            <?php } else { ?>
                            <img alt="induvedam tump.image" src="../assets/images/home/thump.png" height="70px">
                            <?php } ?>
                            <span><?php echo $username; ?></span>
                         </div>
                        <div class="chat ml-2 p-3"><?php echo $message; ?></div>
                      </div>
         <?php } else { ?>
              <div class="d-flex flex-column align-items-end p-3">
                 <div>
                    <span><?php echo $username; ?></span>
                    <?php
                     if($image!='')
                     {
                     ?>
                    <img src="../assets/images/members/thump_images/<?php echo $image; ?>" width="30" height="30">
                    <?php } else { ?>
                    <img alt="induvedam tump.image" src="../assets/images/home/thump.png" height="70px">
                    <?php } ?>
                 </div>
                <div class="chat2 mr-2 p-3"><span class=""><?php echo $message; ?></span></div>
              </div>

<?php
         }

}

docroot: /home/induvedam/public_html

curdir: /home/induvedam/public_html/ajax/chats

	.	27
	..	142
X	get_chats.php	2640