تمام آگهی ها
cleansql($_GET['category']);
if(isset($_SESSION['city'])){
$city_id=$_SESSION['city'];
if(isset($_SESSION['subcity'])){
$subcity_id=$_SESSION['subcity'];
}else{
$subcity_id=0;
}
//if subcat set
if(isset($_GET['subcategory'])){
if(isset($_GET['sub2category'])){
$sub_2cat=$act->cleansql($_GET['sub2category']);
$sub_cat=$act->cleansql($_GET['subcategory']);
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where city_id='$city_id' AND subcity_id='$subcity_id' AND cat_id='$cat_id' AND subcat_id='$sub_cat' AND sub2cat_id='$sub_2cat' AND admin_review=1 ORDER BY id desc" );
}else{
$sub_cat=$act->cleansql($_GET['subcategory']);
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where city_id='$city_id' AND subcity_id='$subcity_id' AND cat_id='$cat_id' AND subcat_id='$sub_cat' AND admin_review=1 ORDER BY id desc" );
}
}else{
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where city_id='$city_id' AND subcity_id='$subcity_id' AND cat_id='$cat_id' AND admin_review=1 ORDER BY id desc");
}
}else{
//if subcat set
if(isset($_GET['subcategory'])){
if(isset($_GET['sub2category'])){
$sub_2cat=$act->cleansql($_GET['sub2category']);
$sub_cat=$act->cleansql($_GET['subcategory']);
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where cat_id='$cat_id' AND subcat_id='$sub_cat' AND sub2cat_id='$sub_2cat' AND admin_review=1 ORDER BY id desc" );
}else{
$sub_cat=$act->cleansql($_GET['subcategory']);
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where cat_id='$cat_id' AND subcat_id='$sub_cat' AND admin_review=1 ORDER BY id desc" );
}
}else{
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where cat_id='$cat_id' AND admin_review=1 ORDER BY id desc");
}
}
}else{
if(isset($_SESSION['city'])){
$city_id=$_SESSION['city'];
$subcity_id=$_SESSION['subcity'];
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where city_id='$city_id' AND subcity_id='$subcity_id' AND admin_review=1 ORDER BY id desc");
}else{
$result1 = mysqli_query($con,"SELECT * FROM tbl_ads where admin_review=1 ORDER BY id desc");
}
}
if(!$result1) {
echo mysqli_errno($con) . mysqli_error($con);
return false;
}
$num_rows1=mysqli_num_rows($result1);
if($num_rows1>0){
while($ads_dates1=mysqli_fetch_assoc($result1)){
?>
آگهی برای شما وجود ندارد
دسته بندی ها
-
_conn) . mysqli_error($this->_conn);
return false;
}
$num_rows=mysqli_num_rows($result);
if($num_rows>0){
while($ads_dates=mysqli_fetch_assoc($result)){
?>
-
- بازگشت به دسته بندی cleansql($_GET['category']); $result1 = mysqli_query($con,"SELECT * FROM tbl_subcategory where cat_id='$cat_id' order By `order`"); if(!$result1) { echo mysqli_errno($this->_conn) . mysqli_error($this->_conn); return false; } $num_rows=mysqli_num_rows($result1); if($num_rows>0){ while($ads_dates1=mysqli_fetch_assoc($result1)){ ?>
-
- بازگشت به _conn) . mysqli_error($this->_conn); return false; } $num_rows=mysqli_num_rows($result1); if($num_rows>0){ while($ads_dates1=mysqli_fetch_assoc($result1)){ ?>
-
class="bold_li"
>
