/*********************************** There Were Some Offen Use DB Function ************************************/ function getRecord($tbl,$where='') { global $DB; $sql ="select * from $tbl where 1=1 "; $sql.=$where; //echo $sql; $query = mysqli_query($DB,$sql); return $query; } // To get single record function getRow($tbl,$where='') { global $DB; $sql ="select * from $tbl where 1=1 "; $sql.=$where; $query = mysqli_query($DB,$sql); $res = mysqli_fetch_array($query); return $res; } // To get no of records function getRecordNo($tbl,$where='') { global $DB; $sql ="select count(*) as total from $tbl where 1=1 "; $sql.=$where; $query = mysqli_query($DB,$sql); $res = mysqli_fetch_assoc($query); return $res['total']; } // To get no banner Image function getHeaderBanner($sub_menu) { global $DB; $sql ="select * from pages where status='1' and sub_menu='$sub_menu' "; $sql.=$where; $query = mysqli_query($DB,$sql); $res = mysqli_fetch_assoc($query); return $res; } // To get no banner Image function getCta($tbl) { global $DB; $sql ="select * from $tbl where 1=1 "; $sql.=$where; $query = mysqli_query($DB,$sql); $res = mysqli_fetch_assoc($query); return $res; } /*function getRecordHomeNo($tbl,$type='') { global $DB; $sql ="select count(*) as total from $tbl where status='1' and type='$type'"; //echo $sql; $query = mysqli_query($DB,$sql); $res = mysqli_fetch_assoc($query); return $res['total']; } // To get Seo on Page Tags function getRecord($tbl,$where='') { global $DB; $sql ="select * from $tbl"; $sql.=$where; $query = mysqli_query($DB,$sql); return $query; } */ function getPopup($id,$key,$tbl) { global $DB; $query=mysqli_query($DB,"select * from $tbl where $key='$id' and onload_pop_status='1' and onloadpop_image!=''"); $res=mysqli_fetch_assoc($query); return($res); } // to get slider detail