'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ж' => 'zh', 'з' => 'z', 'и' => 'i', 'й' => 'y', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o', 'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'h', 'ц' => 'c', 'ч' => 'ch', 'ш' => 'sh', 'щ' => 'sht', 'ъ' => 'a', 'ь' => 'y', 'ю' => 'yu', 'я' => 'ya', 'А' => 'a', 'Б' => 'b', 'В' => 'v', 'Г' => 'g', 'Д' => 'd', 'Е' => 'e', 'Ж' => 'zh', 'З' => 'z', 'И' => 'i', 'Й' => 'y', 'К' => 'k', 'Л' => 'l', 'М' => 'm', 'Н' => 'n', 'О' => 'o', 'П' => 'p', 'Р' => 'r', 'С' => 's', 'Т' => 't', 'У' => 'u', 'Ф' => 'f', 'Х' => 'h', 'Ц' => 'c', 'Ч' => 'ch', 'Ш' => 'sh', 'Щ' => 'sht', 'Ъ' => 'a', 'Ь' => 'y', 'Ю' => 'yu', 'Я' => 'ya' ); return strtr($zagl, $latime); } /* ---------- */ // POST part // /* ---------- */ $url = ""; if($_SERVER['REQUEST_METHOD'] == "POST") { unset($_SESSION["searchData"]); $_SESSION["s_search"] = "1"; $_SESSION["s_area"] = ""; $_SESSION["s_spec"] = ""; $_SESSION["s_city"] = ""; $_SESSION["s_nonstop"] = ""; $_SESSION["s_soc"] = ""; $_SESSION["s_hlt"] = ""; $_SESSION["s_xray"] = ""; $_SESSION["s_kids"] = ""; $_SESSION["s_lang"] = ""; $searchData = new SearchData(); $searchData->area = $_POST["search_area"]; $searchData->city = $_POST["search_city"]; $searchData->spec = $_POST["search_spec"]; $searchData->lang = $_POST["search_lang"]; $searchData->nonstop = $_POST["search_nonstop"]; $searchData->soc = $_POST["search_soc"]; $searchData->hlt = $_POST["search_hlt"]; $searchData->xray = $_POST["search_xray"]; $searchData->kids = $_POST["search_kids"]; $_SESSION["searchData"] = $searchData; if(!empty($_POST["search_area"])) { if($_POST["search_area"] !== "none") { $url .= $_POST["search_area"] . "-"; } } $url .= "zabolekar"; if(!empty($_POST["search_spec"])) { if($_POST["search_spec"] !== "none") { $url .= "-" . $_POST["search_spec"]; } } if(!empty($_POST["search_city"])) { if($_POST["search_city"] !== "none") { $url .= "-" . $_POST["search_city"]; } } if($_POST["search_city"] == $_POST["search_area"]) { $url = str_replace($_POST["search_area"] . "-", "", $url); } if($_POST["search_city"] == "София" && $_POST["search_area"] == "София_град") { $url = str_replace("София_град-", "", $url); } $url .= ".html"; /* -------------- */ // REDIRECT part // /* -------------- */ header("Location: " . urlencode(getSEOUrl($url))); exit(); } /* --------- */ // GET part // /* --------- */ if(!isset($_GET) || empty($_GET)) { $_SESSION["s_area"] = ""; $_SESSION["s_spec"] = ""; $_SESSION["s_city"] = ""; $_SESSION["s_nonstop"] = ""; $_SESSION["s_lang"] = ""; $_SESSION["s_soc"] = ""; $_SESSION["s_hlt"] = ""; $_SESSION["s_xray"] = ""; $_SESSION["s_kids"] = ""; } $searchData = $_SESSION["searchData"]; if(!isset($_SESSION["s_search"]) || empty($_SESSION["s_search"]) || $_SESSION["s_search"] !== "1") { if(isset($_GET["var"]) && !empty($_GET["var"])) { $var = mysql_real_escape_string($_GET["var"]); $spec = sprintf("select dent_spec from spec where dent_spec_lat='%s'", $var); $spec_query = mysql_query($spec, $db1); if(mysql_num_rows($spec_query) > 0) { $spec_row = mysql_fetch_array($spec_query); $_SESSION["s_spec"] = $spec_row["dent_spec"]; $_SESSION["s_search"] = "1"; header("Location: http://stomatolozi.bg/zabolekar-" . $var . ".html"); exit(); } } } if(isset($_GET["var"]) && !empty($_GET["var"])) { $var = mysql_real_escape_string($_GET["var"]); $spec = sprintf("select dent_spec from spec where dent_spec='%s'", $var); $spec_query = mysql_query($spec, $db1); if(mysql_num_rows($spec_query) < 1) { $city = $var; $spec = ""; } else { $city = ""; $spec = $var; } } $q = "and "; $meta = "Зъболекари -"; $title[0] = ""; $title[1] = " зъболекар"; if(isset($searchData->spec) && !empty($searchData->spec) && $searchData->spec !== "none") { $spec = mb_strtolower(mysql_real_escape_string($searchData->spec)); $q .= "(dent_spec1 = '$spec' or dent_spec2 = '$spec' or dent_spec3 = '$spec') and "; $meta .= " " . $spec; $title[3] = " " . $spec; } if(isset($searchData->city) && !empty($searchData->city) && $searchData->city !== "none") { $city = mysql_real_escape_string($searchData->city); $q .= "dent_city = '$city' and "; $meta .= " в град " . str_replace("_", " ", $city); $title[4] = " град " . str_replace("_", " ", $city); } if(isset($searchData->area) && !empty($searchData->area) && $searchData->area !== "none") { $area = mysql_real_escape_string($searchData->area); $q .= "dent_area = '$area' and "; } if(isset($searchData->lang) && !empty($searchData->lang)) { $lang = mysql_real_escape_string($searchData->lang); $q .= "dent_lang like '%$lang%' and "; } if(isset($searchData->nonstop) && !empty($searchData->nonstop)) { $meta .= ", денонощен"; $title[0] = " денонощен"; date_default_timezone_set("Europe/Sofia"); $weekday = date("l", time()); switch ($weekday) { case "Monday": $q .= "monday_start = '00:00' and monday_end = '24:00' and "; break; case "Tuesday": $q .= "tuesday_start = '00:00' and tuesday_end = '24:00' and "; break; case "Wednesday": $q .= "wednesday_start = '00:00' and wednesday_end = '24:00' and "; break; case "Thursday": $q .= "thursday_start = '00:00' and thursday_end = '24:00' and "; break; case "Friday": $q .= "friday_start = '00:00' and friday_end = '24:00' and "; break; case "Saturday": $q .= "saturday_start = '00:00' and saturday_end = '24:00' and "; break; case "Sunday": $q .= "sunday_start = '00:00' and sunday_end = '24:00' and "; break; } } if(isset($searchData->soc) && !empty($searchData->soc) && $searchData->soc !== "none") { $soc = ", " . mysql_real_escape_string($searchData->soc) . ","; $q .= "dent_social like '%$soc%' and "; } if(isset($searchData->hlt) && !empty($searchData->hlt)) { $q .= "dent_social like '%0%' and "; $meta .= ", НЗОК"; $title[5] = ", НЗОК"; } if(isset($searchData->xray) && !empty($searchData->xray)) { $s_xray = mysql_real_escape_string($searchData->xray); $q .= "dent_xray = '$s_xray' and "; $meta .= ", рентген"; $title[6] = ", рентген"; } if(isset($searchData->kids) && !empty($searchData->kids)) { $s_kids = mysql_real_escape_string($searchData->kids); $q .= "dent_kids = '$s_kids' and "; $meta .= ", детски"; $title[7] = ", детски"; } $q = substr($q, 0, -4); /* if($q !== false) { $q = "where " . $q; } */ $query = sprintf("select distinct dent_name, dent_user, dent_email, dent_spec1, dent_spec2, dent_spec3, dent_online, dent_city, dent_address, dent_phone1, dent_phone2, dent_phone3, dent_profile, monday_start, monday_end, tuesday_start, tuesday_end, wednesday_start, wednesday_end, thursday_start, thursday_end, friday_start, friday_end, saturday_start, saturday_end, sunday_start, sunday_end from personal left join contacts on personal.dent_id = contacts.dent_id left join media on personal.dent_id = media.dent_id left join work on personal.dent_id = work.dent_id where personal.dent_id != '10009' and personal.dent_id != '10000' %s ", $q); $result = mysql_query($query, $db1); ?> <?php foreach($title as $titlewords) { echo $titlewords; } ?>
Условия за ползване на Stomatolozi.BG Затвори
Stomatolozi.BG

Зъболекари България онлайн

Намерете най-пълната и прозрачна информация за българските стоматолози и изберете при кого да отидете

Зъболекарите, които Ви представяме, са едни от най-амбициозните професионалисти в областта, в която работят. Те винаги са на ръба на вълната и използват най-новите технологии, най-качествените консумативи и най-ефективните методи за работа и комуникация с пациентите си. Ако си търсите зъболекар по някакви по-специални критерии, използвайте филтъра по-горе, за да не се налага да разглеждате всички членове на Стоматолози.БГ един по един. Зъболекарите, които излизат със снимка в резултатите, имат ПРО акаунти при нас и собствени профили, на които ще можете да прочетете всичката Ви необходима информация за тях.

Няма намерени резултати.
">
&h=120&zc=0&q=100" alt="" />
Д-р
Общопрактикуващ