Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536

kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536

<?php
class dbquery extends SiteData {

$select = "SELECT ";

if($fields!=""){
			$select .= $fields;
		}else{
			$select .= $all;
		}

$select .= " FROM ".$tbl." ";
		if($condition!=""){
			$select .= "WHERE ".$condition;
		}
		if($order!=""){
			$select .= " ".$order;
		}
		if($limit!=""){
			$select .= $limit;
		}
		//echo $select;exit;
		$exe = $this->exeCute($select);
		return $exe;

}
         function delete($tbl_nm,$field,$condition){
		if($field!=""){
			$select = "DELETE ".$field." FROM ".$tbl_nm." WHERE ".$condition;
		}else{
			$select = "DELETE FROM ".$tbl_nm." WHERE ".$condition;
		}
		//echo $select;exit;
        $conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
		$sql = mysqli_query($conn, $select);
		if($sql){
			return true;
		}else{
			return false;
		}

}

function countRec($tbl_nm,$condition=""){
		$select = "SELECT * FROM ".$tbl_nm;
		if($condition!=""){
			$select .= " WHERE ".$condition;
		}
        $conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
		$row_query = mysqli_query($conn, $select);
		$num_row = mysqli_num_rows($row_query);

return $num_row;
	}
	function fetchSingleLatest($tbl_nm,$condition="",$key=""){
		$select = "SELECT * FROM ".$tbl_nm;
		if($condition!=""){
			$select .= " WHERE ".$condition;
		}
		if($key!=""){
			$select .= " ORDER BY ".$key." LIMIT 1";
		}
		//echo $select;exit;
        $conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
		$qry_exe = mysqli_query($conn, $select);
		$ret_rec = mysqli_fetch_array($qry_exe);

return $ret_rec;
	}
	function fetchSingle($tbl_nm,$field,$condition){
		if($field!=""){
			$select = "SELECT ".$field." FROM ";
		}else{
			$select = "SELECT * FROM ";
		}
		$select .= $tbl_nm." WHERE ".$condition;
        $conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
		$sql = mysqli_query($conn, $select);
		$data_row = mysqli_num_rows($sql);
		if($data_row>0){
			$rec = mysqli_fetch_array($sql);
			return $rec;
			}else{
			$rec=0;
			return $rec;
			}

}

function enableReview($id) {
		$id = inText($id);
		$sql = "UPDATE tbl_user set review_status='1' where id='$id'";
		$res = $this->update($sql);
		$msg = "success";
		return $msg;
	}

function disableReview($id) {
		$id = inText($id);
		$sql = "UPDATE tbl_user set review_status='0' where id='$id'";
		$res = $this->update($sql);
		$msg = "success";
		return $msg;
	}

return $res_data;
	}

function getUniqID($insert_id){
	$get_new_id = "FB".sprintf("%04d",$insert_id);
	$upd_uniq_id = $this->updateToDb("fran_details","unique_key = '$get_new_id'","id = $insert_id");
}

function get_user_info($query){
		$select = $query;
        $conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
		$res = mysqli_query($conn, $select);
		while($res_row = mysqli_fetch_array($res)){
		 $res_data[] = $res_row;
		}

return $res_data;
	}

function get_user_info1($query){
	 $query;
		$select = $query;
        $conn = mysqli_connect(SYSTEM_DBHOST,SYSTEM_DBUSER,SYSTEM_DBPWD,SYSTEM_DBNAME);
		$res = mysqli_query($conn, $select);
		while($res_row = mysqli_fetch_array($res)){
		 $res_data[] = $res_row;
		}

return $res_data;
	}

}
?>