// use your $myrow array as you would with any other fetch
#echo "City name: ".$city_name."; key: ".$key_value;
//generate link name
$updTitle = "";
#echo "upd_flg: ".$upd_flg;
#echo "page_content_count: ".$page_content_count;
if ($total_cnt == $posted_cnt && $upd_flg == 1) {
$updTitle = "Information updated | ";
}
$city_href = "<a href = \"http://" . $site_main_domain . "/" . $key_value_latin . "/\">" . $updTitle . $key_value . " (" . engdate($posted_time, 'jS \\of F, h:i:s A') . ")</a><br/>";
$news_block = $news_block . $city_href;
}
$template = preg_replace("/\\[CITY_NEWS_1\\]/", $news_block, $template);
#echo "news_block: ".$news_block."<br>";
$pager = new Pager();
$template = preg_replace("/\\[PAGER\\]/", $pager->getPageNavigation("/", $key_page_number, $max_page_number), $template);
/* explicit close recommended */
mysqli_stmt_close($stmt);
} else {
$template = preg_replace("/\\[CITY_NEWS_1\\]/", "<br/>No any news were found", $template);
$template = preg_replace("/\\[PAGER\\]/", "", $template);
}
//fill [BREAD_CRUMBS]
$bread_crumbs = "<a href =\"/#\">Main</a> ";
//
}
$key_info = array();
if ($current_page_type == "KEY_PAGE") {
//get city page info
#echo "page_key: ".$page_key."<br/>";
$key_info = getKeyInfo($con, $page_key);
$news_block = "";
$cur_news_posted_time = "";
while (mysqli_stmt_fetch($stmt)) {
if ($cur_news_posted_time != rusdate($posted_time, 'j %MONTH% Y')) {
$cur_news_posted_time = rusdate($posted_time, 'j %MONTH% Y');
$news_block = $news_block . "<br/><h3>" . $cur_news_posted_time . "</h3>";
}
// use your $myrow array as you would with any other fetch
#echo "City name: ".$city_name."; key: ".$key_value;
//generate link name
$city_href = "<a href = \"/" . str_replace(" ", "-", $region_name_latin) . "/" . str_replace(" ", "-", $city_name_latin . " " . $key_value_latin) . ".html\">" . $anchor_name . " (" . rusdate($posted_time, 'j %MONTH% Y, G:i') . ")</a><br/>";
$news_block = $news_block . $city_href;
}
$template = preg_replace("/\\[CITY_NEWS_1\\]/", $news_block, $template);
$pager = new Pager();
$template = preg_replace("/\\[PAGER\\]/", $pager->getPageNavigation("/" . str_replace(" ", "-", $region_name_latin) . "/", $city_news_page_number, $max_page_number), $template);
/* explicit close recommended */
mysqli_stmt_close($stmt);
} else {
$template = preg_replace("/\\[CITY_NEWS_1\\]/", "<br/>Новостей по данному региону не найдено", $template);
$template = preg_replace("/\\[PAGER\\]/", "", $template);
}
//fill [BREAD_CRUMBS]
$bread_crumbs = "<a href =\"/\">Главная</a> > <a href =\"#\">" . $region_name . "</a> ";
//
}
$key_info = array();
if ($current_page == "CITY_PAGE") {
//get city page info
$key_info = getKeyInfo($con, $url_city);
#echo "url_city: ".$url_city."<br/>";
