prepare("SELECT HR_CID FROM hr_person WHERE HR_FNAME LIKE ? AND (HR_LNAME LIKE ? OR ? = '') AND HR_IMAGE IS NOT NULL LIMIT 1"); $stmt->execute(["%$fname%", "%$lname%", $lname]); $hr_person = $stmt->fetch(PDO::FETCH_ASSOC); if ($hr_person && !empty($hr_person['HR_CID'])) { $_SESSION['user_avatar'] = "api/hr_image.php?cid=" . urlencode($hr_person['HR_CID']); } } } } catch (Exception $e) { // Ignore error } } $userAvatar = $_SESSION['user_avatar']; ?>
User avatar