PHP get_city_id_by_asciiname Examples

Example #1

File: page_search.php Project: zeamxie/jobberbase

    $url_query = trim($_POST['keywords']);
}
if ($id != '' && !strstr($id, '|')) {
    $keywords = $db->real_escape_string(trim($id));
} else {
    if (!empty($requestKeywords) && $requestKeywords != $translations['search']['default']) {
        $keywords = $db->real_escape_string(trim($requestKeywords));
    } else {
        if (strstr($id, '|')) {
            $tmp = explode('|', $id);
            $categ = trim($tmp[0]);
            $keywords = trim($tmp[1]);
            $keywords = str_replace('"', '', urldecode($keywords));
            // clicked on a city on the map
            if (isset($tmp[2]) && $tmp[2] == 'map') {
                $city = get_city_id_by_asciiname($keywords);
                $keywords = $city['name'];
            }
        } else {
            redirect_to(BASE_URL);
            exit;
        }
    }
}
// record search keywords
$_SESSION['search_keywords'] = $keywords;
$is_home = false;
if ($keywords == '' || $keywords == ' ') {
    if ($categ == '') {
        $smarty->assign('no_categ', 1);
    } else {

Example #2

File: page_city.php Project: zeamxie/jobberbase

<?php

$type_id = get_type_id_by_varname($extra);
$city_ascii_name = urldecode($id);
$city = get_city_id_by_asciiname($city_ascii_name);
if ($city) {
    $city_id = $city['id'];
    $jobCount = $job->GetJobsCountForCity($city_id, $type_id);
    $smarty->assign('jobs_count', $jobCount);
} else {
    redirect_to(BASE_URL . 'page-unavailable/');
    exit;
}
$paginatorLink = BASE_URL . URL_JOBS_IN_CITY . "/{$city_ascii_name}";
if (isset($extra)) {
    $paginatorLink .= "/{$extra}";
}
$paginator = new Paginator($jobCount, JOBS_PER_PAGE, @$_REQUEST['p']);
$paginator->setLink($paginatorLink);
$paginator->paginate();
$firstLimit = $paginator->getFirstLimit();
$lastLimit = $paginator->getLastLimit();
$the_jobs = array();
$the_jobs = $job->GetPaginatedJobsForCity($city_id, $firstLimit, JOBS_PER_PAGE, $type_id);
$smarty->assign("pages", $paginator->pages_link);
$smarty->assign('jobs', $the_jobs);
$smarty->assign('types', get_types());
$smarty->assign('city_name', $city['name']);
$smarty->assign('city_ascii_name', $city_ascii_name);
$smarty->assign('seo_title', 'Jobs in ' . $city['name']);
$smarty->assign('seo_desc', '');