File manager - Edit - /home/custbahd/irungikitchen.com/admin/chat/search.php
Back
<?php session_start(); include_once "../db/config.php"; $outgoing_id = $_SESSION['user_id']; $searchTerm = mysqli_real_escape_string($conn, $_POST['searchTerm']); $sql = mysqli_query($conn, "SELECT * FROM message_board WHERE sender_id != '$outgoing_id'"); if(mysqli_num_rows($sql) > 0){ $row = mysqli_fetch_assoc($sql); $msg = $row['user_message']; if ($row['incoming_msg_unread'] == '') { $msg_unread_count = ''; } else { $msg_unread_count = '<div class="count" style="position: absolute;color: white;margin-top: 8px;right: 50px;font-size: 8px;padding: 1px 4px;border-radius: 3.5rem;width: 12px;height:12px;background: rgba(254, 32, 2, 0.8);">'.$incoming_msg_unread.'</div>'; } if ($outgoing_id = $_SESSION['user_id']) { $you = 'You: '; } else { $you = ''; } } $sql = "SELECT * FROM users WHERE NOT user_id = '$outgoing_id' AND (user_name LIKE '%$searchTerm%') "; $output = ""; $query = mysqli_query($conn, $sql); if(mysqli_num_rows($query) > 0){ while($row = mysqli_fetch_assoc($query)){ if ($row['status'] == 'Online') { $status = 'nline'; $status_icon = '<span class="online_icon"></span>'; $offline = ''; } elseif ($row['status'] == 'Offline') { $status = 'ffline'; $status_icon = '<span class="online_icon offline"></span>'; $offline = 'offline'; } if ($row['user_image'] == '') { $user_image = '<svg id="icon-user1" xmlns="http://www.w3.org/2000/svg" class="text-primary ml-2" width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M20 21v-2a4 4 0 0 0-4-4H8a4 4 0 0 0-4 4v2"></path><circle cx="12" cy="7" r="4"></circle></svg>'; } else { if ($row['user_id'] == $outgoing_id) { $user_image = '<img src="'.$row['sender_image'] .'" alt="'.$row['sender_name'].'" class="rounded-circle user_img">'; } else { $user_image = '<img src="'.$row['user_image'] .'" alt="'.$row['user_name'].'" class="rounded-circle user_img">'; } } if ($row['user_id'] == $outgoing_id) { $link = "php/chat_seen/?id=". $row['sender_id'] .""; } else { $link = "php/chat_seen/?id=". $row['user_id'] .""; } if ($row['user_id'] == $outgoing_id) { $user_name = "". $row['sender_name'] .""; } else { $user_name = "". $row['user_name'] .""; } $output .= '<a href='.$link.'> <li class="active dz-chat-user"> <div class="d-flex bd-highlight"> <div class="img_cont"> '.$user_image.' '.$status_icon.' </div> <div class="user_info"> '.$msg_unread_count.' <span>'.$user_name.'</span> <div class="status-dot '. $offline .'"><i class="fa fa-power-off" style="margin-right: 0.8px;"></i>'. $status .' </div> </div> </div> </li> </a>'; } }else{ $output .= 'No user found related to your search term'; } echo $output; ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 2.49 |
proxy
|
phpinfo
|
Settings