Server : LiteSpeed System : Linux in-mum-web1112.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u451330669 ( 451330669) PHP Version : 8.2.27 Disable Function : NONE Directory :  /home/u451330669/domains/wecareindustry.in/public_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
function pr($arr){
	echo '<pre>';
	print_r($arr);
}

function prx($arr){
	echo '<pre>';
	print_r($arr);
	die();
}

function get_safe_value($con,$str){
	if($str!=''){
		$str=trim($str);
		return mysqli_real_escape_string($con,$str);
	}
}

function get_product($con,$limit='',$cat_id='',$product_id='',$search_str='',$sort_order='',$is_best_seller='',$sub_categories=''){
	$sql="select product.*,categories.categories from product,categories where product.status=1 ";
	if($cat_id!=''){
		$sql.=" and product.categories_id=$cat_id ";
	}
	if($product_id!=''){
		$sql.=" and product.id=$product_id ";
	}
	if($is_best_seller!=''){
		$sql.=" and product.best_seller=1";
	}
  if($sub_categories!=''){
		$sql.=" and product.sub_categories_id=$sub_categories ";
	}
	$sql.=" and product.categories_id=categories.id";
	if($search_str!=''){
		$sql.=" and (product.name like '%$search_str%' or product.description like '%$search_str%') ";
	}
	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by product.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}

function get_video($con,$limit='',$video_id='',$search_str='',$sort_order=''){
	$sql="select * from video where video.status=1 ";
	
	if($video_id!=''){
		$sql.=" and video.id=$video_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by video.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}
function get_blog($con,$limit='',$blog_id='',$search_str='',$sort_order=''){
	$sql="select * from blog where blog.status=1 ";
	
	if($blog_id!=''){
		$sql.=" and blog.id=$blog_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by blog.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}


function get_career($con,$limit='',$career_id='',$search_str='',$sort_order=''){
	$sql="select * from career where career.status=1 ";
	
	if($career_id!=''){
		$sql.=" and career.id=$career_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by career.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}

function get_events($con,$limit='',$events_id='',$search_str='',$sort_order=''){
	$sql="select * from events where events.status=1 ";
	
	if($events_id!=''){
		$sql.=" and events.id=$events_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by events.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}




function get_about($con,$limit='',$about_id='',$search_str='',$sort_order=''){
	$sql="select * from about where about.status=1 ";
	
	if($about_id!=''){
		$sql.=" and about.id=$about_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by about.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}


function get_banner($con,$limit='',$banner_id='',$search_str='',$sort_order=''){
	$sql="select * from banner where banner.status=1 ";
	
	if($banner_id!=''){
		$sql.=" and banner.id=$banner_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by banner.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}


function get_services($con,$limit='',$services_id='',$search_str='',$sort_order=''){
	$sql="select * from services where services.status=1 ";
	
	if($services_id!=''){
		$sql.=" and services.id=$services_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by services.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}
function get_gallary($con,$limit='',$gallary_id='',$search_str='',$sort_order=''){
	$sql="select * from gallary where gallary.status=1 ";
	
	if($gallary_id!=''){
		$sql.=" and gallary.id=$gallary_id ";
	}
	

	if($sort_order!=''){
		$sql.=$sort_order;
	}else{
		$sql.=" order by gallary.id desc ";
	}
	if($limit!=''){
		$sql.=" limit $limit";
	}
	//echo $sql;
	$res=mysqli_query($con,$sql);
	$data=array();
	while($row=mysqli_fetch_assoc($res)){
		$data[]=$row;
	}
	return $data;
}


?>