/* instead of bind_result: */
#echo "get result...";
if (!mysqli_stmt_bind_result($stmt, $anchor_name, $city_name, $city_name_latin, $key_value, $key_value_latin, $region_name, $region_name_latin, $posted_time, $region_id)) {
#echo "Getting results failed: (" . mysqli_connect_errno() . ") " . mysqli_connect_error();
}
$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> ";
//
}
$template = preg_replace("/\\[CITY_NEWS_1\\]/", "<br/>Новостей по данному региону не найдено", $template);
$template = preg_replace("/\\[PAGER\\]/", "", $template);
}
//fill [BREAD_CRUMBS]
$bread_crumbs = "<a href =\"/#\">Главная</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);
//if page exist
if ($key_info) {
//fill [BREAD_CRUMBS]
$bread_crumbs = "<a href =\"http://" . $site_main_domain . "\">Главная</a> > <a href =\"#\">" . $key_info['key_value'] . " " . rusdate($key_info['posted_time'], 'j %MONTH% Y') . "</a>";
} else {
#PAGE NOT FOUND REDIRECT
header('HTTP/1.1 404 Not Found');
#header('Location: /');
$_GET['e'] = 404;
include $_SERVER['DOCUMENT_ROOT'] . '/404.html';
exit;
}
}
if ($current_page_type == "KEY_PAGE") {
$template = fillSnippetsContent($template, $key_info['key_value'], $con, $page_key);
//delete all unnecessary templates anchors
for ($i = 0; $i < 9; $i++) {
$template = preg_replace("/\\[SNIPPET_TITLE_" . ($i + 1) . "\\]/", '', $template);
$template = preg_replace("/\\[SNIPPET_CONTENT_" . ($i + 1) . "\\]/", '', $template);
"city_name_latin"=>$city_name_latin,
"key_value"=>$key_value,
"key_value_latin"=>$key_value_latin,
"region_name"=>$region_name,
"region_name_latin"=>$region_name_latin,
"posted_time"=>$posted_time*/
#echo var_dump($key_info);
//if page exist
if ($key_info) {
$region_name = $key_info['region_name'];
//generate header menu
$caseSelector = new CaseValueSelector();
$city_cases = array();
$city_cases = $caseSelector->getCaseTitle($con, 1, $caseSelector->getCityValueByNewsKey($con, $url_city));
//fill [BREAD_CRUMBS]
$bread_crumbs = "<a href =\"/\">Главная</a> > <a href =\"/" . $url_region . "/\">" . $region_name . "</a> > <a href =\"#\">" . $key_info['city_name'] . " " . $key_info['key_value'] . " " . rusdate($key_info['posted_time'], 'j %MONTH% Y') . "</a>";
} else {
#PAGE NOT FOUND REDIRECT
header('HTTP/1.1 404 Not Found');
#header('Location: /');
$_GET['e'] = 404;
include $_SERVER['DOCUMENT_ROOT'] . '/404.html';
exit;
}
}
for ($i = 1; $i <= 9; $i++) {
$page_title = preg_replace("/\\[REGION_CASE_" . $i . "\\]/", isset($region_cases["{$i}"]) ? $region_cases["{$i}"] : "", $page_title);
$page_title = preg_replace("/\\[CITY_CASE_" . $i . "\\]/", isset($city_cases["{$i}"]) ? $city_cases["{$i}"] : "", $page_title);
}
$page_title = preg_replace("/\\[REGION_NAME\\]/", $region_name, $page_title);
if ($current_page == "CITY_PAGE") {
/* instead of bind_result: */
#echo "get result...";
if (!mysqli_stmt_bind_result($stmt, $key_value, $key_value_latin, $posted_time)) {
#echo "Getting results failed: (" . mysqli_connect_errno() . ") " . mysqli_connect_error();
}
$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 = \"http://" . $site_main_domain . "/" . $key_value_latin . "/\">" . $key_value . " (" . 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);
#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/>Новостей по данному региону не найдено", $template);
$template = preg_replace("/\\[PAGER\\]/", "", $template);
}
//fill [BREAD_CRUMBS]
$bread_crumbs = "<a href =\"/#\">Главная</a> ";
//
//}
// ТАБЛИЦА ЗАКОНЧИЛАСЬ
// echo "</tr>";
// echo "</table>";
//echo "</form>";
//}
echo "</div>";
// ------ Счетчик посетителей онлайн - начало
$now_online = mysql_result(mysql_query("SELECT COUNT(*) FROM `session`"), 0, 0);
echo "<center>";
echo "Сейчас с нами ";
echo $now_online;
if ($now_online == 1) {
echo " посетитель";
} elseif ($now_online == 0 || $now_online > 4) {
echo " посетителей";
} else {
echo " посетителя";
}
echo "</center>";
// ------ Счетчик посетителей онлайн - конец
// ------ Значек электронной накладной
echo "<div class='waybill'><a href='waybill.php' alt='электронная накладная на перемещение'><img src='./img/nakl.png' alt='электронная накладная на перемещение'></a></div>";
// ------ Вывод сегоднешней даты
echo "<div class='today1'>Сегодня " . rusdate(time(), '%DAYWEEK%, j %MONTH% Y') . "</div>";
echo "<center>All rights reserved 2015<a href=./admin/add_admin.php>.</a></center>";
echo "</body>";
// Освобождаем ресурсы, ассоциированные с результатом
// Это делается автоматически в конце скрипта
mysql_free_result($result);
#mysql_free_result($result2);
