~NAXC~

File Content: `enquiry.php`

<?php
include('include/header.php');
ini_set('display_errors', 0);

?>
<style>
    .access input[type="checkbox"]:checked {
        background-color: orangered;
        color: orangered;
    }

    select {
        width: 200px;
        padding: 5px;
    }

    select option:checked {
        background-color: orangered;
        color: white;
    }

    select option:hover {
        background-color: orangered;
        color: black;
    }
</style>


<div id="page-wrapper" style="min-height:142vh;">
    <div class="page-content">
        <!-- begin PAGE TITLE ROW -->
        <div class="row">
        <div class="row">
            <div class="col-md-2" style="margin-top: 20px;">

                <!--<a href="add_articles.php" class="btn btn-success">Article +</a>-->
            </div>
        </div>
        <hr class="mt-5">
        <div class="row">
            <h3 class="text-center" style="background-color:#ffcc99;">List of Enquiries</h3>
        </div>
        <div class="row" >
            <div class="col-md-12">
            <table id="data_table" class="display dataTable table table-striped table-bordered table-hover table-green profile-table">
                    <thead>
                        <tr>
                            <th style="width: 50px;">S.No</th>
                            <th style="width: 200px;">Name</th>
                            <th style="width: 200px;">Email</th>
                            <th style="width: 200px;">Mobile</th>
                            <th style="width: 200px;">Subject</th>
                            <th style="width: 150px;">Message</th>
                            <th style="width: 150px;">View</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $sql_desig = "SELECT * FROM `enquire` ORDER BY enq_id DESC";
                        $desig_result = mysqli_query($conn, $sql_desig);

                        if ($desig_result) {
                            $i = 1; // Initialize the counter outside the loop
                            while ($row = mysqli_fetch_assoc($desig_result)) {
                                $enq_id  = $row['enq_id'];
                        ?>
                                <tr>
                                    <td><?= $i ?></td>
                                    <td><?= $row['enq_name'] ?></td>
                                    <td><?= $row['enq_email'] ?></td>
                                    <td><?= $row['enq_mobile'] ?></td>
                                    <td><?= $row['enq_subject'] ?></td>
                                    <td><?= $row['enq_message'] ?></td>
                                    
                                    <td><a href="view_enquiry.php?enq_id=<?=$enq_id?>" class="btn btn-primary">view</a></td>
                                </tr>
                        <?php
                                $i++; // Increment the counter inside the loop
                            }
                        }
                        ?>
                    </tbody>
                </table>

            </div>
        </div>

    </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdn.datatables.net/1.12.1/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/2.2.3/js/buttons.colVis.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>

<script>
    $(document).ready(function() {
        // Initialize DataTable
        $('#data_table').DataTable({
            dom: 'Bfrtip',
            buttons: [{
                    extend: 'copy',
                    className: 'btn btn-primary',
                    text: 'Copy',
                },
                {
                    extend: 'csv',
                    className: 'btn btn-primary',
                    text: 'CSV',
                },
                {
                    extend: 'excel',
                    className: 'btn btn-primary',
                    text: 'Excel',
                },
                {
                    extend: 'pdf',
                    className: 'btn btn-primary',
                    text: 'PDF',
                },
                {
                    extend: 'print',
                    className: 'btn btn-primary',
                    text: 'Print',
                },

            ]
        });

        

    });
</script>
<?php
include('include/footer.php');
?>
File Content: enquiry.php

File Content: `enquiry.php`
