|
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'])){
$student_id=$_POST['student_id'];
$overall_grade=$_POST['overall_grade'];
$sql = $conn->query("UPDATE results SET student_id='$student_id',overall_grade='$overall_grade' WHERE id='$id'");
if($sql){
for($i=0;$i<count($_POST['ids']);$i++){
$subject_id=$_POST['subject_id'][$i];
$ids=$_POST['ids'][$i];
$pa1=$_POST['pa1'][$i];
$pa1_mark1=$_POST['pa1_mark1'][$i];
$sql ="UPDATE result_list SET subject_id='$subject_id',pa1='$pa1',marks1='$pa1_mark1' WHERE id='".$ids."'";
if($conn->query($sql)){
echo '<script>alert("Updated successfully"); location.href="edit_result?id='.$id.'"</script>';
}else{
echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
}
}
if(isset($_POST['submit2'])){
$student_id=$_POST['student_id'];
$overall_grade=$_POST['overall_grade'];
$sql = $conn->query("UPDATE results SET student_id='$student_id',overall_grade='$overall_grade' WHERE id='$id'");
if($sql){
for($i=0;$i<count($_POST['ids']);$i++){
$subject_id=$_POST['subject_id'][$i];
$ids=$_POST['ids'][$i];
$pa2=$_POST['pa2'][$i];
$pa2_mark1=$_POST['pa2_mark1'][$i];
$sql ="UPDATE result_list SET subject_id='$subject_id',pa2='$pa2',marks2='$pa2_mark1' WHERE id='".$ids."'";
if($conn->query($sql)){
echo '<script>alert("Updated successfully"); location.href="edit_result?id='.$id.'"</script>';
}else{
echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
}
}
if(isset($_POST['submit3'])){
$student_id=$_POST['student_id'];
$overall_grade=$_POST['overall_grade'];
$sql = $conn->query("UPDATE results SET student_id='$student_id',overall_grade='$overall_grade' WHERE id='$id'");
if($sql){
for($i=0;$i<count($_POST['ids']);$i++){
$subject_id=$_POST['subject_id'][$i];
$ids=$_POST['ids'][$i];
$t1_mark1=$_POST['t1_mark1'][$i];
$theory1=$_POST['t1'][$i];
$sql ="UPDATE result_list SET subject_id='$subject_id',theory1='$theory1',marks3='$t1_mark1' WHERE id='".$ids."'";
if($conn->query($sql)){
echo '<script>alert("Updated successfully"); location.href="edit_result?id='.$id.'"</script>';
}else{
echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
}
}
if(isset($_POST['submit4'])){
$student_id=$_POST['student_id'];
$overall_grade=$_POST['overall_grade'];
$sql = $conn->query("UPDATE results SET student_id='$student_id',overall_grade='$overall_grade' WHERE id='$id'");
if($sql){
for($i=0;$i<count($_POST['ids']);$i++){
$subject_id=$_POST['subject_id'][$i];
$ids=$_POST['ids'][$i];
$t2_mark1=$_POST['t2_mark1'][$i];
$theory2=$_POST['t2'][$i];
$sql ="UPDATE result_list SET subject_id='$subject_id',theory2='$theory2',marks4='$t2_mark1' WHERE id='".$ids."'";
if($conn->query($sql)){
echo '<script>alert("Updated successfully"); location.href="edit_result?id='.$id.'"</script>';
}else{
echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
}
}
$q = "SELECT * FROM results WHERE id='$id' limit 1";
$result = mysqli_query($conn,$q);
$row = mysqli_fetch_assoc($result);
?>
<style>
#myTabContent .input-group{
width: 100%;
}
#myTabContent h2{
width: 100%;
text-align: center;
border-top: 1px solid #7b7b7b;
color: #fff;
font-size: 20px;
margin: 15px;
padding-top: 20px;
}
.form-control:disabled, .form-control[readonly] {
background-color: #0f1728;
opacity: 1;
cursor: not-allowed;
}
</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 Result</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">
<ul class="nav nav-tabs nav-justified" role="tablist">
<li class="nav-item">
<a class="nav-link active" data-toggle="tab" href="#pa1" role="tab" aria-controls="pa1" aria-selected="true">PA-1</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#pa2" role="tab" aria-controls="pa2" aria-selected="false">PA-2</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#t1" role="tab" aria-controls="t1" aria-selected="false">Theory-1</a>
</li>
<li class="nav-item">
<a class="nav-link" data-toggle="tab" href="#t2" role="tab" aria-controls="t2" aria-selected="false">Theory-2</a>
</li>
</ul>
<div class="tab-content mt-3">
<!-- PA-1 -->
<div class="tab-pane active" id="pa1" role="tabpanel" aria-labelledby="duck-tab">
<form method="post" enctype="multipart/form-data">
<div id="myTabContent" class="tab-content custom-product-edit">
<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="student_id" required>
<option value="">Select Student</option>
<?php
$q = "select * from students";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$row['student_id']) {echo 'selected';} ?> ><?php echo $res['student_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-3 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Overall Grade" disabled>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12 pl-0">
<input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" value="<?php echo $rows['overall_grade'] ?>" required>
</div>
</div>
<div class="row">
<?php
$qry = "SELECT * FROM result_list WHERE result_id='".$row['id']."'";
$result2 = mysqli_query($conn,$qry);
$x=1;
while($rows = mysqli_fetch_array($result2)) {
?>
<input type="hidden" name="ids[]" value="<?php echo $rows['id'] ?>">
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
<option value="">Select Subject</option>
<?php
$q = "select * from subjects";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$rows['subject_id']) {echo 'selected';} ?>><?php echo $res['subject_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Maximum Marks" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="pa1_mark1[]" class="form-control" placeholder="Marks" value="<?php echo $rows['marks1'] ?>" required>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Marks Obtained" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="pa1[]" class="form-control" placeholder="PA-1" required value="<?php echo $rows['pa1'] ?>">
</div>
</div>
<?php } ?>
<div class="col-lg-12 col-md-12">
<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="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
</a>
</div>
</div>
</div>
</div>
</form>
</div>
<!-- PA-2 -->
<div class="tab-pane" id="pa2" role="tabpanel" aria-labelledby="pa2-tab">
<form method="post" enctype="multipart/form-data">
<div id="myTabContent" class="tab-content custom-product-edit">
<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="student_id" required>
<option value="">Select Student</option>
<?php
$q = "select * from students";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$row['student_id']) {echo 'selected';} ?> ><?php echo $res['student_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-3 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Overall Grade" disabled>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12 pl-0">
<input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" value="<?php echo $rows['overall_grade'] ?>" required>
</div>
</div>
<div class="row">
<?php
$qry = "SELECT * FROM result_list WHERE result_id='".$row['id']."'";
$result2 = mysqli_query($conn,$qry);
$x=1;
while($rows = mysqli_fetch_array($result2)) {
?>
<input type="hidden" name="ids[]" value="<?php echo $rows['id'] ?>">
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
<option value="">Select Subject</option>
<?php
$q = "select * from subjects";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$rows['subject_id']) {echo 'selected';} ?>><?php echo $res['subject_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Maximum Marks" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="pa2_mark1[]" class="form-control" placeholder="Marks" value="<?php echo $rows['marks2'] ?>" required>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Marks Obtained" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="pa2[]" class="form-control" placeholder="PA-2" required value="<?php echo $rows['pa2'] ?>">
</div>
</div>
<?php } ?>
<div class="col-lg-12 col-md-12">
<div class="text-center custom-pro-edt-ds">
<button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit2">Save
</button>
<a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
</a>
</div>
</div>
</div>
</div>
</form>
</div>
<!-- THEORY-1 -->
<div class="tab-pane" id="t1" role="tabpanel" aria-labelledby="t1-tab">
<form method="post" enctype="multipart/form-data">
<div id="myTabContent" class="tab-content custom-product-edit">
<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="student_id" required>
<option value="">Select Student</option>
<?php
$q = "select * from students";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$row['student_id']) {echo 'selected';} ?> ><?php echo $res['student_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-3 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Overall Grade" disabled>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12 pl-0">
<input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" value="<?php echo $rows['overall_grade'] ?>" required>
</div>
</div>
<div class="row">
<?php
$qry = "SELECT * FROM result_list WHERE result_id='".$row['id']."'";
$result2 = mysqli_query($conn,$qry);
$x=1;
while($rows = mysqli_fetch_array($result2)) {
?>
<input type="hidden" name="ids[]" value="<?php echo $rows['id'] ?>">
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
<option value="">Select Subject</option>
<?php
$q = "select * from subjects";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>"><?php echo $res['subject_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Maximum Marks" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="t1_mark1[]" class="form-control" placeholder="Marks" value="<?php echo $rows['marks3'] ?>" required>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Marks Obtained" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="t1[]" class="form-control" placeholder="Theory-1" required value="<?php echo $rows['theory1'] ?>">
</div>
</div>
<?php } ?>
<div class="col-lg-12 col-md-12">
<div class="text-center custom-pro-edt-ds">
<button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit3">Save
</button>
<a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
</a>
</div>
</div>
</div>
</div>
</form>
</div>
<!-- THEORY-2 -->
<div class="tab-pane" id="t2" role="tabpanel" aria-labelledby="t2-tab">
<form method="post" enctype="multipart/form-data">
<div id="myTabContent" class="tab-content custom-product-edit">
<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="student_id" required>
<option value="">Select Student</option>
<?php
$q = "select * from students";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>" <?php if ($res['id']==$row['student_id']) {echo 'selected';} ?> ><?php echo $res['student_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-3 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Overall Grade" disabled>
</div>
</div>
<div class="col-md-3 col-sm-6 col-xs-12 pl-0">
<input type="text" class="form-control" placeholder="Overall Grade" name="overall_grade" value="<?php echo $rows['overall_grade'] ?>" required>
</div>
</div>
<div class="row">
<?php
$qry = "SELECT * FROM result_list WHERE result_id='".$row['id']."'";
$result2 = mysqli_query($conn,$qry);
$x=1;
while($rows = mysqli_fetch_array($result2)) {
?>
<input type="hidden" name="ids[]" value="<?php echo $rows['id'] ?>">
<div class="col-md-4 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject<?php echo $x; ?>" required onchange="subject(<?php echo $x; ?>)">
<option value="">Select Subject</option>
<?php
$q = "select * from subjects";
$query = mysqli_query($conn,$q);
while($res = mysqli_fetch_array($query)) { ?>
<option value="<?php echo $res['id'] ?>"><?php echo $res['subject_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Maximum Marks" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="t2_mark1[]" class="form-control" placeholder="Marks" value="<?php echo $rows['marks4'] ?>" required>
</div>
</div>
<div class="col-md-2 pr-0">
<div class="input-group mg-b-pro-edt">
<input type="text" class="form-control" value="Marks Obtained" readonly>
</div>
</div>
<div class="col-md-2 col-sm-6 col-xs-12 pl-0">
<div class="input-group mg-b-pro-edt">
<input type="number" name="t2[]" class="form-control" placeholder="Theory-2" required value="<?php echo $rows['theory2'] ?>">
</div>
</div>
<?php } ?>
<div class="col-lg-12 col-md-12">
<div class="text-center custom-pro-edt-ds">
<button type="submit" class="btn btn-ctl-bt waves-effect waves-light m-r-10" name="submit4">Save
</button>
<a href="results" class="btn btn-ctl-bt waves-effect waves-light">cancel
</a>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('include/footer.php'); ?>