OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	05/19/2025 10:07:13 AM	rwxrwxr-x
📄 db_connect.php	614 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 delete_chat.php	382 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 delete_group.php	410 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 exit_group.php	431 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 function.php	22.64 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 memberSearch.php	1.32 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 navbar.php	607 bytes	05/19/2025 10:07:13 AM	rw-rw-r--
📄 script.js	11.89 KB	11/28/2024 01:24:17 PM	rw-rw-r--
📄 sendreview.php	1.71 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 sidebar.php	5.71 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 style.css	11.1 KB	11/28/2024 01:24:17 PM	rw-rw-r--
📄 test.php	1.83 KB	05/19/2025 10:07:13 AM	rw-rw-r--
📄 update_member.php	460 bytes	05/19/2025 10:07:13 AM	rw-rw-r--

Editing: test.php

<?php
include 'db_connect.php';

$searchText = $_POST['searchText'];

// List of members (you can fetch from database dynamically if needed)
// $members = display_all_members($conn);

function searchMember($conn, $searchText)
{
    $data = [];
    $user_id = '';
    $user_name = '';
    $user_email = '';

try {
        // Prepare the SQL statement with a placeholder
        $sql = "SELECT id, full_name, email FROM user WHERE full_name LIKE ? OR email LIKE ?";
        $stmt = $conn->prepare($sql);

// Append '%' to the search text for the LIKE query
        $searchText = '%' . $searchText . '%';

// Bind parameters and execute
        $stmt->bind_param("ss", $searchText, $searchText);
        $stmt->execute();

// Bind result variables
        $stmt->bind_result($user_id, $user_name, $user_email);

// Fetch results into an associative array
        while ($stmt->fetch()) {
            $data[] = [
                'user_id' => $user_id,
                'user_name' => $user_name,
                'user_email' => $user_email
            ];
        }

// Close statement
        $stmt->close();

return $data;
    } catch (mysqli_sql_exception $e) {
        // Handle the exception (e.g., log it or rethrow it)
        error_log("Error: " . $e->getMessage()); // Log the error
        return []; // Return an empty array or handle it as needed
    }
}

$members = searchMember($conn, $searchText);

foreach ($members as $member) {

?>
    <div class="scrollable-list-item">
        <a href="#" class="member-link" data-user_id="<?= htmlspecialchars($member['user_id']) ?>" data-user_name="<?= htmlspecialchars($member['user_name']) ?>"><?= htmlspecialchars($member['user_name']) ?>, <?= htmlspecialchars($member['user_email']) ?></a>
    </div>
<? } ?>