<?php include 'header.php'; ?>

<?php include 'sidebar.php'; ?>


<div id="page-wrapper">

    <div class="container-fluid">

		<br/>

         <div class="row">

             <div class="col-lg-12">
				<div class="panel panel-default dash">
					<div class="panel panel-primary">
						<div class="panel-heading">
							<h2 class="sub-header">
								<i class="fa fa-book-reader" aria-hidden="true"></i> <?php echo lang('SUBJECTS');?>
							</h2>
						</div>
						<!-- /.panel-heading -->
						<div class="panel-body">
							<div class="table-responsive">
							
								<div class="col-md-12">

									<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" class="form-horizontal" name="newservice">
										<fieldset>
											<?php $csrf->echoInputField(); ?>

											<!-- Text input -->
											<div class="form-group">
												<label class="col-md-2 control-label" for="college_type"><?php echo lang('COURSE_NAME');?></label>
												<div class='col-md-6'>
													<select class="form-control input-md" name="college_type">
													  <option value="<?php
														global $conection;
														$sql = mysqli_query($conection,"select main_course_name from main_course");
														$row = mysqli_fetch_assoc($sql);
														echo $row['main_course_name'];
													?>">
														<?php echo listCourseLists(); ?>
													</select>
												</div>
											</div>

											
											<!-- Text input-->
											<div class="form-group">
												<label class="col-md-2 control-label" for="courseName"><?php echo lang('SUBJECT');?></label>
												<div class="col-md-6">
													<input id="courseName" name="courseName" type="text" class="form-control input-md" required>
												</div>
											</div>


											<!-- Button -->
											<div class="form-group">
												<label class="col-md-10 control-label" for="singlebutton"></label>
												<div class="col-md-2">
													<input type="submit" name="newservice" class="btn save btn-primary" value="<?php echo lang('SAVE');?>" />
												</div>
											</div>

										</fieldset>
									</form>



									<?php

										// Se o usuário clicou no botão cadastrar efetua as ações
										if (!empty($_POST['newservice']))
										 {
											global $conection;
											
											$college_type = mysqli_real_escape_string($conection, $_POST['college_type']);
											$courseName = mysqli_real_escape_string($conection, $_POST['courseName']);

													// Insere os dados no banco
												$sql = mysqli_query($conection,"INSERT INTO courses VALUES ('', '".$college_type."', '".$courseName."',  '1')");

					
													// Se os dados forem inseridos com sucesso			
													if (!$sql) {
													echo ("Can't insert into database: " . mysqli_error());
													return false;
													} else {
													echo "<script type='text/javascript'>swal('".lang('NICE')."', '".lang('SUBJECT_ADDED')."', 'success');</script>";
															echo '<meta http-equiv="refresh" content="1; subjects.php">'; 
															die();
													}		
													return true;

												// Se houver mensagens de erro, exibe-as
												if (count($error) != 0) {
													foreach ($error as $erro) {
														echo $erro . "<br />";
													}
												}

										}
	
										?>

								</div>    
							</div>
						</div>
					</div>
				</div>
			</div>
        </div>
        <!-- /.row -->

        <div class="copyright">
            <p>© Copyright 2019  &nbsp;&nbsp;|&nbsp;&nbsp; All Rights Reserved Powered by 
            <a href="http://www.bluelinecomputers.com/" target="_blank">Blueline Computers</a></p>
        </div>
    
    </div>
    <!-- /.container-fluid -->

</div>
<!-- /#page-wrapper -->

</div>
<!-- /#wrapper -->

<?php include 'footer.php'; ?>