View file iblog/lib/functions_class.php

<?php 
include ("config.php");

	class DB_connection{
		private $conn;
			function __construct($conn){
				$this->conn = $conn;
		}
		
		//Add Page
		public function add_page($title,$pagename,$page,$metatitle,$metadesc,$metakeyword,$sidebar){
			$conn = $this->conn;
			$res = $conn->query("INSERT INTO ".BLOG_PAGES."(title, page_name, page_content, meta_title, meta_desc, meta_keywords,side_bar) 
			VALUES ('$title','$pagename','$page','$metatitle','$metadesc','$metakeyword','$sidebar')");
			return $res;
		}
		
		//Update Page
		public function updatepage($title,$pagename,$page,$metatitle,$metadesc,$metakeyword,$pageid,$sidebar){
			$conn = $this->conn;
			$res = $conn->query("UPDATE ".BLOG_PAGES." SET title='$title', page_name='$pagename', page_content='$page', meta_title='$metatitle', meta_desc='$metadesc', meta_keywords='$metakeyword', side_bar='$sidebar' where id='$pageid'");
			return $res;
		}
		
		//Fetch Page Table
		public function output_pages($start,$limit,$orderby,$searchkey,$datefrom,$dateto){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".BLOG_PAGES." where id != 0 ";
			
			if($searchkey != ''){
				$sql .= " and title LIKE '%$searchkey%' or page_name LIKE '%$searchkey%' or meta_title LIKE '%$searchkey%' or meta_keywords LIKE '%$searchkey%' ";
			}
			
			if($datefrom != '' or $dateto != ''){
				$date_from = date('Y-m-d',strtotime($datefrom));
				$date_to = date('Y-m-d',strtotime($dateto));
				$sql .= " and date(date) BETWEEN '{$date_from}' and '{$date_to}'";
			}
			
			$sql .= " ORDER BY id $orderby LIMIT $start, $limit ";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Total Page of Pages Table In Number
		public function totalpage($searchkey,$datefrom,$dateto){
			$conn = $this->conn;
			$query = "SELECT COUNT(*) as num FROM ".BLOG_PAGES." where id !='' ";
			if($searchkey != ''){
				$query .= " and title LIKE '%$searchkey%' or page_name LIKE '%$searchkey%' or meta_title LIKE '%$searchkey%' or meta_keywords LIKE '%$searchkey%' ";
			}
			
			if($datefrom != '' or $dateto != ''){
				$date_from = date('Y-m-d',strtotime($datefrom));
				$date_to = date('Y-m-d',strtotime($dateto));
				$sql .= " and date(date) BETWEEN '{$date_from}' and '{$date_to}'";
			}
	
			$run = $conn->query($query);
			$total_pages = $run->fetch_array();
			$total_pages = $total_pages[num];
			
			return $total_pages;
		}
		
		//Fetch Page Table
		public function output_edit($id){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".BLOG_PAGES." where id = $id";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Update Nav Order
		public function navigation_order($id){
			$conn = $this->conn;
			
			$arr = explode(",", $id);
			$val = $arr[0];
			$id = $arr[1];
			$conn->query("UPDATE ".BLOG_PAGES." SET nav_order='{$val}' WHERE id='{$id}'");
			echo "1";
		}
		
		//Delete Page
		public function delete_page($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".BLOG_PAGES." where id = $id";
			$result=$conn->query($sql);
		}
		
		//Delete AllPage
		public function delete_allpage($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".BLOG_PAGES." where id IN ({$id})";
			$result=$conn->query($sql);
		}
		
/*#####################Pages End##########################*/

	//Add Blog
		public function add_blog($title,$pagename,$page,$imgname,$metatitle,$metadesc,$metakeyword,$sidebar){
			$conn = $this->conn;
			$res = $conn->query("INSERT INTO ".BLOG_POST."(title, page_name, page_content, feature_img, meta_title, meta_desc, meta_keywords,side_bar) VALUES ('$title','$pagename','$page','$imgname','$metatitle','$metadesc','$metakeyword','$sidebar')");
			return $res;
		}
		
		//Update Blog
		public function updateblog($title,$pagename,$page,$imgname,$metatitle,$metadesc,$metakeyword,$pageid,$sidebar){
			$conn = $this->conn;
			$res = $conn->query("UPDATE ".BLOG_POST." SET title='$title', page_name='$pagename', page_content='$page', 
			feature_img='$imgname', meta_title='$metatitle', meta_desc='$metadesc', meta_keywords='$metakeyword', side_bar='$sidebar' where id='$pageid'");
			return $res;
		}
		
		//Fetch Blog Table
		public function output_blog($start,$limit,$orderby,$searchkey,$datefrom,$dateto){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".BLOG_POST." where id != 0 ";
			
			if($searchkey != ''){
				$sql .= " and title LIKE '%$searchkey%' or page_name LIKE '%$searchkey%' or meta_title LIKE '%$searchkey%' or meta_keywords LIKE '%$searchkey%' ";
			}
			
			if($datefrom != '' or $dateto != ''){
				$date_from = date('Y-m-d',strtotime($datefrom));
				$date_to = date('Y-m-d',strtotime($dateto));
				$sql .= " and date(date) BETWEEN '{$date_from}' and '{$date_to}'";
			}
			
			$sql .= " ORDER BY id $orderby LIMIT $start, $limit ";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Total Blogs of Blog Table In Number
		public function totalblog($searchkey,$datefrom,$dateto){
			$conn = $this->conn;
			$query = "SELECT COUNT(*) as num FROM ".BLOG_POST." where id !='' ";
			if($searchkey != ''){
				$query .= " and title LIKE '%$searchkey%' or page_name LIKE '%$searchkey%' or meta_title LIKE '%$searchkey%' or meta_keywords LIKE '%$searchkey%' ";
			}
			
			if($datefrom != '' or $dateto != ''){
				$date_from = date('Y-m-d',strtotime($datefrom));
				$date_to = date('Y-m-d',strtotime($dateto));
				$sql .= " and date(date) BETWEEN '{$date_from}' and '{$date_to}'";
			}
	
			$run = $conn->query($query);
			$total_pages = $run->fetch_array();
			$total_pages = $total_pages[num];
			
			return $total_pages;
		}
		
		//Fetch Blog Table
		public function outputblog_edit($id){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".BLOG_POST." where id = $id";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Fetch Blog Featured IMAGE
		public function get_blog_img($id){
			$conn = $this->conn;
			$sql = "SELECT feature_img FROM ".BLOG_POST." where id = $id";
			$result=$conn->query($sql);
			$a = $result->fetch_array();
			$val = $a['feature_img'];
			return $val;
		}
		
		//Delete Blog Topic
		public function delete_blog($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".BLOG_POST." where id = $id";
			$result=$conn->query($sql);
		}
		
		//Delete Blog Topic
		public function delete_allblog($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".BLOG_POST." where id IN ({$id})";
			$result=$conn->query($sql);
		}
/*#####################Blog End##########################*/

		//Fetch Comments Table
		public function output_comments($start,$limit,$orderby,$searchkey,$datefrom,$dateto,$status){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT BCM.id,BCM.date,BCM.email,BCM.mobile,BCM.comments,BCM.status,BPS.title,BPS.page_name  
					FROM ".BLOG_COMMENTS." BCM 
					LEFT JOIN ".BLOG_POST." BPS ON BCM.blog_id=BPS.id
					where BCM.id != 0 ";
			
			if($status != ''){
				$sql .= " and BCM.status='{$status}' ";
			}
			
			if($searchkey != ''){
				$sql .= " and BPS.title LIKE '%$searchkey%' or BCM.comments LIKE '%$searchkey%' or BCM.mobile LIKE '%$searchkey%' or BCM.email LIKE '%$searchkey%' ";
			}
			
			if($datefrom != '' or $dateto != ''){
				$date_from = date('Y-m-d',strtotime($datefrom));
				$date_to = date('Y-m-d',strtotime($dateto));
				$sql .= " and date(BCM.date) BETWEEN '{$date_from}' and '{$date_to}'";
			}
			
			$sql .= " ORDER BY BCM.id $orderby LIMIT $start, $limit ";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Total Comments of Comments Table In Number
		public function totalcomments($searchkey,$datefrom,$dateto,$status){
			$conn = $this->conn;
			$query = "SELECT COUNT(*) as num
					FROM ".BLOG_COMMENTS." BCM 
					LEFT JOIN ".BLOG_POST." BPS ON BCM.blog_id=BPS.id
					where BCM.id != 0 ";
			
			if($status != ''){
				$query .= " and BCM.status='{$status}' ";
			}
			
			if($searchkey != ''){
				$sql .= " and BPS.title LIKE '%$searchkey%' or BCM.comments LIKE '%$searchkey%' or BCM.mobile LIKE '%$searchkey%' or BCM.email LIKE '%$searchkey%' ";
			}
						
			if($datefrom != '' or $dateto != ''){
				$date_from = date('Y-m-d',strtotime($datefrom));
				$date_to = date('Y-m-d',strtotime($dateto));
				$query .= " and date(BCM.date) BETWEEN '{$date_from}' and '{$date_to}'";
			}
			
			$run = $conn->query($query);
			$total_pages = $run->fetch_array();
			$total_pages = $total_pages[num];
			
			return $total_pages;
		}
		
		//Delete Comments
		public function delete_comments($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".BLOG_COMMENTS." where id = $id";
			$result=$conn->query($sql);
		}
		
		//Delete Comments
		public function delete_allcomments($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".BLOG_COMMENTS." where id IN ({$id})";
			$result=$conn->query($sql);
		}
		
		//Moderate Comments
		public function moderate_comments($id,$moderate){
			$conn = $this->conn;
			$sql = "UPDATE ".BLOG_COMMENTS." SET status='{$moderate}' where id='{$id}'";
			$result=$conn->query($sql);
		}
/*#####################Comments End##########################*/


		//Add Slider
		public function add_slider($title,$contents,$url,$imgname){
			$conn = $this->conn;
			$res = $conn->query("INSERT INTO ".SLIDER_TABLE."(title, contents, url, slider_pic) 
			VALUES ('$title','$contents','$url','$imgname')");
			return $res;
		}
		
		//Update Slider
		public function update_slider($title,$contents,$url,$imgname,$bannerid){
			$conn = $this->conn;
			$res = $conn->query("UPDATE ".SLIDER_TABLE." SET title='$title', contents='$contents', url='$url', 
			slider_pic='$imgname' where id='$bannerid'");
			return $res;
		}
		
		//Update Banner Order
		public function banner_order($order,$id){
			$conn = $this->conn;
			$res = $conn->query("UPDATE ".SLIDER_TABLE." SET banner_order='$order' where id='$id'");
		}
		
		//Fetch Slider Table
		public function output_slider($start,$limit,$orderby,$searchkey){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".SLIDER_TABLE." where id != 0 ";
			
			if($searchkey != ''){
				$sql .= " and title LIKE '%$searchkey%' ";
			}
			
			$sql .= " ORDER BY banner_order $orderby LIMIT $start, $limit ";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Total Slider of Slider Table In Number
		public function totalslider($searchkey){
			$conn = $this->conn;
			$query = "SELECT COUNT(*) as num FROM ".SLIDER_TABLE." where id !='' ";
			
			if($searchkey != ''){
				$sql .= " and title LIKE '%$searchkey%' ";
			}
	
			$run = $conn->query($query);
			$total_pages = $run->fetch_array();
			$total_pages = $total_pages[num];
			
			return $total_pages;
		}
		
		//Fetch Slider Table
		public function outputslider_edit($id){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".SLIDER_TABLE." where id = $id";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Delete Slider Banner
		public function delete_slider($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".SLIDER_TABLE." where id = $id";
			$result=$conn->query($sql);
		}
		
		//Get Page Name
		public function blogpage_name(){
			$conn = $this->conn;
			$sql="SELECT page_name FROM pages where blog='1'";
			$run=$conn->query($sql);
			$a=$run->fetch_array();
			
			$val = $a['page_name'];
			return $val;
		}
		
		//Fetch Country
		public function country(){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".COUNTRIES_TABLE;			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Fetch State
		public function state($cid){
			$conn = $this->conn;
			$jsonData = array();
			if($cid == ''){
				$val = 0;
			}else{
				$val = $cid;
			}
			
			$sql = "SELECT * FROM ".STATES_TABLE." where country_id = {$val}";
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Update Members
		public function update_profile($fname,$lname,$addressone,$addresstwo,$mobile,$email,$country,$state,$city,$postal,$dob,$marital_stat,$id,$imgname){
			$conn = $this->conn;
			$sql = "UPDATE ".MEMBER_TABLE." SET first_name='$fname',last_name='$lname',phone='$mobile',
			email='$email',country='$country',state='$state',city='$city', postal_code='$postal', address_one='$addressone',
			address_two='$addresstwo', dob='$dob', marital_stat='$marital_stat' ";
			
			if($imgname != ''){	
				$sql .= ",profile_pic='$imgname' ";
			}
			
			$sql .= "where id='$id'";
			
			$res = $conn->query($sql);
			return $res;
		}
		
		//Fetch Member
		public function output_editmember($id){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".MEMBER_TABLE." where id = $id";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Update Setting
		public function update_setting($value,$data){
			$conn = $this->conn;
			
			$sql = "UPDATE ".SETTING_TBL." SET setting_val='{$value}' where name='{$data}'";
			$result=$conn->query($sql);
		}
		
		//Get Setting Data
		public function get_settingdata($data){
			$conn = $this->conn;
			$sql = "SELECT * FROM ".SETTING_TBL." WHERE name = '{$data}'";
			$result=$conn->query($sql);
			$a = $result->fetch_array();
			$val = $a['setting_val'];
			return $val;
		}
		
		//Get User Avatar
		public function avatar(){
			$conn = $this->conn;
			$sql = "SELECT profile_pic FROM ".MEMBER_TABLE." WHERE id = '{$_SESSION['aid']}'";
			$result=$conn->query($sql);
			$a = $result->fetch_array();
			$val = $a['profile_pic'];
			return $val;
		}
		
		//Get Footer
		function footer(){
			$conn = $this->conn;
			$sql="SELECT setting_val FROM ".SETTING_TBL." where name='footer'";
			$run=$conn->query($sql);
			$a=$run->fetch_array();
			
			$val = $a['setting_val'];
			return $val;
		}
		
		//Make Page as Blog
		public function make_blog($page){
			$conn = $this->conn;
			$conn->query("UPDATE ".BLOG_PAGES." SET blog='0' WHERE blog='1'");
			$conn->query("UPDATE ".BLOG_PAGES." SET blog='1' WHERE page_name='{$page}'");
		}
		
		//Find User Password
		public function findpassword($user_uid,$password){
			$conn = $this->conn;
			$sql = "SELECT * FROM ".MEMBER_TABLE." WHERE password = '$password' and id='$user_uid'";
			$result=$conn->query($sql);
			$a = $result->fetch_array();
			$pass = $a['password'];
			return $pass;
		}
		
		//Change Password
		public function updatepassword($user_uid,$password){
			$conn = $this->conn;
			$sql="UPDATE ".MEMBER_TABLE." SET password='$password' where id='$user_uid'";
			$query=$conn->query($sql);
		}
		
		//Recover Password
		public function recoverpassword($email,$password){
			$conn = $this->conn;
			$sql="UPDATE ".MEMBER_TABLE." SET password='$password' where email='$email'";
			$query=$conn->query($sql);
		}
		
		//Get Total of Etc
		public function get_total($table){
			$conn = $this->conn;
			$sql = "SELECT * FROM ".$table;
			$result=$conn->query($sql);
			$count = $result->num_rows;
			return $count;
		}
		
		//Latest Comments - Dashboard
		public function latest_comments(){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".BLOG_COMMENTS." ORDER BY id DESC LIMIT 0,5";			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//UnApproved Comments - Notification
		public function unappproved_comments($value){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".BLOG_COMMENTS." WHERE status = 0 ";		
			
			if($value == 'view'){
				$sql .= " ORDER BY id DESC LIMIT 5";	
			}				
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Latest VISITORS - Dashboard
		public function latest_visitors(){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".VISITORS_IP." ORDER BY id DESC LIMIT 0,5";			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		/******* Add User*********/
		public function add_user($username,$fname,$lname,$email,$password,$role){
			$conn = $this->conn;
			$res = $conn->query("INSERT INTO ".MEMBER_TABLE."(user_name, first_name, last_name, email, password, role) 
			VALUES ('$username','$fname','$lname','$email',md5('$password'),'$role')");
			return 1;
		}
		/******* Add User*********/
		
		
/*##################### Total Themes ##########################*/
	//Add Themes
	public function add_themes($filename){
		$conn = $this->conn;
		$conn->query("UPDATE ".THEMES_TABLE." SET status='0' where status='1'");
		$sql="INSERT INTO ".THEMES_TABLE."(name, status) VALUES ('$filename','1')";
		$query=$conn->query($sql);
	}
	
	public function activate_themes($id){
		$conn = $this->conn;
		$conn->query("UPDATE ".THEMES_TABLE." SET status='0' where status='1'");
		$conn->query("UPDATE ".THEMES_TABLE." SET status='1' where id=$id");
	}

	//Fetch Themes Table
		public function output_theme($start,$limit){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".THEMES_TABLE." ORDER BY id DESC LIMIT $start, $limit ";
			
			$result=$conn->query($sql);
			while ($array = $result->fetch_array()){
				$jsonData[] = $array;
			}
			return $jsonData;
		}
		
		//Total Themes of Themes Table In Number
		public function totaltheme($searchkey,$datefrom,$dateto){
			$conn = $this->conn;
			$query = "SELECT COUNT(*) as num FROM ".THEMES_TABLE;
			
			$run = $conn->query($query);
			$total_pages = $run->fetch_array();
			$total_pages = $total_pages[num];
			
			return $total_pages;
		}
		
		//Delete Themes
		public function delete_themes($id){
			$conn = $this->conn;
			$sql = "DELETE FROM ".THEMES_TABLE." where id = $id";
			$result=$conn->query($sql);
		}
/*##################### Total Themes ##########################*/


/*##################### Setting End ##########################*/
		//Find Email
		public function findemail($email){
			$conn = $this->conn;
			$sql = "SELECT * FROM ".MEMBER_TABLE." WHERE email = '$email'";
			$result=$conn->query($sql);
			$count = $result->num_rows;
			return $count;
		}

		//User Login
		public function user_login($username,$password){
			$conn = $this->conn;
			$jsonData = array();
			$sql = "SELECT * FROM ".MEMBER_TABLE." where email='{$_POST['username']}' and password='{$password}'";
			
			$result=$conn->query($sql);
			$array = $result->fetch_assoc();
			$jsonData[] = $array;
			
			return $jsonData;
		}

}
	/*****Created Class Object******/
	$DB = new DB_connection($conn);
?>