File: /var/www/nclive/technc/add_new_institutions.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 New Institute</h2>
<?php
if(isset($_REQUEST['submit'])){
$type=$_REQUEST['type'];
$name=$_REQUEST['uname'];
$stateid=$_REQUEST['state'];
$cityid=$_REQUEST['city'];
$pin=$_REQUEST['pincode'];
$longitude=$_REQUEST['longitude'];
$latitude=$_REQUEST['latitude'];
$emails=$_REQUEST['emails'];
$phones=$_REQUEST['phones'];
$weblink=$_REQUEST['link'];
$applylink=$_REQUEST['apply'];
$onlinefee=$_REQUEST['fee'];
$result=$_REQUEST['result'];
$other=$_REQUEST['other'];
$display=$_REQUEST['order'];
$status=$_REQUEST['status'];
$query="INSERT INTO sp_institutions set category_id='$type',institutions_name='$name',state_id='$stateid',city_id='$cityid',pincode='$pin',longitude='$longitude',latitude='$latitude',important_emails='$emails',important_phones='$phones',official_website_link='$weblink'
,online_apply_link='$applylink',online_fee_link='$onlinefee',result_link='$result'
,other_info='$other',display_order='$display',status='$status'";
$sql=$db->prepare($query);
$sql->execute();
$lastId=$db->lastInsertId();
"last insert id is" . $lastId;
$cou_name=$_REQUEST['cour'];
foreach($cou_name as $c){
$n=$db->prepare("insert into sp_institute_courses set institute_id='$lastId',course_id='$c'");
$n->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" id="form">
<div class="form-group">
<label class="col-md-2 control-label" for="val-select2">Category </label>
<div class="col-md-10">
<select class="js-select2 form-control" name="type" style="width: 100%;">
<?php
$cat=$db->prepare("select category_name,id from sp_institutions_category");
$cat->execute();
?>
<option selected="selected">--Select Category--</option>
<?php while($all=$cat->fetch()){
?>
<option value="<?php echo $all['id']; ?>"><?php echo $all['category_name']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username">Institutions Name<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="uname" placeholder="" required/>
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Select State<span class="text-danger">*</span></label>
<div class="col-md-10">
<select class="js-select2 form-control" id="type2" name="state" style="width: 100%;">
<?php
$sql = $db->prepare("SELECT state_id,state_name FROM sp_states");
$sql->execute();
?><option selected="selected">--Select State--</option><?php
while($row1=$sql->fetch(PDO::FETCH_ASSOC))
{
?>
<option value="<?php echo $row1['state_id']; ?>"><?php echo $row1['state_name']; ?></option>
<?php
} ?>
</select>
</div>
</div>
<div class="form-group" >
<label class="col-md-2 control-label" for="val-select2">Select City<span class="text-danger">*</span></label>
<div class="col-md-10">
<select name="city" class="form-control" id="city">
<option selected="selected">Select City</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Pin Code<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="pincode" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Longitude<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="longitude" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Latitude<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="latitude" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Important Emails<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="emails" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Important Phones<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="phones" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Official Website Link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="link" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Online Apply Link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="url" name="apply" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Online Fee Link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="fee" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Result link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="result" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Course name<span class="text-danger">*</span></label>
<div class="col-md-10">
<?php
$cou=$db->prepare("select id,course_name from sp_courses order by id asc");
$cou->execute();
while($row3=$cou->fetch(PDO::FETCH_ASSOC)){
?>
<div class="col-md-4"><input id="chk" class="form-control" type="checkbox" name="cour[]" value="<?php echo $row3['id']; ?>"><?php echo $row3['course_name']; ?>
</div>
<?php } ?>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Other Info<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="other" placeholder="" >
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Display Order<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="number" name="order" placeholder="" required/>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Status<span class="text-danger">*</span></label>
<div class="col-md-10">
<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-10 col-md-offset-2">
<button class="btn btn-lg 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/3.1.1/jquery.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.9/jquery.validate.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#type2").change(function()
{
var id=$(this).val();
var dataString = 'id='+ id;
$.ajax
({
type: "POST",
url: "get_city.php",
data: dataString,
cache: false,
success: function(html)
{
$("#city").html(html);
}
});
});
});
</script>
<?php include 'footer.php'; ?>
<!-- END Main Container -->