
<div class="page-content">




<?php
include("common/sitemap.php");
?>                            <div class="container-fluid">
                                


<div data-widget-group="group1">

<div class="row">
		<div class="col-md-12">
			<div class="alert alert-info mb-xl" style="height:220px">
				<h3>Add Course</h3>
<div class="form-group"><form action="action-pages/add-course-action.php" method="post">
					
					<div class="col-md-12">
					<div class="col-sm-4">
						<select name="department" class="form-control">
						<option value="">SELECT DEPARTMENT</option>
						<?php 
						$GetDepart = mysql_query("SELECT * FROM `sgvu_departments` ORDER BY `sgvu_departments`.`department_name` ASC");
						while($GetDepart1 = mysql_fetch_assoc($GetDepart))
						{
						?>
						<option value="<?php echo $GetDepart1['department_id']; ?>"><?php echo $GetDepart1['department_name']; ?></option>
						<?php } ?>
						</select>
					</div>
					<div class="col-sm-4">
						<select name="coursetype" class="form-control" required>
						<option value="">SELECT COURSE TYPE</option>
						<?php 
						$GetCourseType = mysql_query("SELECT * FROM `sgvu_coursetype` ORDER BY `sgvu_coursetype`.`id` ASC");
						while($GetCourseType1 = mysql_fetch_assoc($GetCourseType))
						{
						?>
						<option value="<?php echo $GetCourseType1['id']; ?>"><?php echo $GetCourseType1['coursetype']; ?></option>
						<?php } ?>
						</select>
					</div>
					
					<div class="col-sm-4">
						<input type="text" class="form-control" name="coursename" placeholder="Enter Course Name" required/>
					</div>

					</div>
						
<div class="col-md-12" style="padding-top:8px">
<div class="col-sm-4">
						<input type="text" class="form-control" name="coursecode" placeholder="Enter Course Code"/>
					</div>
					<div class="col-sm-4">
						<input type="text" class="form-control" name="course_intake" placeholder="Enter Course Intake"/>
					</div>
					<div class="col-sm-4">
						<input type="text" class="form-control" name="course_duration" placeholder="Enter Course Duration (In years)"/>

				</div>
</div>

<div class="col-md-12" style="padding-top:8px"><div class="col-sm-4">
<button class="btn-primary btn" type="submit">Add Course</button>&nbsp;&nbsp;&nbsp;<button class="btn-primary btn" type="reset">Reset</button>	</div></div>
</form>
<br /><br />


				</div>			</div>
		</div>
	</div>

	
	
	<div class="row">
	
	
		<div class="col-md-12">
			<div class="panel panel-default">
				<div class="panel-heading">
					<h2>Department List</h2>
					<div class="panel-ctrls"></div>
				</div>
				<div class="panel-body no-padding">
					<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
						<thead>
							<tr>
								<th width="3%" height="28">S.No.</th>
								<th width="8%">Course Code</th>
								<th width="25%">Course</th>
								<th width="26%">Department</th>
								<th width="13%">Course Type</th>
								<th width="7%">Course Intake</th>
								<th width="7%">Course Duration</th>
								<th width="11%">Action</th>
							</tr>
						</thead>
						<tbody>
							
						<?php
						$GetCourseDe = mysql_query("SELECT * FROM `sgvu_courses` ORDER BY `sgvu_courses`.`coursename` ASC");
						while($GetCourseDe1 = mysql_fetch_assoc($GetCourseDe))
						{
						$s =$_REQUEST['v'];

						$u = $s+0;

						?>
							
						<tr>
								<td width="3%" height="28" align="center"><?php echo $_REQUEST['v'] = $u+1; ?></td>
								<td width="8%"><?php echo $GetCourseDe1['course_code']; ?></td>
								<td width="25%"><?php echo $GetCourseDe1['coursename']; ?></td>
								<td width="26%"><?php 
								$getdept = mysql_query("SELECT * FROM `sgvu_departments` WHERE `department_id` = '$GetCourseDe1[department]'");
								$getdept1 = mysql_fetch_assoc($getdept);
								echo $getdept1['department_name'];
								 ?></td>
								<td width="13%" height="28" align="center"><?php  
								$getcoutype = mysql_query("SELECT * FROM `sgvu_coursetype` WHERE `id` = '$GetCourseDe1[course_type]'");
								$getcoutype1 = mysql_fetch_assoc($getcoutype);
								echo $getcoutype1['coursetype'];
								?></td>
								<td width="7%"><?php echo $GetCourseDe1['intake']; ?></td>
						  <td width="7%"><?php echo $GetCourseDe1['duration']; ?> Years</td>
						  <td width="11%">Edit Delete</td>						  
						</tr>
						<?php
						}
						?>	   
						
							
						</tbody>
					</table>
				</div>
				<div class="panel-footer"></div>
			</div>
		</div>
	</div>
	
	
	

	
	
	
	
	
</div>
                            </div> <!-- .container-fluid -->
                        </div>
						
						<script type="text/javascript" src="assets/js/jquery-1.10.2.min.js"></script> 							<!-- Load jQuery -->
<script type="text/javascript" src="assets/js/jqueryui-1.10.3.min.js"></script> 							<!-- Load jQueryUI -->
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script> 								<!-- Load Bootstrap -->
<script type="text/javascript" src="assets/js/enquire.min.js"></script> 									<!-- Load Enquire -->

<script type="text/javascript" src="assets/plugins/velocityjs/velocity.min.js"></script>					<!-- Load Velocity for Animated Content -->
<script type="text/javascript" src="assets/plugins/velocityjs/velocity.ui.min.js"></script>

<script type="text/javascript" src="assets/plugins/wijets/wijets.js"></script>     						<!-- Wijet -->

<script type="text/javascript" src="assets/plugins/codeprettifier/prettify.js"></script> 				<!-- Code Prettifier  -->
<script type="text/javascript" src="assets/plugins/bootstrap-switch/bootstrap-switch.js"></script> 		<!-- Swith/Toggle Button -->

<script type="text/javascript" src="assets/plugins/bootstrap-tabdrop/js/bootstrap-tabdrop.js"></script>  <!-- Bootstrap Tabdrop -->

<script type="text/javascript" src="assets/plugins/iCheck/icheck.min.js"></script>     					<!-- iCheck -->

<script type="text/javascript" src="assets/plugins/nanoScroller/js/jquery.nanoscroller.min.js"></script> <!-- nano scroller -->

<script type="text/javascript" src="assets/js/application.js"></script>
<script type="text/javascript" src="assets/demo/demo.js"></script>
<script type="text/javascript" src="assets/demo/demo-switcher.js"></script>

<script type="text/javascript" src="assets/plugins/datatables/jquery.dataTables.js"></script>
<script type="text/javascript" src="assets/plugins/datatables/dataTables.bootstrap.js"></script>
<script type="text/javascript" src="assets/demo/demo-datatables.js"></script>
