~NAXC~

File Content: `articles.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 Articles</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;">Title</th>
                            <th style="width: 200px;">Sub Title</th>
                            <th style="width: 200px;">Author</th>
                            <th style="width: 200px;">Article</th>
                            <th style="width: 150px;">Action</th>
                            <th style="width: 150px;">View</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $sql_desig = "SELECT * FROM `articles` ORDER BY art_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)) {
                                $art_id  = $row['art_id'];
                        ?>
                                <tr>
                                    <td><?= $i ?></td>
                                    <td><?= $row['art_title'] ?></td>
                                    <td><?= $row['art_sub_title'] ?></td>
                                    <td><?= $row['art_author'] ?></td>
                                    <td><img src="<?= $row['art_image'] ?>" alt="" style="width: 100px;"></td>
                                    <td>
                                        <a href="articles_edit.php?art_edit=<?= $art_id ?>" class="btn btn-primary">
                                            <i class="fa fa-edit text-white"></i>
                                        </a>
                                        <a href="articles_del.php?art_del=<?= $art_id ?>" class="btn btn-warning">
                                            <i class="fa fa-trash text-white"></i>
                                        </a>
                                    </td>
                                    <td><a href="view_articles.php?art_id=<?=$art_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: articles.php

File Content: `articles.php`
