<?php 
include('config.php');
$id=$_POST['id'];

$q = "SELECT * FROM results WHERE id='$id'";
$result  = mysqli_query($conn,$q);
$row = mysqli_fetch_assoc($result);
?>
	<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-3 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<select class="form-control" name="subject_id[]" disabled 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-9">
				<div class="row">
					<div class="col-md-3 col-sm-6 col-xs-12">
						<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'] ?>" disabled>
						</div>
					</div>
					<div class="col-md-3 col-sm-6 col-xs-12">
						<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'] ?>" disabled>
						</div>
					</div>
					<div class="col-md-3 col-sm-6 col-xs-12">
						<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'] ?>" disabled>
						</div>
					</div>
					<div class="col-md-3 col-sm-6 col-xs-12">
						<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'] ?>" disabled>
						</div>
					</div>
				</div>
			</div>
			<?php $x++; } ?>
		</div>
			<form method="post" enctype="multipart/form-data">
		<div class="row">
			<h2>SCHOLASTIC AREA</h2>
			<div class="col-md-4 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="hidden" name="id" value="<?php echo $row['id'] ?>">
					<input type="text" name="work_experience" class="form-control" placeholder="Work Experience" required value="<?php echo $row['work_experience'] ?>">
				</div>
			</div>
			<div class="col-md-4 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="art_education" class="form-control" placeholder="Art Education" required value="<?php echo $row['art_education'] ?>">
				</div>
			</div>
			<div class="col-md-4 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="physical_education" class="form-control" placeholder="Physical & Health Education" required value="<?php echo $row['physical_education'] ?>">
				</div>
			</div>
			<h2>LIFE SKILL</h2>
			<div class="col-md-4 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="thinking_skill" class="form-control" placeholder="Thinking Skill" required value="<?php echo $row['thinking_skill'] ?>">
				</div>
			</div>
			<div class="col-md-4 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="social_skill" class="form-control" placeholder="Social Skill" required value="<?php echo $row['social_skill'] ?>">
				</div>
			</div>
			<div class="col-md-4 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="emotional_skill" class="form-control" placeholder="Emotional Skill" required value="<?php echo $row['emotional_skill'] ?>">
				</div>
			</div>
			<h2>ATTITUDE TOWARDS</h2>
			<div class="col-md-3 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="teachers" class="form-control" placeholder="Teachers" required value="<?php echo $row['teachers'] ?>">
				</div>
			</div>
			<div class="col-md-3 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="seniors" class="form-control" placeholder="Seniors" required value="<?php echo $row['seniors'] ?>">
				</div>
			</div>
			<div class="col-md-3 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="school_mates" class="form-control" placeholder="School Mates" required value="<?php echo $row['school_mates'] ?>">
				</div>
			</div>
			<div class="col-md-3 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="environment" class="form-control" placeholder="Environment" required value="<?php echo $row['environment'] ?>">
				</div>
			</div>
			<h2>ADDITIONAL SUBJECTS GRADE</h2>
			<div class="col-md-3 col-sm-6 col-xs-12">
				<div class="input-group mg-b-pro-edt">
					<input type="text" name="art" class="form-control" placeholder="Art" required value="<?php echo $row['art'] ?>">
				</div>
			</div>
			<div class="col-md-9">
				<div class="row">
					<div class="col-md-3 col-sm-6 col-xs-12">
						<div class="input-group mg-b-pro-edt">
							<input type="text" name="music" class="form-control" placeholder="Music" required value="<?php echo $row['music'] ?>">
						</div>
					</div>
					<div class="col-md-3 col-sm-6 col-xs-12">
						<div class="input-group mg-b-pro-edt">
							<input type="text" name="computer" class="form-control" placeholder="Computer" required value="<?php echo $row['computer'] ?>">
						</div>
					</div>
					<div class="col-md-3 col-sm-6 col-xs-12">
						<div class="input-group mg-b-pro-edt">
							<input type="text" name="spoken_english" class="form-control" placeholder="Spoken English" required value="<?php echo $row['spoken_english'] ?>">
						</div>
					</div>
					<div class="col-md-3 col-sm-6 col-xs-12">
						<div class="input-group mg-b-pro-edt">
							<input type="text" name="physical_activity" class="form-control" placeholder="Physical Activity" required value="<?php echo $row['physical_activity'] ?>">
						</div>
					</div>
				</div>
			</div>

			<div class="col-lg-12 col-md-6 col-sm-12 col-xs-12" style="padding-right: 30px;">

				<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>
		</form>