<?php
$actual_link = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? 'https' : 'http') . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
$url_slug = basename($actual_link);

global $wpdb;
$TT_BOARD_EXAM = "sp_board_exam";
$TT_STATES = "sp_states";

// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

$stateBoardDetail = $wpdb->get_results("SELECT b.id, b.board, b.state_id, s.state_name, s.image_icon, b.board_image FROM $TT_BOARD_EXAM AS b LEFT JOIN $TT_STATES AS s ON s.state_id=b.state_id WHERE b.status='1' group by b.state_id ORDER BY b.update_date desc");
?>
<!-- ALL PAGE HEADER SECTION -->

<section class="allPageheaderSection wow fadeInDown">
    <div class="allPageheaderSectionbg"></div>
    <div class="container">
        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <h2>State Board Exam</h2>
                <h1>Get the Results of your State Board Exams in India. Get links to the Board Exam Results for classes 10 and 12.</h1>
                <p><a href="/">Home</a> / State Board</p>
            </div>
        </div>
    </div>
</section>

<!-- END ALL PAGE HEADER SECTION -->

<!-- STATE BOARD EXAM PAGE SECTION -->

<section class="StateBoardexamPageSection">
    <div class="container">
        <!-- Display-Horizontal-Full -->
        <ins class="adsbygoogle"
            style="display:block"
            data-ad-client="ca-pub-2967295438144070"
            data-ad-slot="7766773989"
            data-ad-format="auto"
            data-full-width-responsive="true"></ins>
        <script>
            (adsbygoogle = window.adsbygoogle || []).push({});
        </script>
        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="SearchStateBoardExamsBox wow fadeInUp">
                    <h4>Search State Board Exams</h4>
                    <form action="">
                        <i class="fas fa-search"></i>
                        <input type="text" id="search_data" onkeyup="checkSearch()" placeholder="Exam State Name...">
                    </form>
                </div>
            </div>

            <div id="boardList">
                <?php
                $a = 1;
                foreach ($stateBoardDetail as $board) {
                    $boardName = $board->board;
                    $stateId = $board->state_id;

                    $i = 1;
                    $boardDetail = $wpdb->get_results("SELECT e.id, e.for_class, e.link FROM $TT_BOARD_EXAM AS e LEFT JOIN $TT_STATES AS s ON s.state_id = e.state_id WHERE e.status='1' AND e.state_id='$stateId' AND e.board='$boardName' ORDER BY e.update_date DESC");   ?>

                    <div class="col-md-4 col-sm-4 col-xs-12 boardList">
                        <?php if ($a % 2 == 0) { ?>
                            <div class="StateBoardexamBox wow fadeInLeft">
                            <?php } else {  ?>
                                <div class="StateBoardexamBox wow fadeInRight">
                                <?php } ?>

                                <?php if ($board->board_image != '') { ?>
                                    <img src="/images/<?php echo $board->img_icon; ?>" alt="">
                                <?php } else if ($board->image_icon != '') { ?>
                                    <img src="/images/<?php echo $board->image_icon; ?>" alt="">
                                <?php } else { ?>
                                    <img src="/images/default_board_icon.png" alt="">
                                <?php } ?>

                                <div>
                                    <h4><?php echo $board->state_name; ?> <br> <font class="text-muted"><?php echo $boardName; ?></font></h4>
                                    <p>
                                        <?php foreach ($boardDetail as $class) {  ?>
                                            <a <?php if ($class->link != '') {
                                                    echo 'href="' . $class->link . '/" target="_blank"';
                                                } ?> <?php if ($i % 2 == 0) {
                                                            echo 'style="color:#ed2551; border:1px solid #ed2551;"';
                                                        } else if ($i % 2 == 1) {
                                                            echo 'style="color:#03a84e; border:1px solid #03a84e;"';
                                                        } ?>><?php echo $class->for_class; ?></a>
                                        <?php $i++;
                                        }  ?>
                                    </p>
                                </div>
                                </div>
                            </div>
                        <?php $a++;
                    } ?>
                    </div>
            </div>
        </div>
</section>

<script>
    // search data as per state name
    function checkSearch() {
        var search = document.getElementById("search_data");
        var search_val = search.value.toUpperCase();
        var maindiv = document.getElementById("boardList");
        var div = maindiv.getElementsByTagName("div");
        for (var i = 0; i < div.length; i++) {
            var heading = div[i].getElementsByTagName("h4")[0];
            var txtValue = heading.textContent || heading.innerText;
            if (txtValue.toUpperCase().indexOf(search_val) > -1) {
                div[i].style.display = "";
            } else {
                div[i].style.display = "none";
            }
        }
    }
</script>

<!-- END STATE BOARD EXAM PAGE SECTION -->