<?php include 'header.php';
include 'admin/config.php';
?>

<!-- breadcrumb -->
<div class="site-breadcrumb" style="background: url(assets/img/home/s0.png)">
    <div class="container">
        <h2 class="breadcrumb-title">About Us</h2>
        <ul class="breadcrumb-menu">
            <li><a href="index.php">Home</a></li>
            <li class="active">Constitution</li>
        </ul>
    </div>
</div>
<!-- breadcrumb end -->


<!-- course-area -->
<div class="course-area py-80">
    <div class="container">
        <div class=" text-center mb-4">
            <h2 class="mb-3">
                Members having Jurisdiction over Bayaluseeme Development Board.
            </h2>
            <p>
                The Board consists of the following members whose jurisdiction lie within the jurisdiction of the Board
            </p>
        </div>
        <div class="table-responsive">
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th scope="col">Sl. No.</th>
                        <th scope="col">Members</th>
                        <th scope="col">Nos</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                                    $sql = "select * from `members_having_Jurisdiction` ";
                                    $query = mysqli_query($con, $sql);

                                    if ($query) {
                                        $index = 1;
                                        foreach ($query as $items) {
                                            $i = $index++;
                                            $id = $items['id'];
                                            $members = $items['members'];
                                            $numbers = $items['numbers'];
                                            

                                      ?>

                                            <tr>
                                                <td><?php echo $i ?></td>
                                                <td><?php echo $members?></td>
                                               <td><?php echo $numbers?></td>


                                                
                                            </tr>

                                    <?php }
                                    } ?>


                </tbody>
            </table>
        </div>

        <div class=" text-center mb-4 mt-5">
            <h2 class="mb-3">
                Profiles of serving as Chairman of the Board
            </h2>

        </div>
        <div class="table-responsive">
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th scope="col">Sl. No.</th>
                        <th scope="col">Name of the Chairman (Sri/ Smt)</th>
                        <th scope="col">From Date</th>
                        <th scope="col">To Date</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                                    $sql = "select * from `chairman_of_the_board` ";
                                    $query = mysqli_query($con, $sql);

                                    if ($query) {
                                        $index = 1;
                                        foreach ($query as $items) {
                                            $i = $index++;
                                            $id = $items['id'];
                                            $name = $items['name'];
                                            $from_date = $items['from_date'];
                                             $to_date = $items['to_date'];

                                      ?>

                                            <tr>
                                                <td><?php echo $i ?></td>
                                                <td><?php echo $name?></td>
                                               <td><?php echo $from_date?></td>
                                                <td><?php echo $to_date?></td>


                                                
                                            </tr>

                                    <?php }
                                    } ?>

                </tbody>
            </table>
        </div>

        <div class=" text-center mb-4 mt-5">
            <h2 class="mb-3">
                Profile of serving as Secretary of the Board
            </h2>

        </div>
        <div class="table-responsive">
            <table class="table table-bordered">
                <thead>
                    <tr>
                        <th scope="col">Sl. No.</th>
                        <th scope="col">Name of the Secretary (Sri/ Smt)</th>
                        <th scope="col">From Date</th>
                        <th scope="col">To Date</th>
                    </tr>
                </thead>
                <tbody>
                      <?php
                                    $sql = "select * from `secretary_of_the_board` ";
                                    $query = mysqli_query($con, $sql);

                                    if ($query) {
                                        $index = 1;
                                        foreach ($query as $items) {
                                            $i = $index++;
                                            $id = $items['id'];
                                            $name = $items['name'];
                                            $from_date = $items['from_date'];
                                             $to_date = $items['to_date'];

                                      ?>

                                            <tr>
                                                <td><?php echo $i ?></td>
                                                <td><?php echo $name?></td>
                                               <td><?php echo $from_date?></td>
                                                <td><?php echo $to_date?></td>


                                                
                                            </tr>

                                    <?php }
                                    } ?>



                </tbody>
            </table>
        </div>

    </div>
</div>
<!-- course-area -->

<?php include 'footer.php' ?>