<?php
require_once('config/db_connect.php');

$type = '';
if(isset($_POST['type']) && !empty($_POST['type']) && is_numeric($_POST['type'])){
    $type = $_POST['type'];
}
if($type == 1){
    if (isset($_POST['slug']) && isset($_POST['category'])) {
        $slug = mysqli_real_escape_string($conn, $_POST['slug']);
        $category = intval($_POST['category']);
        
        $sql = "SELECT pagecontent FROM tblpagecontent WHERE slug = '$slug' AND contentcategory = $category;";
        $query = mysqli_query($conn, $sql);
        
        if (mysqli_num_rows($query) > 0) {
            $row = mysqli_fetch_assoc($query);
            echo $row['pagecontent'];
        } else {
            echo "No content found.";
        }
    } else {
        echo "Invalid request.";
    }
}else if($type == 2){
    if (isset($_POST['slug'])) {
        $slug = mysqli_real_escape_string($conn, $_POST['slug']);        
        $sql = "SELECT id, question, answer FROM tblpagefaqs WHERE slug = '$slug'";
        $query = mysqli_query($conn, $sql);
        
        if (mysqli_num_rows($query) > 0) {
            $resp = '<div class="accordion" id="accordionPanelsStayOpenExample">';
            $isFirst = true;         
            while ($row = mysqli_fetch_assoc($query)) {
                $id = $row['id'];
                $question = $row['question'];
                $answer = $row['answer'];
        
                $resp .= '<div class="accordion-item">';
                $resp .= '
                    <h2 class="accordion-header" id="panelsStayOpen-heading-' . $id . '">
                        <button class="accordion-button ' . ($isFirst ? '' : 'collapsed') . '" type="button" data-bs-toggle="collapse" 
                                data-bs-target="#panelsStayOpen-collapse-' . $id . '" 
                                aria-expanded="' . ($isFirst ? 'true' : 'false') . '" 
                                aria-controls="panelsStayOpen-collapse-' . $id . '">
                            ' . $question . '
                        </button>
                    </h2>
                    <div id="panelsStayOpen-collapse-' . $id . '" class="accordion-collapse collapse ' . ($isFirst ? 'show' : '') . '" 
                         aria-labelledby="panelsStayOpen-heading-' . $id . '">
                        <div class="accordion-body">
                            ' . $answer . '
                        </div>
                    </div>
                ';
                $resp .= '</div>';        
                $isFirst = false; 
            }        
            $resp .= '</div>';
            echo $resp;
        } else {
            echo "No content found.";
        }
        
    } else {
        echo "Invalid request.";
    }
}

?>