"; // echo $get_categoria."
"; // echo $get_subcategoria."
"; // echo $get_subcategoria2."
"; // echo $get_judet."
"; // echo $get_pret_max."
"; // echo $get_moneda."
"; if (!isset($page)) { $page = 1;} if($page > 1){ $nr_pagina = " - pagina ".$page;}else{$nr_pagina="";} $adjacents = 3; $query = "SELECT titlu, anunt, platit, therank, vizibil, ts_headline(titlu || ' ' || anunt, q) as htmlmarked_summary FROM (SELECT titlu, anunt, platit, vizibil, ts_rank_cd('{0,0,0.9,0.10}', ftext_weighted, q) as therank, q FROM anunt_post, to_tsquery('(".$termen.") & (".$termen.")') as q WHERE ftext_weighted @@ q and vizibil='1' ORDER BY platit DESC, therank DESC) As results"; $res = query2array($query, $conn); $total_pages = count($res); $limit = 10; $i_max = $limit; $i_min = ($page - 1) * $limit; if($page > 1){ $i_limit = "offset $i_min limit $i_max"; }else{ $i_limit = "limit $i_max"; } $query = "SELECT id, categ, subcateg, subcateg2, id_judet, localitate2,pret,moneda, titlu, anunt, platit, therank, vizibil, ts_headline(titlu || ' ' || anunt, q) as htmlmarked_summary FROM (SELECT id, categ,subcateg, subcateg2, id_judet, localitate2,pret,moneda, titlu, anunt, platit, vizibil, ts_rank_cd('{0,0,0.9,0.10}', ftext_weighted, q) as therank, q FROM anunt_post, to_tsquery('(".$termen.") & (".$termen.")') as q WHERE ftext_weighted @@ q and vizibil='1' ORDER BY platit DESC, therank DESC) As results $i_limit"; $anunturi = query2array($query, $conn); //echo $query; $numar_anunturi = count($anunturi); $no_reclame_google = ""; for($i=0;$i".$result[$i]["categ"]."-".$result[$i]["subcateg"]."-".$result[$i]["subcateg2"]."
"; $query = "select nume from categorii where id = '".$anunturi[$i]["categ"]."' limit 1"; $nume_categorie = query2array($query, $conn); $anunturi[$i]["nume_categorie"] = $nume_categorie[0]["nume"]; $query = "select nume from subcategorii where id = '".$anunturi[$i]["subcateg"]."' limit 1"; $nume_subcategorie = query2array($query, $conn); $anunturi[$i]["nume_subcategorie"] = $nume_subcategorie[0]["nume"]; $query = "select nume from subsubcategorii where id = '".$anunturi[$i]["subcateg2"]."' limit 1"; $nume_subsubcategorie = query2array($query, $conn); $anunturi[$i]["nume_subsubcategorie"] = $nume_subsubcategorie[0]["nume"]; $query = "select * from anunt_judet where id = '".$anunturi[$i]["id_judet"]."' limit 1"; $nume_judet = query2array($query, $conn); $anunturi[$i]["short_judet"] = $nume_judet[0]["short_judet"]; $query = "select * from anunt_oras where id = '".$anunturi[$i]["localitate2"]."' limit 1"; $nume_oras = query2array($query, $conn); $anunturi[$i]["denumire_oras"] = $nume_oras[0]["denumire_oras"]; $query = "select * from anunt_moneda where id_moneda = '".$anunturi[$i]["moneda"]."' limit 1"; $nume_moneda = query2array($query, $conn); $anunturi[$i]["den_moneda"] = $nume_moneda[0]["den_moneda"]; /////// SELECT IMAGINI $query = "SELECT min(id) as id from imagini where id_anunt='".$anunturi[$i]["id"]."' limit 1"; $imagine_id = query2array($query, $conn); if(count($imagine_id)>0){ if(!is_null($imagine_id[0]["id"])){ $id_imagine = $imagine_id[0]["id"]; $query = "SELECT * from imagini where id='$id_imagine' limit 1"; $imagine_anunt = query2array($query, $conn); $fileParts[0]["data"] = pathinfo($imagine_anunt[0]["nume_fisier"]); list($width, $height, $type, $attr) = getimagesize($fileSave.$fileSaveThumb.$imagine_anunt[0]["nume"]); $anunturi[$i]["imagine_dimensiuni"] = $attr; $anunturi[$i]["extensie_imagine"] = $fileParts[0]["data"]["extension"]; $anunturi[$i]["id_imagine"] = $id_imagine; } } ////// END SELECT IMAGINI $anunturi[$i]["titlu_rescris"] = replace(strtolower($anunturi[$i]["titlu"])); $position=100; $limit_anunt=substr($anunturi[$i]["anunt"], 0, $position); $search = array("•", "€","“","”","„","—","–","‘","’","â","ã","î","ê","²","ș","ț"); $replace= array("•","€","“","”","„","—","–","‘","’","â","ã","î","ê","²","ș","ț"); $anunturi[$i]["categorie"] = str_replace(" ","-", strtolower($anunturi[$i]["nume_categorie"])); $anunturi[$i]["subcategorie"] = str_replace(" ","-", strtolower($anunturi[$i]["nume_subcategorie"])); $anunturi[$i]["subsubcategorie"] = str_replace(" ","-", strtolower($anunturi[$i]["nume_subsubcategorie"])); $anunturi[$i]["anunt_mic"] = str_replace($search, $replace, $limit_anunt); } $query ="select * from anunt_search where keyword like '$ati_cautat'"; $rezultat = query2array($query, $conn); if(count($rezultat) > 0 ){ $query ="update anunt_search set value = value+1, results = '$numar_anunturi' where id = '".$rezultat[0]["id"]."'"; $conn->query($query); }else{ $query ="insert into anunt_search (value, keyword, results, data) values('1','$ati_cautat','$numar_anunturi',now())"; $conn->query($query); } $tpl->assign("anunturi",$anunturi); $keywords = replace_in_keywords($ati_cautat); $title= "Anunturi ".$ati_cautat. $nr_pagina; $keywords = "anunturi, ".$keywords; $description = "Cautarea dupa termenul ".$ati_cautat." a intors urmatoarea lista de anunturi". $nr_pagina; $pagina = "search"; $tpl->assign("pagina",$pagina); $tpl->assign("nr_pagina",$nr_pagina); }else{ $mesaj_lipsa_termen = "Va rugam introduceti un termen de cautare"; $title= "Cauta anunturi"; $keywords = "cauta anunturi"; $description = "pentru a putea cauta anunturi introduceti un termen de cautare"; } } if ($page == 0) $page = 1; $prev = $page - 1; $next = $page + 1; if($total_pages > 0){ $lastpage = ceil($total_pages/$limit); } $lpm1 = $lastpage - 1; $pagination = ""; if($lastpage > 1) { $pagination .= "

"; //previous button if ($page > 1) $pagination.= "« "; else $pagination.= "« "; //pages if ($lastpage < 5 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } $pagination.= "..."; $pagination.= "".$lpm1.""; $pagination.= "".$lastpage.""; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "2"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } $pagination.= "..."; $pagination.= "".$lpm1.""; $pagination.= "".$lastpage.""; } //close to end; only hide early pages else { $pagination.= "2"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "".$counter.""; else $pagination.= "".$counter.""; } } } //next button if ($page < $counter - 1) $pagination.= " »"; else $pagination.= " »"; $pagination.= "

\n"; } $tpl->assign("pagination",$pagination); $tpl->assign("mesaj_lipsa_termen",$mesaj_lipsa_termen); $tpl->assign("title",$title); $tpl->assign("keywords",$keywords); $tpl->assign("description",$description); $tpl->assign("numar_anunturi",$numar_anunturi); $tpl->assign("webPath",$webPath); $tpl->assign("anunturi",$anunturi); $tpl->assign("ati_cautat",$ati_cautat); $tpl->assign("no_reclame_google",$no_reclame_google); $tpl->display("search.tpl"); ?>