File manager - Edit - /home/custbahd/irungikitchen.com/admin/chat/chat_unread/index.php
Back
<?php session_start(); if(isset($_SESSION['user_id'])){ include_once "../../db/config.php"; include_once('../../db/count_db.php'); $outgoing_id = $_SESSION['user_id']; $incoming_id = mysqli_real_escape_string($conn, $_POST['incoming_id']); $output = ""; $sql = "SELECT count(*) FROM messages WHERE sender_id = '$incoming_id' AND user_id = '$outgoing_id' AND incoming_msg_unread = '1'"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { $count = $row['count(*)']; if ($count=='0') { $count_unread = ''; } elseif ($count=='1') { $count_unread = '<p class="fs-12 text-secondary mt-2 mb-n2 text-center">'.$count.' unread message</p>'; } else { $count_unread = '<p class="fs-12 text-secondary mt-2 mb-n2 text-center">'.$count.' unread messages</p>'; } } $output .= ''.$count_unread.''; echo $output; } ?> <?php ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.89 |
proxy
|
phpinfo
|
Settings