= NOW() $gubungubun_name $gubungubun_name2 $guci order by updexpiry desc, no desc limit $pre_gaesu[pre]"; $pre_sel = mysqli_query($connect,$pre_sel); /********************************************documentos sobre articulo preminum***********************************************/ /********************************************documentos sobre articulo enfocado**************************************************/ $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $tipo=($aaa)?"and type='$aaa'":""; $tipo_usuario=($_GET['toc']=="todo")?"":" and jointype='N'"; $foc_sel = "select * from $mamulcode where mamultype='foc' $guci and gong='Y' $tipo $tipo_usuario and expiry >= NOW() order by updexpiry desc, no desc limit $pre_gaesu[foc]"; $foc_result = mysqli_query($connect,$foc_sel); /******************************************documentos sobre articulo enfocado**************************************************/ /********************************************documentos sobre articulo normal****************************************************/ $guci= ''; $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; if(mysqli_escape_string($_POST['global_busqueda']) ) { $buscar_index = " (gubun2 like '%" . mysqli_escape_string($_POST['global_busqueda']) . "%'"; $buscar_index .= " or address1 like '%" . mysqli_escape_string($_POST['global_busqueda']) . "%'"; $buscar_index .= " or address2 like '%" . mysqli_escape_string($_POST['global_busqueda']) . "%'"; $buscar_index .= " or location like '%" . mysqli_escape_string($_POST['global_busqueda']) . "%'"; $buscar_index .= " or etc like '%" . mysqli_escape_string($_POST['global_busqueda']) . "%')"; } $tipo=($aaa)?"and mamultype='$aaa'":""; $tipo_usuario=($_GET['hahaha']=="sangsearch" || $_GET['toc']=="todo")?"":" and jointype='N'"; $nor_sel = "select * from $mamulcode where (gong='Y' $guci $tipo $tipo_usuario $buscar_index and expiry >= NOW()) order by updexpiry desc, no desc limit $start_q1, $pre_gaesu[nor]"; $nor_result = mysqli_query($connect,$nor_sel); //echo $nor_sel; $nor_All = "select count(no) from $mamulcode where (gong='Y' $guci $tipo $tipo_usuario and expiry >= NOW()) "; $nor_All = mysqli_query($connect,$nor_All); $nor_All = mysqli_fetch_array($nor_All); /*******************************************documentos sobre articulo normal****************************************************/ /********************************************metodo al ver articulo en la informacion de articulo************************************************/ //-------------------------------------- informacion de articulo(cuando hace clic nombre)-------------------------------------// if($areanos) { $areadata = "select * from $gubuncode where no='$areanos'"; $areadata = mysqli_query($connect,$areadata); $areadata = mysqli_fetch_array($areadata); $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $tipo=($aaa)?"and mamultype='$aaa'":""; $tipo_usuario=($_GET['hahaha']=="sangsearch")?"":" and jointype='N'"; $nor_sel = "select * from $mamulcode where gubun2='$areadata[name]' $guci and gong='Y' $tipo $tipo_usuario order by updexpiry desc, no desc limit $start_q1, $scale1"; $nor_result = mysqli_query($connect,$nor_sel); $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $nor_All = "select count(no) from $mamulcode where gubun2='$areadata[name]' $guci $tipo and gong='Y' $tipo_usuario"; $nor_All = mysqli_query($connect,$nor_All); $nor_All = mysqli_fetch_array($nor_All); //echo $nor_sel; } //-------------------------------------informacion de articulo(cuando hace clic nombre)-------------------------------------// //--------------------------------------informacion de articulo2(cuando hace clic compra ,renta mensual, renta con deposito )-------------------------// if($aaa) { $areadata = "select * from $gubuncode where no='$areanoss'"; $areadata = mysqli_query($connect,$areadata); $areadata = mysqli_fetch_array($areadata); $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $tipo_usuario=($_GET['hahaha']=="sangsearch" || $_GET['toc']="todo")?"":" and jointype='N'"; $nor_sel = "select * from $mamulcode where gubun2='$areadata[name]' and gong='Y' $guci $tipo_usuario and type='$aaa' and expiry >= NOW() order by updexpiry desc, no desc limit $start_q1, $scale1"; $nor_result = mysqli_query($connect,$nor_sel); //echo $nor_sel; $nor_All = "select count(no) from $mamulcode where gubun2='$areadata[name]' $guci and gong='Y' $tipo_usuario and type='$aaa' and expiry >= NOW()"; $nor_All = mysqli_query($connect,$nor_All); $nor_All = mysqli_fetch_array($nor_All); } //--------------------------------------informacion de articulo2(cuando hace clic compra ,renta mensual, renta con deposito )-------------------------// /********************************************metodo al ver articulo en la informacion de articulo************************************************/ /*******************************************Lugar donde vea articulo en el ver articulo de area**************************************************/ if($areadae) { $areadata = "select * from $areacode where no='$areadae'"; $areadata = mysqli_query($connect,$areadata); $areadata = mysqli_fetch_array($areadata); $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $tipo=($aaa)?"and type='$aaa'":""; $tipo_usuario=($_GET['hahaha']=="sangsearch")?"":" and jointype='N'"; $nor_sel = "select * from $mamulcode where address1 like '%$areadata[name]%' and gong='Y' $tipo $guci $tipo_usuario and expiry >= NOW() order by updexpiry desc, no desc limit $start_q1, $scale1"; $nor_result = mysqli_query($connect,$nor_sel); $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $nor_All = "select count(no) from $mamulcode where address1 like '%$areadata[name]%' $guci $tipo and gong='Y' $tipo_usuario and expiry >= NOW()"; $nor_All = mysqli_query($connect,$nor_All); $nor_All = mysqli_fetch_array($nor_All); } /******************************************Lugar donde vea articulo en el ver articulo de area**************************************************/ /*******************************************lugar donde se aparece despues de buscar**************************************************************/ if($hahaha == 'sangsearch') { //&area1=$area1&area2=$area2&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk. buscque usando //&area1=$area1&area2=$area2&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk if(!$area2_haha) { $area2_haha = $area2; } $area1_1 = explode("-",$area1); $area2_1 = explode("-",$area2_haha); $area3_1 = explode("-",$area3); $addresseses = $area1_1[2].$area2_1; $jongru_1 = explode("-",$jongru); $jongru_2 = $jongru2; $sangsearch1 = ($area1_1[2])?" and address2 like '%$area1_1[2]%'":""; $sangsearch1 .= ($area2_1[2])?" and address2 like '%$area2_1[2]%'":""; $sangsearch1 .= ($area3_1[2])?" and address2 like '%$area3_1[2]%'":""; $sangsearch1 .= ($jongru[2])?"and gubun1='$jongru_1[2]' ":""; $sangsearch1 .= ($jongru2)?"and gubun2='$jongru_2' ":""; $sangsearch1 .= ($searchkkk)?"and id like '%$searchkkk%' ":""; //$sangsearch1 .= ($searchjongru && $searchjongru!="" && $searchjongru=="Y")?"and jointype='Y' ":"and jointype='N' "; //$sangsearch1 .= ($searchjongru && $searchjongru!="" && $searchjongru=="N")?"and jointype='N' ":"and jointype='N' "; $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $tipo=($aaa)?"and mamultype='$aaa'":""; $nor_sel = "select * from $mamulcode where no $sangsearch1 and gong='Y' $tipo $guci and expiry >= NOW() order by updexpiry desc, no desc limit $start_q1, $scale1"; $nor_result = mysqli_query($connect,$nor_sel); $nor_All = "select count(no) from $mamulcode where no $sangsearch1 and gong='Y' $tipo and expiry >= NOW()"; $nor_All = mysqli_query($connect,$nor_All); $nor_All = mysqli_fetch_Array($nor_All); } /*******************************************lugar donde se aparece despues de buscar**************************************************************/ $guci= ($estado[2])?"and address2 like '%$estado[2]%'":""; $guci .= ($ciudad[2])?"and address2 like '%$ciudad[2]%'":""; $tipo=($aaa)?"and mamultype='$aaa'":""; $tipo_usuario=($_GET['hahaha']=="sangsearch")?"":" and jointype='N'"; $foc_sel = "select * from $mamulcode where mamultype='hot' $tipo and expiry >= NOW() and gong='Y' $guci $tipo_usuario"; $foc_sel = mysqli_query($connect,$foc_sel); ?>
 
Inicio > Listado de venta de Particulares> Todas las ventas
"; break; case 'Industrial': $image = ""; break; case 'Terrenos': $image = ""; break; case 'Comercial': $image = ""; break; }?> "; } else {?>
"?>
[]
[ $foc_Row[gubun2] / $foc_Row[type] ] Precio: $sell_pay Área: $foc_Row[pyong]m² ";?>        

$item_view) { if($nor_sel_Row[itemcheck] == 'Y') { $itemimage = " "; } else { $itemimage = ""; } if($nor_sel_Row[boldcheck] == 'Y') { $boldstart = ""; $boldend = ""; } else { $boldstart = ""; $boldend = ""; } } else { $itemimage = ""; $boldstart = ""; $boldend = ""; } $namesss = explode("-",$nor_sel_Row[name]); $brsel = ($namesss[0] != "" || $namesss[0]!=null)?" ":""; $nameview =$brsel."[".$nor_sel_Row[gubun2]."] "; //----------------------------------------dividir item de negrita------------------------------------// ?>
Total registrados
Dirección Tipo Operación Dimensión Precio Socio Fecha Visitas
  $
$tpage) { $endpage = $tpage; } else { $endpage = $tempendpage; } $end = ceil($nor_All[0]/$scale1); if($cpage1 != 1) { echo " "; } if($startpage > 1) { $tempnum = $startpage - 1; echo " "; } for($j=$startpage; $j<=$endpage; $j++) { if($j == $cpage1) { echo "$j "; // pagina ahora } else { echo "$j "; } } if($endpage < $tpage) { $tempnum = $endpage + 1; echo " "; } if($cpage1 != $end && $nor_All[0] > $scale1) { echo " "; }// termino repartir pagina 2 ?>