File: /var/www/nclive/technc/add_institute_courses.php
<?php include 'header.php'; ?>
<!-- Main Container -->
<main id="main-container">
<div class="content content-narrow">
<!-- Forms Row -->
<div class="row">
<div class="col-lg-12">
<!-- Bootstrap Forms Validation -->
<h2 class="content-heading">Add Institute</h2>
<?php
if(isset($_REQUEST['submit'])){
$course= $_REQUEST['course'];
$course_code= $_REQUEST['code'];
$order=$_REQUEST['order'];
$status=$_REQUEST['status'];
$query="INSERT INTO sp_courses set course_name='$course',course_code='$course_code',display_order='$order',status='$status'";
$sql=$db->prepare($query);
if($sql->execute()){
echo '<h3 style="color:green;">Data submit successfully</h3>';
}
}
?>
<div class="block">
<div class="block-header">
<ul class="block-options">
<li>
<button type="button"><i class="si si-settings"></i></button>
</li>
</ul>
<h3 class="block-title"></h3>
</div>
<div class="block-content block-content-narrow">
<!-- jQuery Validation (.js-validation-bootstrap class is initialized in js/pages/base_forms_validation.js) -->
<!-- For more examples you can check out https://github.com/jzaefferer/jquery-validation -->
<form class="js-validation-bootstrap form-horizontal" action="" method="post" enctype="multipart/form-data" id="form">
<div class="form-group">
<label class="col-md-4 control-label" for="val-select2">Course Name</label>
<div class="col-md-7">
<input type="hidden" name="id" id="id">
<input type="text" class="form-control" name="course" placeholder="Enter Course Name">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Course Code<span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="text" class="form-control" name="code" placeholder="Enter Course Code">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Display Order <span class="text-danger">*</span></label>
<div class="col-md-7">
<input type="number" class="form-control" name="order" placeholder="Enter display order">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Status<span class="text-danger">*</span></label>
<div class="col-md-7">
<select class="form-control" name="status">
<option value="1">Active</option>
<option value="0">Deactive</option>
</select>
</div>
</div>
<div class="form-group">
<div class="col-md-8 col-md-offset-4">
<button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
</div>
</div>
</form>
</div>
</div>
<!-- Bootstrap Forms Validation -->
</div>
</div>
</div>
<!-- END Forms Row -->
</div>
<!-- END Page Content -->
</main>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js"></script>
<script type="text/javascript">
(function ($, W, D)
{
var JQUERY4U = {};
JQUERY4U.UTIL =
{
setupFormValidation: function ()
{
//form validation rules
$("#form").validate({
rules: {
category: {
required: true,
},
img: {
required: true,
},
num: {
required: true,
}
},
messages: {
category: "Please Enter Category name",
img: "Please upload an image icon",
num: "Please Enter order number",
},
submitHandler: function (form) {
form.submit();
}
});
}
}
//when the dom has loaded setup form validation rules
$(D).ready(function ($) {
JQUERY4U.UTIL.setupFormValidation();
});
})(jQuery, window, document);
</script>
<?php include 'footer.php';
?>