File Explorer

<?php include("includes/css.php");
if (isset($_POST['submit'])) {
extract($_POST);
$ip=$_SERVER['REMOTE_ADDR'];
 date_default_timezone_set('Asia/Kolkata');
 $datetime = date('Y-m-d H:i:s');
 $cls = $_POST['class'];
 $subt =$_POST['subject'];
 $class = implode(',', $class);
 $subject = implode(',', $subt);
$sql_prd="INSERT into staff_roles(staff_id,class_id,subject_id,created_date) values ('$id','$class','$subject','$datetime')";
$prd_res=mysqli_query($conn, $sql_prd);
if($prd_res){
 echo "<script>alert('Role Assign successfully!!!');  </script>";
}
}
?>

<body class="hold-transition skin-blue sidebar-mini">
    <div class="wrapper">
        <?php include("includes/header.php");?>
        <?php include("includes/sidebar.php");?>
        <div class="content-wrapper">
            
            <section class="content">
                <div class="row">
                    <div class="col-md-12">
                        <div class="box box-primary">
                            <div class="box-header with-border">
                                <div class="col-md-12">
                                    <h3 class="box-title">Assign Staff Role Details:</h3>
                                </div>
                            </div>
                            <div class="box-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered example3">
                                        <thead>
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Staff Id / Name </th>
                                                <th>Class</th>
                                                <th>Subject</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php  $i=1;
                                            $sql=mysqli_query($conn,"select staff_roles.*,class.class_name,staff.name,staff.staff_id,staff.last_name from staff_roles join staff on staff_roles.staff_id=staff.id join class on staff_roles.class_id=class.id ");
                                              while($res= mysqli_fetch_array($sql)){ ?>
                                            <tr> <td><?php echo $i; $i++; ?> </td>
                                                <td><strong>#<?= $res['staff_id'] ?>,</strong> <?= $res['name']." ".$res['last_name']; ?></td>
                                                <td><?= $res['class_name']; ?></td>
                                                <td><?php $sid=$res['subject_id'];
                                                 $rid = explode(",",$sid);
                                                foreach($rid as $pm_id){
                                                $sqlsb=mysqli_query($conn,"select * from subject where id='$pm_id'");
                                                       while($res_sb= mysqli_fetch_array($sqlsb)){ ?>
                                                    <?= $res_sb['subject_name']; ?><br/> 
                                                <?php } } ?> 
                                                </td>
                                                <td><a href="edit-assign-role.php?id=<?= $res['id']; ?>" class="pl-10 pr-10 font-20"><i class="fa fa-pencil-square"></i></a> <a href="javascript:delete_staff_by_ID('<?php echo $res['id'] ?>');" class="ask"><i class="fa fa-trash-o"></i></a> </td>
                                            </tr><?php } ?>
                                           
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
        <?php include("includes/footer.php");?>
    </div>
    <?php include("includes/js.php");?>
<script type="text/javascript">
function delete_staff_by_ID(id)
{
    if (confirm('Do You Want to Deleting This \nContinue anyway?')) {
        window.location.href = 'delete_staff_role.php?id=' + id;
    }
}
</script>
</body>

</html>

Editing File: assign-staff-role.php