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 * from staff");
                                              while($res= mysqli_fetch_array($sql)){ ?>
                                            <tr> <form method="post" action="">
                                                <td><?php echo $i; $i++; ?> </td>
                                                <td><strong>#<?= $res['staff_id'] ?>,</strong> <?= $res['name']." ".$res['last_name']; ?></td>
                                                <td><select class="form-control" name="state">
                                                    <?php  $sqlcl=mysqli_query($conn,"select * from class");
                                                       while($res_cls= mysqli_fetch_array($sqlcl)){ ?>
                                                    <input name="class[]" value="<?= $res_cls['id']; ?>" type="checkbox"> <?= $res_cls['class_name']; ?> &nbsp; &nbsp; <?php } ?>
                                                </td>
                                                <td><?php $sqlsb=mysqli_query($conn,"select * from subject");
                                                       while($res_sb= mysqli_fetch_array($sqlsb)){ ?>
                                                    <input name="subject[]" value="<?= $res_sb['id']; ?>" type="checkbox"> <?= $res_sb['subject_name']; ?> &nbsp; &nbsp; 
                                                <?php } ?> 
                                                </td>
                                                <td><input name="id"  value="<?= $res['id'] ?>" type="hidden">
                                                    <button type="submit" name="submit" class="btn btn-success btn-sm mt-5" ><i class="fa fa-check"></i> Update</button> </td></form>
                                            </tr><?php } ?>
                                           
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
        <?php include("includes/footer.php");?>
    </div>
    <?php include("includes/js.php");?>

</body>

</html>

Editing File: assign-staff-role1.php