prepare("SELECT username, fullname, email, description FROM account WHERE id = ?"); $stmt->bind_param("i", $user_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $user = $result->fetch_assoc(); } else { session_destroy(); header("Location: signin.php"); exit(); } $stmt->close(); $search_query = $_GET['search'] ?? ''; if ($search_query !== '') { $search_param = "%" . $search_query . "%"; $all_users_stmt = $conn->prepare("SELECT id, username, fullname, description FROM account WHERE id != ? AND (username LIKE ? OR fullname LIKE ?)"); $all_users_stmt->bind_param("iss", $user_id, $search_param, $search_param); } else { $all_users_stmt = $conn->prepare("SELECT id, username, fullname, description FROM account WHERE id != ?"); $all_users_stmt->bind_param("i", $user_id); } $all_users_stmt->execute(); $all_users_result = $all_users_stmt->get_result(); $all_users = []; while ($row = $all_users_result->fetch_assoc()) { $all_users[] = $row; } $all_users_stmt->close(); $conn->close(); ?>
= strip_tags($user['description'], '
') ?>
No description provided yet.
| Username | Full Name | Description | Action |
|---|---|---|---|
| = htmlspecialchars($u['username']) ?> | = htmlspecialchars($u['fullname']) ?> | = strip_tags($u['description'] ?? '', ' ') ?> |
View Profile |