במ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 Student</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>Student Image</label>
                            <input type="file" name="fimg" id="fimg" class="form-control" required>
                        </div>
                       
                       
                        <div class="form-group">
                            <label>Name</label>
                            <input type="text" name="fname" class="form-control" placeholder="Enter Name" required>
                        </div>
                        <div class="form-group">
                            <label>Class</label>
                            <input type="text" name="des" class="form-control checking_email" placeholder="Enter Class Name" required>
                            <small class="error_email" style="color: red;"></small>
                        </div>
                        
                         <div class="form-group">
                            <label>Secured Mark</label>
                            <input type="text" name="exp" class="form-control" placeholder="Enter Percentage">
                        </div>
                        
                        
                        <div class="form-group">
                            <label>Year</label>
                            <input type="text" name="qual" class="form-control" placeholder="Enter Year">
                        </div>
                        
                       
                       
                    </div>
                    <div class="modal-footer">
                        <button type="submit" name="fsave" 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 a new Student
    </button>

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

<?php
                $query = "SELECT * FROM fboard";
                $query_run = mysqli_query($connection, $query);
                if (mysqli_num_rows($query_run) > 0) {

<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                        <thead>
                            <tr>
                                <th>Id</th>
                                <th>Image</th>
                                <th>Name</th>
                                <th>Class</th>
                                <th>Secured Mark</th>
                                <th>Year</th>
                            
                                  <th>EDIT</th>
                                <th>DELETE</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $sl = 1;
                            while ($row = mysqli_fetch_assoc($query_run)) {
                            ?>
                                <tr>
                                    <td><?php echo $sl++; ?></td>
                                    <td><?php echo '<img src="faculty/' . $row['fimg'] . '"width ="100px" alt="Images">' ?></td>
                                    <td><?php echo $row['fname']; ?></td>
                                    <td><?php echo $row['des']; ?></td>
                                    <td><?php echo $row['qual']; ?></td>
                                    <td><?php echo $row['exp']; ?></td>
                                  
                                        <td>
                                        <form action="fboard_edit.php" method="post">
                                            <input type="hidden" name="fedit_id" value="<?php echo $row['id']; ?>">
                                            <button type="submit" name="fedit_btn" class="btn btn-success"> EDIT</button>
                                        </form>
                                    </td>
                                    <td>
                                        <form action="code.php" method="post">
                                            <input type="hidden" name="fdelete_id" value="<?php echo $row['id']; ?>">
                                            <button type="submit" name="fdelete_btn" class="btn btn-danger"> DELETE</button>
                                        </form>
                                    </td>
                                </tr>

<?php

}
                            ?>

</tbody>
                    </table>
                <?php
                } else {
                    echo "no records found";
                }
                ?>
            </div>
        </div>
    </div>

</div>

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