{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}*/
//получаем кол-во новостей на один регион
//получаем необходимые параметры из базы
list($region_count, $city_count, $extra_key_count) = getTablesRecordCount($con);
echo "region_count: " . $region_count . "<br/>";
echo "city_count: " . $city_count . "<br/>";
echo "extra_key_count: " . $extra_key_count . "<br/>";
$news_count_for_posting = $region_count * $news_per_region;
echo "news_count_for_posting: " . $news_count_for_posting . "<br/>";
//получаем список всех новостей, у которых время постинга больше текущего времени на 5 мин
$news_for_posting_array = getNewsIdForPostingArray($con, $news_count_for_posting);
echo var_dump($news_for_posting_array);
$server_name = $argv[1];
for ($i = 0; $i < count($news_for_posting_array); $i++) {
postNews($con, $news_for_posting_array[$i]);
$result_array = getPageInfo($con, $news_for_posting_array[$i]);
$href = "/" . str_replace(" ", "-", $result_array["region_name_latin"]) . "/" . str_replace(" ", "-", $result_array["city_page_key"]) . ".html";
$url = "http://" . $server_name . $href;
$ch = curl_init();
curl_setopt($ch, CURLOPT_TIMEOUT, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_exec($ch);
echo "curl_exec executed..." . "<br/>";
curl_close($ch);
echo $url . "<br/>";
}
//случайно выбараем
mysqli_close($con);
unset($con);
</form>
<?php
if (isset($_POST['editProfile'])) {
//check for CSRF
if ($_SESSION['token'] !== $_POST['token']) {
echo "error";
die("Request forgery detected");
}
header("Location: editProfile.php");
}
?>
<?php
showProfile();
postNews();
?>
<?php
function showNewsWComments()
{
require 'database.php';
$name = $_SESSION['userAccount'];
//show posted stories
$stmt = $mysqli->prepare("SELECT * FROM news WHERE poster=?");
if (!$stmt) {
printf("Query Prep Failed: %s\n", $mysqli->error);
exit;
}
$stmt->bind_param('s', $name);
$stmt->execute();
$result = $stmt->get_result();