>><<<|limit_search='.$limit.'>>><<<|lim='.$_SESSION['lim'].'>>>'; if(isset($_SESSION['lim'])) $limit=$_SESSION['lim']; } else { */ //echo_pre($_REQUEST); $from="FROM `baza` "; $where_str=" where `VIZIBIL` = 1"; if(isset($_REQUEST['litera'])) { $where_str.=" and `FIRMA` like '".$_REQUEST['litera']."%'"; } $stradares=""; if(isset($_REQUEST['strada']) and !empty($_REQUEST['strada'])) { $strada=mysql_fetch_array(mysql_query("SELECT * FROM `strazi` WHERE `id`=".$_REQUEST['strada'])); $where_str.= " and `STRADA`='".$strada['Field1']."'"; $stradares=$_REQUEST['strada']; } if(isset($_REQUEST['domeniu']) and !empty($_REQUEST['domeniu'])) { $where_str.= " and `DOM01` like'%".$_REQUEST['domeniu']."%'"; } if(isset($_REQUEST['nr_dom']) and !empty($_REQUEST['nr_dom'])) { $where_str.= " and `FIRMA` like '%".$_REQUEST['nr_dom']."%'"; } if(isset($_REQUEST['i']) and !empty($_REQUEST['i'])) { $plus=''; $current_s=array(); $current_0_full=''; $current_i=str_replace(' baia mare', '', strtolower($_REQUEST['i'])); $current_i=str_replace('baia mare ', '', $current_i); $current_i=str_replace(' maramures', '', $current_i); $current_i=str_replace('maramures ', '', $current_i); //if(in_array(strtolower($current_i), $cuvinte_calde)) $dupa='dupa_titlu'; $current_i=explode(" ", $current_i); $nr_cuv_titlu=count($current_i); //if(isset($_REQUEST['s']) and !empty($_REQUEST['s'])) $current_s=explode(" ", strtolower($_REQUEST['s'])); $current=array_merge($current_s, $current_i); //foreach($current as $curr_1) //{ //if(in_array(strtolower($curr_1), $cuvinte_calde)) $plus="+"; //echo 'curent= '.strtolower($curr_1).' | plus= '.$plus.' | if= '.in_array(strtolower($curr_1), $cuvinte_calde).' | array= '.$cuvinte_calde[2].'
'; //} //if($_SESSION['dupa']=="" and $dupa=="dupa_exp") $dupa="dupa_cuv"; $pos = strpos(strtolower($_REQUEST['i']), "auto"); if($pos !== false) { $plus='+'; } foreach($current as $curr) { if(!empty($curr) and strlen($curr) > 3 and strtolower($curr)!='plus' and strtolower($curr)!='second' and strtolower($curr)!='best' and strtolower($curr)!='only' and strtolower($curr)!='seven' and strtolower($curr)!='inner') { // verific vocale if($dupa=='dupa_exp' or $dupa=='dupa_titlu') $plus="+"; /* if($_SERVER['SERVER_NAME']=='www.bucuresti0.ro') $plus=""; if($_SERVER['SERVER_NAME']=='www.afaceriro.ro') $plus=""; */ $current_0_final=$curr; $current_0_count=strlen($curr); if($current_0_count>=5) { $vocale=substr($curr, -1); $vocale_count=$current_0_count-1; if($vocale=="a" or $vocale=="e" or $vocale=="i" or $vocale=="u" or $vocale=="n") $current_0_final=substr($curr, 0, $vocale_count); } if($current_0_count>=6) { $vocale=substr($curr, -2); $vocale_count=$current_0_count-2; if($vocale=="le") $current_0_final=substr($curr, 0, $vocale_count); } if($current_0_count>=7) { $vocale=substr($curr, -3); $vocale_count=$current_0_count-3; if($vocale=="ane") $current_0_final=substr($curr, 0, $vocale_count); } if($current_0_count>=7) { $vocale=substr($curr, -3); $vocale_count=$current_0_count-3; if($vocale=="uri") $current_0_final=substr($curr, 0, $vocale_count); } // end verific vocale $current_0_full.=' '.$plus.$current_0_final.'*'; } else { $and_ul='and'; if($dupa=='dupa_cuv') $and_ul='or'; if((!empty($curr) and strlen($curr) == 3) or strtolower($curr)=='plus' or strtolower($curr)=='second' or strtolower($curr)=='best' or strtolower($curr)=='only' or strtolower($curr)=='seven' or strtolower($curr)=='inner') { if($dupa=='dupa_titlu') { $where_str_32.= ' '.$and_ul.' ((`FIRMA` like "'.$curr.' %" or `FIRMA` like "% '.$curr.' %") or (`FIRMA` like "'.$curr.',%" or `FIRMA` like "% '.$curr.',%" or `FIRMA` like "% '.$curr.'"))'; }else{ $where_str_32.= ' '.$and_ul.' ((`OBIECT_ACTIVITATE` like "'.$curr.' %" or `FIRMA` like "'.$curr.' %" or `OBIECT_ACTIVITATE` like "% '.$curr.' %" or `FIRMA` like "% '.$curr.' %") or (`OBIECT_ACTIVITATE` like "'.$curr.',%" or `FIRMA` like "'.$curr.',%" or `OBIECT_ACTIVITATE` like "% '.$curr.',%" or `FIRMA` like "% '.$curr.',%" or `OBIECT_ACTIVITATE` like "% '.$curr.'" or `FIRMA` like "% '.$curr.'"))'; } } } } if($current_0_full=='') { if(empty($where_str_32)) $where_str_32= ' and `FIRMA` like "aaa"'; $where_str.= $where_str_32; }else{ if($where_str_32=='') { if($dupa=='dupa_titlu') { $where_str.= " and (MATCH (`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))"; }else{ $where_str.= " and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))"; } }else{ if($dupa=='dupa_titlu') { $where_str.= " and (MATCH (`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))".$where_str_32; }else{ $where_str.= " and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))".$where_str_32; } } } } if(isset($_REQUEST['indiciu']) and !empty($_REQUEST['indiciu'])) { /* $dataora=date('Y-m-d H:i:s'); mysql_query('INSERT INTO `caut` ( `cauta`, `data`) VALUES ("'.strtolower($_REQUEST['indiciu']).'", "'.$dataora.'")'); $sel_cauta=mysql_fetch_array(mysql_query("SELECT * FROM `caut` WHERE (`cauta` like '%sex%' or `cauta` like '%fut%' or `cauta` like '%porno cu animale%' or `cauta` like '%porno%' or `cauta` like '%femei%' or `cauta` like '%fete%' or `cauta` like '%pula%' or `cauta` like '%pizd%' or `cauta` like '%muie%' or `cauta` like '%xxx%' or `cauta` like '%pule%') and `data`='".$dataora."'")); if(!empty($sel_cauta)) { mysql_query('DELETE FROM `caut` WHERE `data`="'.$dataora.'"'); } */ $current_0_full=''; $plus=''; $current=explode(" ", strtolower($_REQUEST['indiciu'])); $nr_cuv_titlu=count($current); $pos = strpos(strtolower($_REQUEST['indiciu']), "auto"); if($pos !== false) { $plus='+'; } foreach($current as $curr) { //echo 'current= '.strlen($curr); if(!empty($curr) and strlen($curr) > 3 and strtolower($curr)!='plus' and strtolower($curr)!='second' and strtolower($curr)!='best' and strtolower($curr)!='only' and strtolower($curr)!='seven' and strtolower($curr)!='inner') { // verific vocale if($dupa=='dupa_exp' or $dupa=='dupa_titlu') $plus="+"; $current_0_count=strlen($curr); if($current_0_count>=8) { $vocale=substr($curr, -2); $vocale_count=$current_0_count-2; if($vocale=='\"') { $curr=substr($curr, 0, $vocale_count); $plus="+"; } } $current_0_final=$curr; if($current_0_count>=5) { $vocale=substr($curr, -1); $vocale_count=$current_0_count-1; if($vocale=="a" or $vocale=="e" or $vocale=="i" or $vocale=="u" or $vocale=="n") $current_0_final=substr($curr, 0, $vocale_count); } if($current_0_count>=6) { $vocale=substr($curr, -2); $vocale_count=$current_0_count-2; if($vocale=="le") $current_0_final=substr($curr, 0, $vocale_count); } if($current_0_count>=7) { $vocale=substr($curr, -3); $vocale_count=$current_0_count-3; if($vocale=="ane") $current_0_final=substr($curr, 0, $vocale_count); } if($current_0_count>=7) { $vocale=substr($curr, -3); $vocale_count=$current_0_count-3; if($vocale=="uri") $current_0_final=substr($curr, 0, $vocale_count); } // end verific vocale $ghilimele=substr($curr, 0, 2); if($ghilimele=='\"') { $current_0_final=substr($curr, 2, $vocale_count); $plus="+"; } if($current_0_final == "auto") { $current_0_full.=' +'.$current_0_final; }else{ $current_0_full.=' '.$plus.$current_0_final.'*'; } } else { $and_ul='and'; if($dupa=='dupa_cuv') $and_ul='or'; if((!empty($curr) and strlen($curr) == 3) or strtolower($curr)=='plus' or strtolower($curr)=='second' or strtolower($curr)=='best' or strtolower($curr)=='only' or strtolower($curr)=='seven' or strtolower($curr)=='inner') { if($dupa=='dupa_titlu') { $where_str_32.= ' '.$and_ul.' ((`FIRMA` like "'.$curr.' %" or `FIRMA` like "% '.$curr.' %") or (`FIRMA` like "'.$curr.',%" or `FIRMA` like "% '.$curr.',%" or `FIRMA` like "% '.$curr.'"))'; }else{ $where_str_32.= ' '.$and_ul.' ((`OBIECT_ACTIVITATE` like "'.$curr.' %" or `FIRMA` like "'.$curr.' %" or `OBIECT_ACTIVITATE` like "% '.$curr.' %" or `FIRMA` like "% '.$curr.' %") or (`OBIECT_ACTIVITATE` like "'.$curr.',%" or `FIRMA` like "'.$curr.',%" or `OBIECT_ACTIVITATE` like "% '.$curr.',%" or `FIRMA` like "% '.$curr.',%" or `OBIECT_ACTIVITATE` like "% '.$curr.'" or `FIRMA` like "% '.$curr.'"))'; } } } } if($current_0_full=='') { if(empty($where_str_32)) $where_str_32= ' and `FIRMA` like "aaa"'; $where_str.= $where_str_32; }else{ if($where_str_32=='') { if($dupa=='dupa_titlu' or ($nr_cuv_titlu==1 and isset($_GET['m_c']))) { $where_str.= " and (MATCH (`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))"; }else{ $where_str.= " and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))"; } }else{ if($dupa=='dupa_titlu' or ($nr_cuv_titlu==1 and isset($_GET['m_c']))) { $where_str.= " and (MATCH (`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))".$where_str_32; }else{ $where_str.= " and (MATCH (`OBIECT_ACTIVITATE`,`FIRMA`,`LOCALITATE`,`COD`) AGAINST ('".$current_0_full."' IN BOOLEAN MODE))".$where_str_32; } } } } $where_str=str_replace('`VIZIBIL` = 1 or', '`VIZIBIL` = 1 and', $where_str); //echo 'list_1= '.'SELECT * '.$from.$where_str.'
'; $anunt_exp=''; if(((isset($_REQUEST['indiciu']) and !empty($_REQUEST['indiciu'])) or (isset($_REQUEST['i']) and !empty($_REQUEST['i']))) and ($dupa=='dupa_exp' or $dupa=='dupa_titlu')) { $listing_sql='SELECT * '.$from.$where_str; $listing_query = mysql_query($listing_sql); if (mysql_affected_rows()==0) { $where_str=str_replace('+', '', $where_str); $where_str=str_replace(')) and ((', ')) or ((', $where_str); $anunt_exp='
ATENTIE!!!
Cautarea s-a facut dupa cuvinte deoarece nu s-au gasit expresii similare
'; } } //echo 'list_2= '.'SELECT * '.$from.$where_str.'
'; //echo '$current_0_full= '.$current_0_full; if(isset($_REQUEST['harta']) and !empty($_REQUEST['harta'])) { $where_str.= " and `LOC_H-V`>''"; } if(isset($_REQUEST['prezentare']) and !empty($_REQUEST['prezentare'])) { $where_str.= " and `NUM_POZ`>''"; } if(isset($_REQUEST['dom']) and !empty($_REQUEST['dom']) and !isset($_REQUEST['indiciu']) and !isset($_REQUEST['i'])) { $current=explode("_",$_GET['dom']); $current_domenii=@$current[0]; $current_dom=@$current[1]; $current_sub=@$current[2]; if(!empty($current_sub)) $where_str.= " and `DOM01` like '%".$current_sub."%'"; else { //if(strcmp($current_dom,$res['NRPRINC'])<>0) { $sql="SELECT * FROM `domenii` WHERE PRINC='$current_dom'"; $r=mysql_query($sql); $where_str.= " and ("; while($res=mysql_fetch_array($r)) { $tr.= " `DOM01` like'%".$res['NR']."%' or"; } $tr=trim($tr," or"); if(empty($tr)) $tr="0"; $where_str.= $tr.")"; } } } $orarul=""; if(isset($_REQUEST['orar']) and !empty($_REQUEST['orar'])) { if($_REQUEST['orar']==1) { $where_str.= " and `SAMBATA`>''"; $orarul="sambata"; } if($_REQUEST['orar']==2) { $where_str.= " and `DUMINICA`>''"; $orarul="duminica"; } if($_REQUEST['orar']==3) { $where_str.= " and `LUNI`='Non stop'"; $orarul="non stop"; } } include('include/array_url.php'); $url_cod='Romania'; $judet=''; if(isset($_REQUEST['orase']) and !empty($_REQUEST['orase']) and ($_SERVER['SERVER_NAME']=='www.afaceriro.ro' or $_SERVER['SERVER_NAME']=='afaceriro.ro' or $_SERVER['SERVER_NAME']=='www.afaceriromania.ro' or $_SERVER['SERVER_NAME']=='afaceriromania.ro')) { $judet=explode('_', $_REQUEST['orase']); $_SESSION['caut_oras']='';//$judet[0] $sql_judete='SELECT * FROM `judete` WHERE `nume_judet` like "'.$judet[0].'"'; $r_judete=mysql_query($sql_judete); if(mysql_fetch_array($r_judete)!='') { if($judet[0]!='Romania') $where_str.= " and `COD` like '".$judet[0]."%'"; } }else{ foreach($array_url as $url_key => $url_value) { if($_SERVER['SERVER_NAME']=='www.'.$url_value or $_SERVER['SERVER_NAME']==$url_value) $url_cod=$url_key; } if($_SERVER['SERVER_NAME']=='www.traseeurbane.ro' or $_SERVER['SERVER_NAME']=='traseeurbane.ro') $url_cod='Maramures'; if($_SERVER['SERVER_NAME']=='www.romm.ro' or $_SERVER['SERVER_NAME']=='romm.ro') $url_cod='Maramures'; if($_SERVER['SERVER_NAME']=='www.bucuresti0.ro' or $_SERVER['SERVER_NAME']=='bucuresti0.ro') $url_cod='Bucuresti'; if($url_cod!='Romania') $where_str.= " and `COD` like '%".$url_cod."%'"; } /*$where_str_cuvinte=str_replace('+', '', $where_str);*/ /*if(isset($_REQUEST['i']) and !empty($_REQUEST['i'])) { $listing_sql='SELECT * FROM (SELECT * '.$from.$where_str.')rezultat_1 union SELECT * FROM (SELECT * '.$from.$where_str_cuvinte.')rezultat_2 order by `CREDITE` desc, `DATA` desc'; }else{ $listing_sql='SELECT * '.$from.$where_str.' order by `CREDITE` desc, `DATA` desc'; }*/ $listing_sql='SELECT * '.$from.$where_str.' order by `CREDITE` desc, `TVA` desc, `DATA` desc'; //echo 'cuvant cautat = '.$_REQUEST['indiciu'].'__
'; //echo 'SQL = '.$listing_sql.'
'; //$_SESSION['sqlu']=$listing_sql; //$_SESSION['lim']=$limit; /*}*/ //echo 'listing = '.$listing_sql; /*$domenii=table_to_array("domenii","NR","DOMENII","","Toate domeniile");*/ $strazi=table_to_array("strazi","id","Field1","","Toate strazile"); //$orase=array("Toate judetele"=>"", "Maramures"=>"Maramures", "Satu Mare"=>"Satu Mare"); ?>

== test 4 ==

Afaceri Romania

=6) $_SESSION['contben']=1; ?>




Cazare, turism
   Maramures, Baia Mare

'.$res['DOMPRINC']./*$oras.*/' '; else $str.=''; if(strcmp($current_dom,$res['NRPRINC'])==0) $str.=subcategorii($res['NRPRINC'], $current_domenii).""; } echo $str; echo ''; } else { while($res=mysql_fetch_array($r)) { if(strcmp($current_dom,$res['NRPRINC'])==0 and empty($current_sub)) $str.=''; else $str.=''; if(strcmp($current_dom,$res['NRPRINC'])==0) $str.=subcategorii($res['NRPRINC'], $current_domenii, $res['DOMPRINC']).""; } echo $str; echo ''; } function subcategorii($id, $id1, $domprinc) { global $orase_get, $get_orase, $oras; /*if($id==99) $sql="SELECT * FROM `domenii` WHERE 1"; else*/ $sql="SELECT * FROM `domenii` WHERE PRINC='$id' order by DOMENII"; //$sql = "SELECT DISTINCT domenii.NR, domenii.DOMENII, baza.DOM01 FROM domenii, baza WHERE domenii.PRINC = '$id' order by domenii.DOMENII"; $r=mysql_query($sql); $str=""; while($res=mysql_fetch_array($r)) { $sql_1= "SELECT DISTINCT DOM01 FROM `baza` WHERE DOM01 like '%".$res['NR']."%'"; $r_1=mysql_query($sql_1); while($res_1=mysql_fetch_array($r_1)) { if(!empty($sql_1)) { $res_dom=str_replace("&", "%26", $res['DOMENII']); $res_dom=inlocuieste_pauze($res_dom); //echo 'idl='.$id1.' | res_dom='.$res_dom.'
'; if(strcmp($id1,strtolower(str_replace("+", " ", $res_dom)))==0) { $str.='"; "".$res['']."
"; } else { $str.='"; "".$res['']."
"; } break; } } } if(empty($str)) { return ""; }else{ return "".$str; } } /*$href="index.php?dom=0&limita=150&litera="; for($i=1;$i<26;$i++) { $litere.="".chr(64+$i)." "; } echo $litere."".chr(64+$i).""; strtolower, ucwords*/ ?>

Nunti, restaurante
   Baia Mare, Maramures


toate domeniile in ordine alfabetica | domenii active
Index alfabetic:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Ati cautat: Dacia logan diesel
Cauta produse, servicii, firme in Baia Mare, Oradea si alte localitati

> expresii > cuvinte > titlu judete