View file iblog/lib/function.php

<?php
 
	function blogpage_name($conn){
		$sql="SELECT page_name FROM ".BLOG_PAGES." where blog='1'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['page_name'];
		return $val;
	}
	
	function getpostid($conn,$post_name){
		$sql="SELECT id FROM ".BLOG_POST." where page_name='$post_name'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['id'];
		return $val;
	}
	
	function getpageid($conn,$page_name){
		$sql="SELECT id FROM ".BLOG_PAGES." where page_name='$page_name'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['id'];
		return $val;
	}
	
	function totalcomments($conn,$post_id){
		$sql="SELECT * FROM ".BLOG_COMMENTS." where blog_id='$post_id' and status='1'";
		$run=$conn->query($sql);
		$count=$run->num_rows;
		
		return $count;
	}
	
	//Get Page Name
	function getpage_name($conn,$page){
		$sql="SELECT page_name FROM ".BLOG_PAGES." where page_name='$page'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['page_name'];
		return $val;
	}
	
	//Get Topic Name
	function gettopic_name($conn,$topic){
		$sql="SELECT page_name FROM ".BLOG_POST." where page_name='$topic'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['page_name'];
		return $val;
	}
	
	//Get Blog Post Name
	function getpostname($conn,$id){
		$sql="SELECT page_name FROM ".BLOG_POST." where id='$id'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['page_name'];
		return $val;
	}
	
	
	//Fetch Member Table
	function setting($conn,$name){
		$sql = "SELECT setting_val FROM ".SETTING_TBL." where name='$name'";
		
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = $a['setting_val'];
		return $val;
	}
	
	/****Sidebar Config*****/
	function sidebar($status){
		if($status == 0){
			$val = "col-md-12 col-sm-12";
		}else{
			$val = "col-md-9 col-sm-9";
		}
		return $val;
	}
	
	//Total Page of Post
	function totalpost($conn){
		$query = "SELECT COUNT(*) as num FROM ".BLOG_POST;
	
		$run = $conn->query($query);
		$total_pages = $run->fetch_array();
		$total_pages = $total_pages[num];
				
		return $total_pages;
	}
	
	function active_theme($conn){
		$sql="SELECT name FROM ".THEMES_TABLE." where status='1'";
		$run=$conn->query($sql);
		$a=$run->fetch_array();
		
		$val = "themes/".$a['name'];
		return $val;
	}
	
	function getUserIP(){
		$client  = @$_SERVER['HTTP_CLIENT_IP'];
		$forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
		$remote  = $_SERVER['REMOTE_ADDR'];

		if(filter_var($client, FILTER_VALIDATE_IP))
		{
			$ip = $client;
		}
		elseif(filter_var($forward, FILTER_VALIDATE_IP))
		{
			$ip = $forward;
		}
		else
		{
			$ip = $remote;
		}

		return $ip;
	}
	
	function visitors($conn,$user_ip){
		$query = "select * from ".VISITORS_IP." where DATE(`date`) = DATE(CURDATE()) and ip_adress='{$user_ip}'";	
		$run=$conn->query($query);	
		$a=$run->fetch_array();
		$count=$run->num_rows;
	
		$visit= ++$a['num_of_visit'];
	
		if($count >= 1){
			$conn->query("UPDATE ".VISITORS_IP." SET num_of_visit='{$visit}' where ip_adress='{$user_ip}'");
		}
		else{
			$conn->query("INSERT INTO ".VISITORS_IP."(ip_adress) VALUES ('{$user_ip}')");
		}
	}

?>