1#@!#!123s

22527 1#@!#!123s
: / home / dandelida / 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="">
                    <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>
                </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 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());
}



?>