// 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/>";