<?php
include_once('connection.php');
function do_upload($file,$path){
		$targetDir="../uploads/".$path."/";
		if(move_uploaded_file($_FILES['file']['tmp_name'], $targetDir.$file)){
			return true;
		}else{
			return false;
		}
}

function slug($title){
	$slug=strToLower(str_replace(" ","-",str_replace(str_split('\/:.()*?"<>!=_|$%^&*#{}[],+`~@'), '', $title)));
	$slug =  preg_replace('/-+/', '-', $slug);
	$slug= trim($slug,'-');
	return $slug;
	}
function get($table,$column,$order){
	$sql = "select * from ".$table." order by ".$column." ".$order;
	return query($sql);
}
function getWhere($table,$column,$value){
	$sql = "select * from ".$table." where ".$column."='".$value."'";
	return query($sql);
}
function getWhereExtended($table,$conds){
	$sql = "select * from ".$table." where $conds";
	return query($sql);
}
function getWhereNot($table,$column,$value){
	$sql = "select * from ".$table." where ".$column."!='".$value."'";
	return query($sql);
}
function getWhereLimit($table,$column,$value,$limit){
	$sql = "select * from ".$table." where ".$column."!='".$value."' limit $limit";
	return query($sql);
}
function checkSlugPre($table,$slug){
	$sql = "select * from ".$table." where slug ='".$slug."'";
	return query($sql);
}
function checkSlug($table,$id,$slug){
	$sql = "select * from ".$table." where slug ='".$slug."' AND id !=".$id;
	return query($sql);
}
function deleteWhere($table,$column,$value){
	$sql = "delete from ".$table." where ".$column."='".$value."'";
	return query($sql);
}

function remove_upload($file,$path){
		 $targetDir="../uploads/".$path."/";
		 $targetFile=$targetDir.$file;
		if(file_exists($targetFile)){
			if(@unlink($targetFile)){
				return true;
			}else{
				return true;
			}
		}
	}
/*un-universal function*/
function checkStock($product_id){
	$sql = "select quantity from inventory where product_id=$product_id";
	foreach(query($sql) as $row){
		return $row['quantity'];
	}
}

function filter_param($filters){
$stage1= preg_replace("/[^0-9,.]/", "", $filters);
$stage2 = str_replace(".","",$stage1);
return trim($stage2,",");
}
?>