1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / ipuadmission / public_html / superadmin /
Filename : 1.php
back
<?php
ob_start();
session_start();
include('include/connection.php');


$emailid=$_SESSION['emailid'];

$adminid=$_SESSION['id'];

$per=mysqli_query($conn,"select * from admin where id='".$adminid."'");
$perq1=mysqli_fetch_array($per);

if (!(isset($_SESSION['emailid']) && $_SESSION['emailid'] != '')) {

header ("Location: index.php");

}



?>


<!DOCTYPE html>
<html lang="en">


<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=0,minimal-ui">
    <title>IPU - Add Listing Data </title>
    <meta content="Admin Dashboard" name="description">
    <meta content="Themesbrand" name="author">
    <link rel="shortcut icon" href="assets/images/favicon.ico">
    <link href="assets/css/bootstrap.min.css" rel="stylesheet" type="text/css">
    <link href="assets/css/metismenu.min.css" rel="stylesheet" type="text/css">
    <link href="assets/css/icons.css" rel="stylesheet" type="text/css">
    <link href="assets/css/style.css" rel="stylesheet" type="text/css">
	
	
	<script>

 
 function showsubcategory123(str)
{
//alert('str');
		  if (window.XMLHttpRequest)
		  {// code for IE7+, Firefox, Chrome, Opera, Safari
		  xmlhttp=new XMLHttpRequest();
		  }
		else
		  {// code for IE6, IE5
		  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
		  }
		  if (xmlhttp!=''){ 
	 document.getElementById("showsubcatdiv123").innerHTML='<img src="images/loader.gif">';
  }
			var url="show_subcategory.php";
			url=url+"?category_id="+str;
			xmlhttp.open("GET",url,true);	
			xmlhttp.send();	
			//alert(url);
//alert(url);
		  xmlhttp.onreadystatechange=function(){
				if (xmlhttp.readyState==4)
				{ 
					document.getElementById("showsubcatdiv123").innerHTML=xmlhttp.responseText;
				}
		   }	
}		
 
 


</script>



<script>

 
 function showsubcategory1234(str)
{
//alert('str');
		  if (window.XMLHttpRequest)
		  {// code for IE7+, Firefox, Chrome, Opera, Safari
		  xmlhttp=new XMLHttpRequest();
		  }
		else
		  {// code for IE6, IE5
		  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
		  }
		  if (xmlhttp!=''){ 
	 document.getElementById("showsubcatdiv1234").innerHTML='<img src="images/loader.gif">';
  }
			var url="show_subtosubcategory.php";
			url=url+"?subcategory_id="+str;
			xmlhttp.open("GET",url,true);	
			xmlhttp.send();	
			//alert(url);
//alert(url);
		  xmlhttp.onreadystatechange=function(){
				if (xmlhttp.readyState==4)
				{ 
					document.getElementById("showsubcatdiv1234").innerHTML=xmlhttp.responseText;
				}
		   }	
}		
 
 


</script>


<script>
function showcategory(str)
{
//alert('str');
		  if (window.XMLHttpRequest)
		  {// code for IE7+, Firefox, Chrome, Opera, Safari
		  xmlhttp=new XMLHttpRequest();
		  }
		else
		  {// code for IE6, IE5
		  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
		  }
		  if (xmlhttp!=''){ 
	 document.getElementById("showcatdiv").innerHTML='<img src="images/loader.gif">';
  }
			var url="subcityadd.php";
			url=url+"?state_id="+str;
			xmlhttp.open("GET",url,true);	
			xmlhttp.send();	
			//alert(url);
//alert(url);
		  xmlhttp.onreadystatechange=function(){
				if (xmlhttp.readyState==4)
				{ 
					document.getElementById("showcatdiv").innerHTML=xmlhttp.responseText;
				}
		   }	
}

</script>


<script>
function showcategory123(str)
{
//alert('str');
		  if (window.XMLHttpRequest)
		  {// code for IE7+, Firefox, Chrome, Opera, Safari
		  xmlhttp=new XMLHttpRequest();
		  }
		else
		  {// code for IE6, IE5
		  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
		  }
		  if (xmlhttp!=''){ 
	 document.getElementById("showcatdiv123").innerHTML='<img src="images/loader.gif">';
  }
			var url="subtosubcity.php";
			url=url+"?city_id="+str;
			xmlhttp.open("GET",url,true);	
			xmlhttp.send();	
			//alert(url);
//alert(url);
		  xmlhttp.onreadystatechange=function(){
				if (xmlhttp.readyState==4)
				{ 
					document.getElementById("showcatdiv123").innerHTML=xmlhttp.responseText;
				}
		   }	
}

</script>


<script src="https://cdn.ckeditor.com/4.14.0/standard/ckeditor.js"></script>

</head>

<body>
    <!-- Begin page -->
    <div id="wrapper">
        <!-- Top Bar Start -->
         <?php include('include/top-header.php');?>
        <!-- Top Bar End -->
        <!-- ========== Left Sidebar Start ========== -->
        <div class="left side-menu">
            <?php include('include/left-menu.php');?>
            <!-- Sidebar -left -->
        </div>
        <!-- Left Sidebar End -->
        <!-- ============================================================== -->
        <!-- Start right Content here -->
        <!-- ============================================================== -->
        <div class="content-page">
            <!-- Start content -->
            <div class="content">
                <div class="container-fluid">
                    <div class="page-title-box">
                        <div class="row align-items-center">
                            <div class="col-sm-10">
                                <h4 class="page-title">College Listing Management</h4>
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                                    <li class="breadcrumb-item active">Add Listing College Listing</li>
                                </ol>
                            </div>
                            <div class="col-sm-2">
                               



                            </div>
                        </div>
                    </div>
                    <!-- end row -->
                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">
                                    <h4 class="mt-0 header-title"><i class="ti-agenda text-primary mr-2"></i>Add Listing Data</h4>
                                    <p class="text-muted m-b-30"></p>
									
									
									<p class="text-muted m-b-30"></p>
									
<?php


if(isset($_POST['submit']))
	{
		
date_default_timezone_set('Asia/Kolkata');

function string_limit_words($string, $word_limit) {
   $words = explode(' ', $string);
   return implode(' ', array_slice($words, 0, $word_limit));
}		
		

$category_id=$_POST['category_id'];
$category=mysqli_query($conn,"SELECT * FROM category where category_id='$category_id'");
$category1=mysqli_fetch_array($category);
$category_name=$category1['url'];	

$subcategory_id=$_POST['subcategory_id'];
$subcategoryff=mysqli_query($conn,"SELECT * FROM subcategory where subcategory_id='$subcategory_id'");
$subcategoryff1=mysqli_fetch_array($subcategoryff);
$subcategory_name=$subcategoryff1['url'];

	

$state_id = $_POST['state_id'];
$state=mysqli_query($conn,"SELECT * FROM state where state_id='$state_id'");
$state1=mysqli_fetch_array($state);
$state_name=$state1['url'];	


$city_id = $_POST['city_id'];
$city=mysqli_query($conn,"SELECT * FROM city where city_id='$city_id'");
$city1=mysqli_fetch_array($city);
$city_name=$city1['url'];



$subcity_id = $_POST['subcity_id'];
$subcity=mysqli_query($conn,"SELECT * FROM subcity where subcity_id='$subcity_id'");
$subcity1=mysqli_fetch_array($subcity);
$subcity_name=$subcity1['url'];
	

$meta_title=addslashes($_POST['meta_title']);
$meta_description=addslashes($_POST['meta_description']);
$meta_keyword=addslashes($_POST['meta_keyword']);


$college_info=addslashes($_POST['college_info']);
$courses_fees=addslashes($_POST['courses_fees']);
$admissions=addslashes($_POST['admissions']);
$Cut_off=addslashes($_POST['Cut_off']);
$placements=addslashes($_POST['placements']);





$status = $_POST['status'];
	
$postdate=date("F d, Y");
$posttime=date("h:i:sa");

$status1 = "0";

$date=date("Y/m/d");
$time=date("h:i:s");
	
	

	//echo "INSERT INTO postlisting VALUES (NULL,'".$state_name."','".$city_name."','".$subcity_name."','".$category_name."','".$subcategory_name."','".$meta_title."','".$meta_description."','".$meta_keyword."','".$college_info."','".$courses_fees."','".$admissions."','".$Cut_off."','".$placements."','".$placements."','".$status."','".$postdate."','".$posttime."','".$status1."','".$date."','".$time."','".$url."')";
//echo "<pre>";
//die('Texting');	

	
$ins=mysqli_query($conn,"INSERT INTO postlisting VALUES (NULL,'".$state_name."','".$city_name."','".$subcity_name."','".$category_name."','".$subcategory_name."','".$meta_title."','".$meta_description."','".$meta_keyword."','".$college_info."','".$courses_fees."','".$admissions."','".$Cut_off."','".$placements."','".$status."','".$postdate."','".$posttime."','".$status1."','".$date."','".$time."')");


		
		if($ins==TRUE)
		{
			?><script type="text/javascript">
			//alert("Data Inserted Successfully");
			window.location='college-listing.php';
			</script><?php
		}
		else
		{	?><script type="text/javascript">
			alert("Error! Data Not Updated");
			//window.location='list-of-postlistingdata.php';
			</script><?php echo mysql_error();
		}
	}
	
	


?>									
									
<form action="" method="post" enctype="multipart/form-data" class="form-horizontal" >



<div class="col-12">
    <div class="card">
        <div class="card-body">
		
		<div class="card">
        <div class="card-body">
            <h4 class="mt-0 header-title">Course & Colleges Data</h4>
			<hr />
            <p class="text-muted m-b-30"></p>
			
			
			
			
			<div class="form-group row">
			<label for="example-password-input" class="col-sm-2 col-form-label">Course</label>
                <div class="col-sm-10">
				<select name="category_id" class="form-control" id="category_id"  onChange="showsubcategory123(this.value)">
<option value="">Select Course</option>
<?php

		$sel=mysqli_query($conn,"SELECT * FROM category order by category_id asc");
				while($result=mysqli_fetch_array($sel)){
				
		?>
		<option value="<?php echo $result['category_id']; ?>"><?php echo $result['category_name'];?></option>
		
		<?php } ?>
</select>
				</div>
            </div>
			
            
            
            
			
			<div class="form-group row">
			<label for="example-search-input" class="col-sm-2 col-form-label">Specialisation</label>
                <div class="col-sm-10">
				<div id="showsubcatdiv123">
             <select name="subcategory_id" class="form-control" id="subcategory_id" onChange="showsubcategory1234(this.value)">
<option value="">Select Specialisation </option>
</select>

			</div>
				</div>
            </div>
			
			
			<div class="form-group row">
			<label for="example-search-input" class="col-sm-2 col-form-label">Colleges</label>
                <div class="col-sm-10">
				<div id="showsubcatdiv1234">
             <select name="subtosubcategory_id" class="form-control" id="subtosubcategory_id">
<option value="">Select Colleges</option>
</select>

			</div>
				</div>
            </div>
			
			
			</div>
			</div>
			
			
			<div class="card">
        <div class="card-body">
		
			<p class="text-muted m-b-30"></p>
			<h4 class="mt-0 header-title">State , City & Sub City </h4>
			<hr />
            <p class="text-muted m-b-30"></p>
			
			<div class="form-group row"><label for="example-password-input" class="col-sm-2 col-form-label">State</label>
                
				<div class="col-sm-10">
				<select name="state_id" class="form-control" onChange="showcategory(this.value)">
						<option value="">Please Select List of States</option>
						<?php

						$sel=mysqli_query($conn,"SELECT * FROM state order BY state_id ASC");
						while($result=mysqli_fetch_array($sel)){
						?>
						<option value="<?php echo $result['state_id']; ?>"><?php echo $result['state_name'];?></option>
						<?php
						}
						?>
						</select>
				</div>
            </div>
			
			
			
			<div class="form-group row"><label for="example-password-input" class="col-sm-2 col-form-label">City</label>
                
				<div class="col-sm-10">
				<div id="showcatdiv">
<select name="city_id" class="form-control">
<option value="">Please Select List of City</option>
</select>
</div>
				</div>
            </div>
			
			<div class="form-group row"><label for="example-password-input" class="col-sm-2 col-form-label">Sub City</label>
                
				<div class="col-sm-10">
				<div id="showcatdiv123">
<select name="subcity_id" class="form-control">
<option value="">Please Select List of Sub City</option>
</select>
</div>
				</div>
            </div>
				</div>
			</div>
			
			
			
			<div class="card">
        <div class="card-body">
		
		
			 <p class="text-muted m-b-30"></p>
			<h4 class="mt-0 header-title">Colleges Information</h4>
			<hr />
			
						
			
            <div class="form-group row"><label for="example-url-input" class="col-sm-2 col-form-label">College Info</label>
                <div class="col-sm-10">
				
				
				
				<textarea name="college_info" id="editor2" class="form-control" placeholder="Shifting Solution"></textarea>
				
				</div>
            </div>
			
			
			<div class="form-group row"><label for="example-url-input" class="col-sm-2 col-form-label">Courses & Fees</label>
                <div class="col-sm-10">
				
				
				
				<textarea name="courses_fees" id="editor3" placeholder="Best Way to Choose Right Company"></textarea>
				
				</div>
            </div>
			
			<div class="form-group row"><label for="example-url-input" class="col-sm-2 col-form-label">Admissions</label>
                <div class="col-sm-10">
				
				
				
				<textarea name="admissions" id="editor4" class="form-control" placeholder="Our Services"></textarea>
				
				</div>
            </div>
			
			
			<div class="form-group row"><label for="example-url-input" class="col-sm-2 col-form-label">Cut-off</label>
                <div class="col-sm-10">
				
				
				
				<textarea name="Cut_off" id="editor5" class="form-control" placeholder="FAQ"></textarea>
				
				</div>
            </div>
			
			<div class="form-group row"><label for="example-url-input" class="col-sm-2 col-form-label">Placements</label>
                <div class="col-sm-10">
				
				
				
				<textarea name="placements" id="editor1" class="form-control" placeholder="FAQ"></textarea>
				
				</div>
            </div>
			
		
			
			</div>
			</div>
			
			
			
		 
		 
			
			<div class="card">
        <div class="card-body">
			
			<p class="text-muted m-b-30"></p>
			<h4 class="mt-0 header-title">SEO Management</h4>
			<hr />
			
			<div class="form-group row"><label for="example-password-input" class="col-sm-2 col-form-label">Your Meta Title</label>
                <div class="col-sm-10"><input class="form-control" type="text" name="meta_title" placeholder="Meta Title" /></div>
            </div>
			
			<div class="form-group row"><label for="example-password-input" class="col-sm-2 col-form-label">Your Meta keywords</label>
                <div class="col-sm-10"><input class="form-control" type="text" name="meta_keyword" placeholder="Meta keywords" /></div>
            </div>
			
			<div class="form-group row"><label for="example-password-input" class="col-sm-2 col-form-label">Your Meta Description</label>
                <div class="col-sm-10"><textarea required="" name="meta_description" class="form-control" placeholder="Meta Description" rows="3"></textarea></div>
            </div>
            
            
           
            
			
			</div>
			</div>
			
			<div class="card">
        <div class="card-body">
			<p class="text-muted m-b-30"></p>
			<h4 class="mt-0 header-title">Status</h4>
			<hr />
			
            <div class="form-group row"><label for="example-url-input" class="col-sm-2 col-form-label">Status</label>
                <div class="col-sm-10">
				
				
				<select class="form-control select2" name="status">
				<option value="">Status</option>
				<option value="1">Active</option>
				<option value="0">In Active</option>
				
				</select>
				</div>
            </div>
            </div>
			</div>
            <div class="form-group row"><label for="example-text-input-sm" class="col-sm-2 col-form-label"></label>
                <div class="col-sm-10"><button type="submit" class="btn btn-success waves-effect waves-light" name="submit">Submit</button></div>
            </div>
        </div>
    </div>
</div>	

</form>
								
                                </div>
                            </div>
                        </div>
                        <!-- end col -->
                    </div>
                    <!-- end row -->
                </div>
                <!-- container-fluid -->
            </div>
            <!-- content -->
           <?php include_once('include/admin-footer.php'); ?>
        </div>
        <!-- ============================================================== -->
        <!-- End Right content here -->
        <!-- ============================================================== -->
    </div>
    <!-- END wrapper -->
	
	
<script>
                        CKEDITOR.replace( 'editor1' );
                </script>
				
				<script>
                        CKEDITOR.replace( 'editor2' );
                </script>
				
				<script>
                        CKEDITOR.replace( 'editor3' );
                </script>
				
				<script>
                        CKEDITOR.replace( 'editor4' );
                </script>
				
				<script>
                        CKEDITOR.replace( 'editor5' );
                </script>


    <!-- jQuery  -->
    <script src="assets/js/jquery.min.js"></script>
    <script src="assets/js/bootstrap.bundle.min.js"></script>
    <script src="assets/js/metisMenu.min.js"></script>
    <script src="assets/js/jquery.slimscroll.js"></script>
    <script src="assets/js/waves.min.js"></script>
    <!-- App js -->
    <script src="assets/js/app.js"></script>
</body>


</html>