~NAXC~

File Content: `preparatory_guide.php`

<?php
include('include/header.php');
include('include/conn.php');
error_reporting(E_ALL);
ini_set('display_errors', 1);


?>

<link href="https://cdn.datatables.net/1.12.1/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css">
<link href="https://cdn.datatables.net/buttons/2.2.3/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css">

<style type="text/css">
    .dt-buttons {
        width: 50%;
    }
</style>

<!-- begin MAIN PAGE CONTENT -->
<div id="page-wrapper" style="min-height:142vh;">
    <div class="page-content">
        <!-- begin PAGE TITLE ROW -->
        <div class="row">
            <div class="col-lg-12">
                <div class="page-title">
                    <h1>Preparatory Guide</h1>
                    <a href="./add_guide.php" class="btn btn-success">Add <strong>+</strong></a>
                </div>
                <div class="row">
                    <div class="col-lg-6" style="margin-bottom:10px;">

                    </div>
                </div>
            </div>
          
            <table id="data_table" class="display dataTable table table-striped table-bordered table-hover table-green profile-table">
                <thead>
                    <tr>
                        <th scope="col">S.No</th>
                        <th scope="col">Preparatory Guide Title</th>
                        <th scope="col">Preparatory Guide File </th>
                        <th scope="col">Created Date </th>
                        <th scope="col">Action</th>
                      
                    </tr>
                </thead>
                <tbody>
                    <?php
                    $sql = "SELECT * FROM `preparatory_guide`";
                    $res = mysqli_query($conn, $sql);
                    if ($res) {
                        $count = 0;
                        while ($row = mysqli_fetch_assoc($res)) {
                            $id = $row['guide_id'];
                                $title = $row['guide_title'];
                                $guide_file = $row['guide_file'];
                                $guide_create_dt = $row['created_dt'];
                                $created_dt=$row['created_dt'];
                                $count = $count + 1;
                    ?>
                    <tr>
                        <td><?= $count ?></td>
                        <td><?= $title ?></td>
                        <td><a href='../<?= $guide_file ?>' target='_blank'><i class="fa-solid fa-file-pdf">Open</i></a></td>
                        <td><?=date('d-m-Y',strtotime($guide_create_dt))?></td>
                        <td>
                            <a href="add_guide.php?guide_edit=<?= $id ?>"><i class="fa fa-edit btn btn-primary"></i></a>
                            <a href="guide_delete.php?delete=<?= $id?>" class="delete-btn" ><i class="fa fa-trash btn btn-danger"></i></a>
                        </td>
                       

                    </tr>
                    <?php
                        }
                    }
                    ?>
                </tbody>
            </table>
        </div>
        <!-- /.col-lg-12 -->
    </div>
    <!-- /.row -->
</div>
<!-- /.page-content -->
</div>
<!-- /#page-wrapper -->

<!-- begin FOOTER -->
<?php include('include/footer.php'); ?>
<!-- end FOOTER -->
<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() {
    $('#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>
File Content: preparatory_guide.php

File Content: `preparatory_guide.php`
