<?php  
$page_title = 'Student List';
include 'header.php';
?>
<div class="content-wrapper">
	<section class="content mt-4">
		<div class="container-fluid">
			<div class="row">
				<div class="col-md-12">
					<?php include('alert-msg.php'); ?>
					<div class="card card-primary">
						<div class="card-header">
							<h3 class="card-title"><?php echo $page_title; ?></h3>
						</div>
						<form action="student-list-update.php" method="POST" enctype="multipart/form-data">
							<div class="card-body">
							    <div class="row">
									<div class="col-md-4">
										<div class="form-group">
											<label>Class</label>
											<select class="form-control select2" name="class">
												<option value="">--All--</option>
												<?php
												$sel_class=mysqli_query($con,"SELECT DISTINCT Class FROM `DimStudent_Table` Where Class != ''");
												while($row_class=mysqli_fetch_array($sel_class))
												{
												?>
												<option value="<?php echo $row_class['Class']; ?>"><?php echo $row_class['Class']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
        									
									<div class="col-md-4">
										<div class="form-group">
											<label>Division</label>
											<select class="form-control select2" name="division">
												<option value="">--All--</option>
												<?php
												$sel_division=mysqli_query($con,"SELECT DISTINCT Division FROM `DimStudent_Table` where Division != ''");
												while($row_division=mysqli_fetch_array($sel_division))
												{
												?>
												<option value="<?php echo $row_division['Division']; ?>"><?php echo $row_division['Division']; ?></option>
												<?php
												}
												?>
											</select>
										</div>
									</div>
									
									<div class="col-md-4">
										<div class="form-group">
											<label>Search</label>
											<input type="text" class="form-control" name="search" />
										</div>
									</div>
        						</div>
        							<div class="row">
									<div class="col-lg-4">
										<div class="form-group">
											<label>View / Update Field</label>
											<select class="form-control"  name="fields[]" multiple size="8" required>
												<?php
												$sql = "SHOW COLUMNS FROM DimStudent_Table where Field != 'Student_ID'";
												    $result = mysqli_query($con,$sql);
    												while($data = mysqli_fetch_array($result)) 		
    												{
    													?> 
    													<option  value="<?php echo $data['Field']; ?>"><?php echo $data['Field']; ?></option>
    													<?php
    												}
												?>
											</select>
										</div>
									</div>
								</div>
								<button type="submit" class="btn btn-primary" name="btnSubmit">Submit</button>
							</div>
						</form>
					</div>
				</div>
			</div>
		</div>
	</section>
</div>
<?php include 'footer.php'; ?>