File: /var/www/nclive/technc/add_institutions_category.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"> Institute category</h2>
<?php
if(isset($_REQUEST['submit'])){
$category= $_REQUEST['category'];
$order= $_REQUEST['num'];
$stat=$_REQUEST['status'];
$query="INSERT INTO sp_institutions_category set category_name='$category',display_order='$order',status='$stat'";
$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-username">Category Name<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="text" name="category" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-confirm-password">Display order<span class="text-danger">*</span></label>
<div class="col-md-7">
<input class="form-control" type="number" name="num" placeholder="">
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="val-email">Status <span class="text-danger">*</span></label>
<div class="col-md-7">
<select name="status" class="form-control">
<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';
?>
<!-- END Main Container -->