1#@!#!123s

22527 1#@!#!123s
: / home / journeyindianow / public_html / include /
Filename : function.php
back
<?php 
//include("./admin/database/dbconfig.php");
include("./admin/config.php");

/* slider */
function slider(){
	global $pdo;
	global $base_url;
	try{
		
		$query = "SELECT * FROM `slider`";
		$que_stmt = $pdo->prepare($query);
		$q  = $que_stmt->execute();
		$que_stmt->setFetchMode(PDO::FETCH_OBJ);
	     
		$i=1;
		while($slider_row = $que_stmt->fetch() ){
			 
			  
			echo '<li data-index="rs-2972" data-transition="fade" data-slotamount="default" data-hideafterloop="0" data-hideslideonmobile="off" data-easein="default" data-easeout="default" data-masterspeed="300" data-rotate="0" data-saveperformance="off" data-title=""
                    data-param1="01" data-param2="" data-param3="" data-param4="" data-param5="" data-param6="" data-param7="" data-param8="" data-param9="" data-param10="" data-description="">
                    <a href="'.$slider_row->varLink.'">
                     <img src="'.$base_url.'admin/slider/'.$slider_row->varImage.'" alt="" data-bgposition="center center" data-bgfit="cover" data-bgrepeat="no-repeat" data-bgparallax="5" class="rev-slidebg" data-no-retina>
                    </a>
                </li>';
			$i++;
		}
	
	}catch(PDOException $e){
		die($e->getMessage());
	}
}


/* Social icon */
function header_social(){
	global $pdo;
	global $base_url;
	try{
		
		$que = "select * from social_icon";
        $head_stmt = $pdo->prepare($que);
        $q         = $head_stmt->execute();
        $head_stmt->setFetchMode(PDO::FETCH_OBJ);
		if($head_stmt->rowCount() > 0){
			while($row = $head_stmt->fetch()){
				 
				echo '<li><a href="'.$row->varUrl.'" class="fa fa-'.$row->varName.'"></a></li>';
			 
			}
		}
			
         
	}catch(PDOException $e){
        die($e->getMessage());
	}
	
}

function header_social2(){
	global $pdo;
	global $base_url;
	try{
		
		$que = "select * from social_icon";
        $head_stmt = $pdo->prepare($que);
        $q         = $head_stmt->execute();
        $head_stmt->setFetchMode(PDO::FETCH_OBJ);
		if($head_stmt->rowCount() > 0){
			while($row = $head_stmt->fetch()){
				 
				//echo '<li><a href="'.$row->varUrl.'" class="fa fa-'.$row->varName.'"></a></li>';
				echo '<div class="header_c_text">
                        <a href="'.$row->varUrl.'"><p><i class="fa fa-'.$row->varName.'"></i> </p></a>
                    </div>';
			}
		}
			
         
	}catch(PDOException $e){
        die($e->getMessage());
	}
	
}

/* Social icon */
function footer_links($type){
	global $pdo;
	global $base_url;
	try{
		
	 	$que = "select * from footer_data where varType='$type'";
        $head_stmt = $pdo->prepare($que);
        $q         = $head_stmt->execute();
        $head_stmt->setFetchMode(PDO::FETCH_OBJ);
		if($head_stmt->rowCount() > 0){
			while($row = $head_stmt->fetch()){
				 
				//echo '<li><a href="'.$row->varUrl.'" class="fa fa-'.$row->varName.'"></a></li>';
				echo ' <li><a href="'.$row->varLink.'">'.ucwords($row->varName).'</a></li>';
			}
		}
			
         
	}catch(PDOException $e){
        die($e->getMessage());
	}
	
}

/* Social icon */
function home_offer_package(){
	global $pdo;
	global $base_url;
	try{
		
		$que = "select * from  offertour_category order by intId asc limit 4";
        $head_stmt = $pdo->prepare($que);
        $q         = $head_stmt->execute();
        $head_stmt->setFetchMode(PDO::FETCH_OBJ);
		if($head_stmt->rowCount() > 0){
			while($row = $head_stmt->fetch()){
				 
			 
				echo ' <div class="col-md-3 col-xs-12">
                            <div class="item animated" data-animation="fadeInUp">
                                <a href="'.$base_url.'offer-package/'.str_replace(" ","-",$row->varName).'">
                                <img src="'.$base_url.'admin/category/'.$row->varImage.'">
                                <h4 style=" background: #3d8adf;color: #fff;padding: 10px;border-radius: 10px;">'.ucwords($row->varName).'</h4></a>
                                <!--<a class="quote_btn br" href="'.$base_url.'offer-package/'.str_replace(" ","-",$row->varName).'">View Packages</a>-->
                            </div>
                        </div>';
        			}
		}
			
         
	}catch(PDOException $e){
        die($e->getMessage());
	}
	
}

/* Social icon */
function home_tour_package(){
	global $pdo;
	global $base_url;
	try{
		
		$que = "select * from  tour_category order by intId asc limit 4";
        $head_stmt = $pdo->prepare($que);
        $q         = $head_stmt->execute();
        $head_stmt->setFetchMode(PDO::FETCH_OBJ);
		if($head_stmt->rowCount() > 0){
			while($row = $head_stmt->fetch()){
				echo ' <div class="col-md-3 col-xs-12">
                            <div class="item animated" data-animation="fadeInUp">
                                <a href="'.$base_url.'tour-package/'.str_replace(" ","-",$row->varName).'">
                                <img src="'.$base_url.'admin/category/'.$row->varImage.'">
                                <h4 style=" background: #3d8adf;color: #fff;padding: 10px;border-radius: 10px;">'.ucwords($row->varName).'</h4></a>
                                <!--<a class="quote_btn br" href="'.$base_url.'tour-package/'.str_replace(" ","-",$row->varName).'">View Packages</a>-->
                            </div>
                        </div>';
        			}
		}
	}catch(PDOException $e){
        die($e->getMessage());
	}
}

function footer_social(){
	global $pdo;
	global $base_url;
	try{
		
		$que = "select * from social_icon";
        $foot_stmt = $pdo->prepare($que);
        $q         = $foot_stmt->execute();
        $foot_stmt->setFetchMode(PDO::FETCH_OBJ);
		if($foot_stmt->rowCount() > 0){
			while($row = $foot_stmt->fetch()){
				
				echo '<li><a href="'.$row->varUrl.'"><i class="fa fa-'.$row->varName.'" aria-hidden="true"></i></a></li>';
			}
		}
			
         
	}catch(PDOException $e){
        die($e->getMessage());
	}
	
}
/* end */

/* Subscriber page   */
if(isset($_POST['subscriber']) ){
	$email = mysqli_real_escape_string($con,$_POST['email']);
	
	$resel = mysqli_query($con,"SELECT `intId`, `varEmail` FROM `subscriber` WHERE `varEmail`= '$email'");
	if(mysqli_num_rows($resel) > 0){
		echo '<script>alert("You Are Already Subsciber.");</script>';
	}else{
		$insert = mysqli_query($con,"INSERT INTO `subscriber`(`varEmail`) VALUES ('$email')");
		if($insert){
			echo '<script>alert("Subscibed Successfully.");</script>';
			echo '<script>window.location.replace("'.$base_url.'");</script>';
		}else{
			echo '<script>alert("Something Went Wrong.");</script>';
		}
	}
}

/* Subscriber page   */




/* conatcact page   */
try{
	
	$contactdetail = "SELECT * FROM `contact` WHERE `intId`=?";
	$cont_stmt     = $pdo->prepare($contactdetail);
	$c   = $cont_stmt->execute([1]);
	$cont_stmt->setFetchMode(PDO::FETCH_OBJ);
	
	$contct = $cont_stmt->fetch();
	
}catch(PDOException $e){
	die($e->getMessage());
}



?>