במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

]]jkjjgdjffksdkdfdkfjgsldkfhgjkgjkhjkgjkdascxvxcvxcvjdklfgjslkdfgjlskdfgjdskfgj במ12[aspddfsdfsdfdrxcvxcvcxvxcvxcvxcvxcvxcvxcvxcvxcvxxvxcvxcvxcv;'

<?php
include('includes/header.php');
include('includes/navbar.php');
include('security.php');
?>

<div class="modal fade" id="addadminprofile" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Add a new notice</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>

<form action="code.php" method="POST" enctype="multipart/form-data">
                    <div class="modal-body">
                        <div class="form-group">
                            <label>Date</label>
                            <input type="text" name="date" class="form-control" placeholder="Enter Date">
                        </div>
                        <div class="form-group">
                            <label>Notice Text</label>
                            <input type="text" name="ntext" class="form-control" placeholder="Enter Text">
                        </div>
                        <div class="form-group">
                            <label>URL</label>
                            <input type="text" name="nurl1" class="form-control" placeholder="Enter URL">
                        </div>
                        <div class="form-group">
                            <label>Upload Pdf</label>
                            <input type="file" name="nurl" id="nurl" class="form-control">
                        </div>

</div>
                    <div class="modal-footer">
                        <button type="submit" name="notice_save" class="btn btn-primary">Save</button>
                    </div>
                </form>

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

<button type="button" class="btn btn-primary" data-toggle="modal" data-target="#addadminprofile">
        Add new notice
    </button>

<div class="card shadow mb-4">
        <div class="card-header py-3">
            <h6 class="m-0 font-weight-bold text-primary">Notice</h6>
        </div>
        <div class="card-body">
            <div class="table-responsive">

<?php
                $query = "SELECT * FROM nboard";
                $query_run = mysqli_query($connection, $query);
                ?>

<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                            <th>Sl</th>
                            <th>Date</th>
                            <th>Notice Text</th>
                            <th>Uploaded Files</th>
                            <th>URL</th>
                            <th>EDIT</th>
                            <th>DELETE</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        if (mysqli_num_rows($query_run) > 0) {
                            $sl = 1;
                            while ($row = mysqli_fetch_assoc($query_run)) {
                        ?>
                                <tr>
                                    <td><?php echo $sl++; ?></td>
                                    <td><?php echo $row['date']; ?></td>
                                    <td><?php echo $row['ntext']; ?></td>
                                    <td><?php echo '<a href="files/' . $row['nurl'] . '">PDF_FILE</a>' ?></td>
                                    <td><?php echo $row['nurl1']; ?></td>
                                    <td>
                                        <form action="nboard_edit.php" method="post">
                                            <input type="hidden" name="edit_id" value="<?php echo $row['id']; ?>">
                                            <button type="submit" name="edit_btn" class="btn btn-success"> EDIT</button>
                                        </form>
                                    </td>
                                    <td>
                                        <form action="code.php" method="post">
                                            <input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>">
                                            <button type="submit" name="delete_btn" class="btn btn-danger"> DELETE</button>
                                        </form>
                                    </td>
                                </tr>
                        <?php
                            }
                        } else {
                            echo "No Record Found";
                        }
                        ?>
                    </tbody>
                </table>

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

</div>

<?php
include('includes/scripts.php');
include('includes/footer.php');
?>