connect_error) {
die("Connection failed: " . $mysqli->connect_error);
}
// Get user ID from session or fallback
$id = isset($_GET['id']) ? intval($_GET['id']) : (isset($_SESSION['user_id']) ? intval($_SESSION['user_id']) : 0);
// Redirect or show error if no valid ID
if ($id === 0) {
echo "
User not found!
";
exit();
}
// Fetch user details
$stmt = $mysqli->prepare("SELECT * FROM accounts WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
$stmt->close();
$mysqli->close();
if (!$user) {
echo "
User not found!
";
exit();
}
// Mask account number
$masked_account = str_repeat("X", 6) . substr($user['account_number'], -4);
?>
User Profile | Safe Saw