~NAXC~

File Content: `community.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>Community Link</h1>
                    <a href="add_community.php" class="btn btn-success">Add Community <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">Community ID</th>
                        <th scope="col">Community Link</th>
                        <th scope="col">Created Date </th>
                        <th scope="col">Free Class Date </th>
                        <th scope="col">Action</th>
                      
                    </tr>
                </thead>
                <tbody>
                    <?php
                    $sql = "SELECT * FROM `community_link`";
                    $res = mysqli_query($conn, $sql);
                    if ($res) {
                        $count = 0;
                        while ($row = mysqli_fetch_assoc($res)) {
                            $id = $row['comunity_id'];
                                $abt_content = $row['community_link'];
                                $abt_create_dt = $row['create_dt'];
                                $batch_id=$row['community_uniq_id'];
                                $class_date=$row['free_class_date'];
                                $count = $count + 1;
                    ?>
                    <tr>
                        <td><?= $count ?></td>
                        <td><?= $batch_id ?></td>
                        <td><?= $abt_content ?></td>
                        <td><?= $abt_create_dt ?></td>
                        <td><?=date('d-m-Y',strtotime($class_date))?></td>
                        <td>
                            <a href="community_edit.php?edit=<?= $id ?>"><i class="fa fa-edit btn btn-primary"></i></a>
                            <!--<a href="community_delete.php?delete=<?= $id?>" class="delete-btn" ><i class="fa fa-trash-o 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: community.php

File Content: `community.php`
