“Expertise”,
“Business Name (if Applicable)” => “Business”,
“Contact Full Name” => “Name”,
“Phone Number” => “Phone”,
“Email” => “Email”,
“Website (if applicable)” => “Website”,
“Facebook (if applicable)” => “Facebook”,
“Instagram (if applicable)” => “Instagram”,
“Youtube (if applicable)” => “Youtube”,
“TikTok (if applicable)” => “TikTok”,
];
// Indexes for the displayed fields
$columnIndexes = [];
foreach ($customOrder as $label) {
$index = array_search($label, $headers);
if ($index !== false) {
$columnIndexes[$label] = $index;
}
}
// Get profession column separately for filtering
$professionIndex = array_search(“Please choose your profession”, $headers);
$professions = [];
foreach ($rows as $row) {
if (isset($row[$professionIndex]) && trim($row[$professionIndex]) !== ”) {
$professions[] = trim($row[$professionIndex]);
}
}
$professions = array_unique($professions);
sort($professions);
?>
‘;
}
// EXPERTISE
elseif ($label === “Please Specify Your Field of Expertise”) {
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
}
// Email
elseif ($lowerLabel === “email” && filter_var($value, FILTER_VALIDATE_EMAIL)) {
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
}
// Phone
elseif (strpos($lowerLabel, ‘phone’) !== false) {
$tel = preg_replace(‘/[^0-9+]/’, ”, $value);
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
}
elseif (strpos($lowerLabel, ‘website’) !== false) {
$clean = preg_replace(‘/\s+/’, ”, $value);
if (!preg_match(‘/^https?:\/\//i’, $clean)) {
$clean = ‘https://’ . $clean;
}
if (filter_var($clean, FILTER_VALIDATE_URL)) {
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
} else {
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
}
}
elseif (in_array($label, [
“Facebook (if applicable)”,
“Instagram (if applicable)”,
“Youtube (if applicable)”,
“TikTok (if applicable)”
])) {
$iconMap = [
“facebook” => ‘‘,
“instagram” => ‘‘,
“youtube” => ‘‘,
“tiktok” => ‘‘,
];
$platform = strtolower(explode(‘ ‘, $label)[0]); // e.g., “facebook”
$icon = isset($iconMap[$platform]) ? $iconMap[$platform] : ”;
$clean = preg_replace(‘/\s+/’, ”, $value);
if (!preg_match(‘/^https?:\/\//i’, $clean)) {
$clean = ‘https://’ . $clean;
}
if (filter_var($clean, FILTER_VALIDATE_URL)) {
echo ‘
‘ . $icon . ‘‘ . htmlspecialchars($value) . ‘
‘;
} else {
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
}
}
// Default text
else {
echo ‘
‘ . htmlspecialchars($value) . ‘
‘;
}
endforeach; ?>