File: /var/www/nclive/technc/kvs_navodya.php
<?php include 'header.php';
include '../wp-config.php';
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
// domain for creating post page
$host = $_SERVER['SERVER_NAME'];
$curDate = date('Y-m-d H:i:s');
$user_id = 1;
$message = '';
include('function.php'); // to make new post page
// table names
$POST_TABLE = 'naukri_wp_posts';
$TABLE_POSTMETA = 'naukri_wp_postmeta';
$TABLE_YOAST_INDEXABLE = 'naukri_wp_yoast_indexable';
$TABLE_KVS_NVS = 'sp_kvs_navodya';
if (isset($_REQUEST['submit'])) {
$type = $_REQUEST['type'];
$post_title = $_REQUEST['uname'];
$post_name = $_REQUEST['url_slug'];
$post_parent = $_REQUEST['parent_category'];
$post_content = $_REQUEST['shortcode'];
$stateid = $_REQUEST['state'];
$cityid = $_REQUEST['city'];
$pin = $_REQUEST['pincode'];
$address = $_REQUEST['add'];
$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'];
$guide = $_REQUEST['guide'];
$detail = $_REQUEST['details'];
$meta_title = $_REQUEST['metaTitle'];
$meta_key = $_REQUEST['metafkeyword'];
$meta_keyword = $_REQUEST['metaKeyword'];
$meta_desc = $_REQUEST['metaDesc'];
$exist_page = $db->prepare("SELECT count(ID) as countId FROM $POST_TABLE WHERE post_name = '" . $post_name . "' AND post_status='publish'");
$exist_page->execute();
$check_page = $exist_page->fetch(PDO::FETCH_ASSOC);
if ($check_page['countId'] == 0) {
$post_id = createPostPages($post_title, $post_content, $post_name, $user_id, $post_parent, $host);
// yoast seo data table and post meta
if ($post_id != '') {
update_post_meta($post_id, '_yoast_wpseo_title', $meta_title);
update_post_meta($post_id, '_yoast_wpseo_focuskw', $meta_key);
update_post_meta($post_id, '_yoast_wpseo_metadesc', $meta_desc);
update_post_meta($post_id, '_yoast_wpseo_metakeywords', $meta_keyword);
}
$query = "INSERT INTO $TABLE_KVS_NVS set type='$type',name='$post_title', url_slug='$post_name', state_id='$stateid',city_id='$cityid',pincode='$pin',address='$address',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', addmission_guidelines='$guide',addmission_details='$detail'";
$sql = $db->prepare($query);
if ($sql->execute()) {
$message = '<div class="alert alert-success"> <strong>Data submit successfully</strong></div>';
} else {
$message = '<div class="alert alert-danger"><strong>Error in page creation </strong></div>';
}
} else {
$message = '<div class="alert alert-danger"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">x</button> <strong>Page Already Exist. Enter other name. </strong></div>';
}
}
?>
<!-- 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 KVS/NVS Navodya</h2>
<?php echo $message; ?>
<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"> Type </label>
<div class="col-md-10">
<select class="js-select2 form-control" name="type" id="school_type" style="width: 100%;" onchange="changeType(this.value)">
<option value="kvs"> KVS </option>
<option value="nvs"> NVS </option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-parent_category">Select Post Parent Category<span class="text-danger">*</span></label>
<div class="col-md-10">
<select class="js-select2 form-control" name="parent_category" id="parent_category" style="width: 100%;">
<?php
$sql4 = $db->prepare("SELECT ID, post_title FROM $POST_TABLE WHERE post_status='publish' and post_name IN ('kvs','nvs')");
$sql4->execute(); ?>
<?php while ($row = $sql4->fetch(PDO::FETCH_ASSOC)) { ?>
<option value="<?php echo $row['ID']; ?>"><?php echo $row['post_title']; ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-shortcode">Shortcode</label>
<div class="col-md-10">
<input class="form-control" type="text" name="shortcode" id="shortcode" value="[shortcode_kvs_detail]" placeholder="" readonly="readonly">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-username">Name<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="uname" placeholder="" onkeyup="convertToSlug(this.value)" onload="convertToSlug(this.value)" />
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-url_slug">URL Slug<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="url_slug" id="post_slug" placeholder="" readonly="readonly" />
</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 order by state_name asc");
$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">Address<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="add" 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="metaTitle"> Meta Title</label>
<div class="col-md-10">
<input class="form-control" type="text" name="metaTitle" placeholder="Enter Meta Title">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="metafkeyword">Meta Focus Keyword</label>
<div class="col-md-10">
<input class="form-control" type="text" name="metafkeyword" placeholder="Enter Meta Focus Keyword">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="metaKeyword">Meta Keyword</label>
<div class="col-md-10">
<input class="form-control" type="text" name="metaKeyword" placeholder="Enter Meta Keyword">
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="metaDesc">Meta Description</label>
<div class="col-md-10">
<input class="form-control" type="text" name="metaDesc" placeholder="Enter Meta Description">
</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">Admission Guidelines Link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="guide" placeholder="" value="https://www.kvsangathan.nic.in/sites/default/files/hq/Adm-Guideline_2018_19.PDF" />
</div>
</div>
<div class="form-group">
<label class="col-md-2 control-label" for="val-password">Admission Details Link<span class="text-danger">*</span></label>
<div class="col-md-10">
<input class="form-control" type="text" name="details" 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="" value="https://kvsonlineadmission.in/instruction.html" />
</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="" value="https://epay.unionbankofindia.co.in/kvfee/" />
</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">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="" />
</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>
<script>
// change shortcode slug as per select type
function changeType(type) {
if (type == 'kvs') {
document.getElementById("shortcode").value = "[shortcode_kvs_detail]";
document.getElementById("parent_category").innerHTML = "<option value='546'>KVS</option>";
} else if (type == 'nvs') {
document.getElementById("shortcode").value = "[shortcode_nvs_detail]";
document.getElementById("parent_category").innerHTML = "<option value='548'>NVS</option>";
// document.getElementById("parent_category").selectedIndex = type;
}
}
// to make slug from post name
function convertToSlug(str) {
str = str.replace(/[`~!@#$%^&*()_\-+=\[\]{};:'"\\|\/,.<>?\s‘’//]/g, ' ').toLowerCase(); //replace all special characters | symbols with a space
str = str.replace(/^\s+|\s+$/gm, ''); // trim spaces at start and end of string
str = str.replace(/\s+/g, '-'); // replace space with dash/hyphen
document.getElementById("post_slug").value = str;
}
</script>
<?php include 'footer.php'; ?>
<!-- END Main Container -->