|
1Server IP : 2a02:4780:11:1776:0:2637:29db:10 / Your IP : 216.73.217.74 Web Server : LiteSpeed System : Linux in-mum-web1676.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u641149403 ( 641149403) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u641149403/domains/emrskalsi.com/public_html/admin/img/blog-details/../../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->
<?php include('include/header.php'); ?>
<?php
if(isset($_POST['submit'])){
$student_id=$_POST['student_id'];
$total=0;
for($i=0;$i<count($_POST['subject_id']);$i++){
$subject_id=$_POST['subject_id'][$i];
$marks=$_POST['marks'][$i];
$total+=$_POST['marks'][$i];
$sql = $conn->query("INSERT INTO pa_2_result(student_id,subject_id,marks,total,type) VALUES ('$student_id','$subject_id','$marks','$total','pa1')");
}
if($sql){
echo '<script>alert("Added successfully"); location.href="pa-1"</script>';
}else{
echo '<script>alert("Oops Something Went Wrong!");</script>';
}
}
?>
<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>Add 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">
<form method="post" enctype="multipart/form-data">
<div id="myTabContent" class="tab-content custom-product-edit">
<div class="row">
<div class="col-md-6">
<div class="row">
<div class="col-md-12 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 echo $res['student_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject1" required onchange="subject(1)">
<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-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject2" required onchange="subject(2)">
<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-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject3" required onchange="subject(3)">
<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-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject4" required onchange="subject(4)">
<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-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject5" required onchange="subject(5)">
<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-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<select class="form-control" name="subject_id[]" id="subject6" required onchange="subject(6)">
<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-6 col-sm-6 col-xs-12">
<div class="input-group mg-b-pro-edt">
<input type="number" name="marks[]" class="form-control" placeholder="Marks" required>
</div>
</div>
<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>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script>
function subject(e) {
num = e +1;
var val1 = $('#subject1').val();
var val2 = $('#subject2').val();
var val3 = $('#subject3').val();
var val4 = $('#subject4').val();
var val5 = $('#subject5').val();
var val6 = $('#subject6').val();
if (val1!='') {
var val1 = $('#subject1').val();
}else{
var val1 = 0;
}
if (val2!='') {
var val2 = $('#subject2').val();
}else{
var val2 = 0;
}
if (val3!='') {
var val3 = $('#subject3').val();
}else{
var val3 = 0;
}
if (val4!='') {
var val4 = $('#subject4').val();
}else{
var val4 = 0;
}
if (val5!='') {
var val5 = $('#subject5').val();
}else{
var val5 = 0;
}
if (val6!='') {
var val6 = $('#subject5').val();
}else{
var val6 = 0;
}
console.log(val5,val4,val3,val2,val1);
$.ajax({
url: "change_subject_status.php",
type: "POST",
data: {
val1: val1,val2: val2,val3: val3,val4: val4,val5: val5,val6: val6,
},
success: function(response){
$( "#subject"+num ).html(response);
},
})
}
</script>
<?php include('include/footer.php'); ?>