/* 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);