/home/ierixinf/public_html/testing.ierixinfotech.com/faqShow.php
<?php
include 'admin/database/config.php';
function GetFaq($conn)
{
$query = $conn->prepare("SELECT * FROM faq WHERE published = 1 ");
$query->execute();
return $query->fetchAll(PDO::FETCH_ASSOC);
}
$GetFaq = GetFaq($conn);
// Structure the data by unique page_url
$faqArray = [];
foreach ($GetFaq as $faq) {
$pageUrl = $faq['page_url'];
if (!isset($faqArray[$pageUrl])) {
$faqArray[$pageUrl] = [
'page_url' => $pageUrl,
'faqs' => []
];
}
$faqArray[$pageUrl]['faqs'][] = [
'name' => $faq['name'],
'faq_content' => $faq['faq_content']
];
}
$faqs = array_values($faqArray); // Convert associative array to indexed array
// var_dump($faqs);
?>
<section class="faq-page">
<div class="container-fluid filter px-5">
<div class="text-center">
<ul class="faq-filter d-flex justify-content-center pb-5">
<?php $isFirst = true; ?>
<?php foreach ($faqs as $faqGroup) : ?>
<li class="list <?php echo ($isFirst ? 'faq-filter-active' : ''); ?>" data-filter="<?php echo htmlspecialchars($faqGroup['page_url']); ?>">
<!-- <?php echo htmlspecialchars($faqGroup['page_url']); ?> -->
<?php
// Remove hyphens
$pageUrl = str_replace('-', ' ', $faqGroup['page_url']);
// Capitalize the first letter of each word
$pageUrl = ucwords($pageUrl);
// Echo the HTML-safe version of the modified page URL
echo htmlspecialchars($pageUrl);
?>
</li>
<?php $isFirst = false; ?>
<?php endforeach; ?>
</ul>
<!-- Dropdown for smaller screens -->
<select class="faq-filter-dropdown">
<?php foreach ($faqs as $faqGroup) : ?>
<option value="<?php echo htmlspecialchars($faqGroup['page_url']); ?>">
<?php echo htmlspecialchars($faqGroup['page_url']); ?>
</option>
<?php endforeach; ?>
</select>
</div>
</div>
<!-- Show remaining FAQs after the first 2 per category -->
<div class="container-fluid faq-aacrodion pt-5">
<div class="row">
<?php foreach ($faqs as $faqGroup) : ?>
<?php foreach ($faqGroup['faqs'] as $faq) : ?>
<div class="col-md-6">
<div class="container">
<div class="faq-page__accrodion" data-grp-name="faq-one-accrodion">
<div class="row d-block">
<div class="col-sm-12 accrodion-container">
<div class="accrodion <?= htmlspecialchars($faqGroup['page_url']) ?>">
<div class="accrodion-title">
<h6><?= htmlspecialchars($faq['name']) ?></h6>
</div>
<div class="accrodion-content">
<div class="inner">
<!-- <p><?= nl2br(htmlspecialchars($faq['faq_content'])) ?></p> -->
<p><?= $faq['faq_content'] ?></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php endforeach; ?>
<?php endforeach; ?>
</div>
</div>
</section>