function generate_recent_reviews($conn)
{
if (is_null($conn)) {
throw new Exception('Соединение с бд не было создано');
exit;
}
//$conn = new mysqli(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$sql_last_comments = "SELECT id, author, comment, date, quality FROM recent_reviews\r\n ORDER BY date DESC LIMIT 3;";
$last_comment_query = $conn->query($sql_last_comments);
$result_last_comment = mysqli_parse_array($last_comment_query);
echo "<div class=\"row recent_reviews\">";
echo "<div class=\"col-md-3\">";
echo " <h1>Последние отзывы</h1>";
echo "</div>";
foreach ($result_last_comment as $key => $value) {
echo <<<EOD
\t<div class="col-md-3">
\t<div class="rate-date"><span class="glyphicon glyphicon-time"> </span>{$value["date"]}</div>
\t<div><input type="hidden" class="rating" data-filled="fa fa-star fa-3x" data-empty="fa fa-star-o fa-3x" data-readonly value="{$value["quality"]}}"/></div>
\t<h1>{$value["author"]}</h1>
\t<div>
\t{$value["comment"]}
\t</div>
\t</div>
EOD;
}
echo "</div>";
mysqli_free_result($last_comment_query);
}
display_navigation("reviews");
?>
<div class="row">
<div class="center-block">
<a class="btn btn-primary btn-lg" role="button" onclick="$('#myModal').modal();"><span class="fa fa-pencil-square-o"></span> Оставить свой отзыв</a>
</div>
</div>
<div class="row reviews_list" id="reviews_list">
<?php
if (is_null($conn)) {
throw new Exception('Соединение с бд не было создано');
}
$sql_last_comments = "SELECT id, author, comment, date, quality FROM recent_reviews\r\n ORDER BY date DESC;";
$last_comment_query = $conn->query($sql_last_comments);
$result_last_comment = mysqli_parse_array($last_comment_query);
foreach ($result_last_comment as $key => $value) {
echo <<<EOD
\t<div class="reviews row">
\t\t<div class="col-md-3">
\t\t\t<div class="rate-date"><span class="glyphicon glyphicon-time"> </span>{$value["date"]}</div>
\t\t\t<div><input type="hidden" class="rating" data-filled="fa fa-star fa-3x" data-empty="fa fa-star-o fa-3x" data-readonly value="{$value["quality"]}}"/></div>
\t\t</div>
\t\t<div class="col-md-9">
\t\t\t<h1>{$value["author"]}</h1>
\t\t\t<div>
\t\t\t\t{$value["comment"]}
\t\t\t</div>
\t\t</div>
\t</div>
require_once "app_config.php";
/**Заголовок*/
require_once "scripts/generete_header.php";
$bootstrap = array('main' => true);
display_head("Quantum Reality", $bootstrap);
echo "<body>";
echo "<div class=\"container col-md-8 col-md-offset-2\">";
//8 Колонок Ширина и 2 отступ слева
/**Навигация*/
require_once "scripts/generate_navigation.php";
display_navigation("reserve");
require_once "db_config.php";
/**Квесты*/
$sql_get_quest = "SELECT id, game_name, image_link FROM game_list ORDER BY id DESC";
$quest_query = $conn->query($sql_get_quest);
$result_quest = mysqli_parse_array($quest_query);
echo "<div class=\"row\">";
foreach ($result_quest as $key => $value) {
echo <<<EOD
<div class="col-sm-6 col-md-4">
<div class="thumbnail hovereffect">
<img src="{$value["image_link"]}">
<div class="overlay">
<h2>{$value["game_name"]}</h2>
<a class="info" href="/game.php?project_id={$value["id"]}">Подробнее</a>
</div>
</div>
</div>
EOD;
}
echo "</div>";
$err_msg = "conn_instertection failed: " . mysqli_conn_instertect_error();
} else {
$sql = "INSERT INTO registered_users (name, email, comment, number_participants, contact_phone, date, work_schedule_fk, selected_game) " . "VALUES ('{$name}', '{$email}', '{$comment}', '{$number_participants}', '{$contact_phone}', FROM_UNIXTIME('{$date}'), {$shedule}, {$selected_game})";
//$result = $conn->query($sql); //Вернет количество строк записанных
if (mysqli_query($conn, $sql)) {
$succ_msg = "Вы были успешно зарегистрированы!";
} else {
$err_msg = "Error: " . $sql . " errorFromSQL:" . mysqli_error($conn);
}
}
/**Вытащим текст расписания*/
$sql = "SELECT text_shedule FROM work_schedule WHERE id = " . $shedule;
$res_sql = $conn->query($sql);
$shedule_name = mysqli_parse_array($res_sql);
$sql = "SELECT game_name FROM game_list WHERE id = " . $selected_game;
$res_sql = $conn->query($sql);
$game_name = mysqli_parse_array($res_sql);
$formated_date = date('d-m-Y', $date);
$result_ajax = array('errorMsg' => $err_msg, 'successMsg' => $succ_msg);
echo json_encode($result_ajax);
$to = "<*****@*****.**>";
/**Тема письма*/
$subject = "Новый заказ Quantum-reality";
/**Текст письма*/
$message = "<html>\r\n\r\n<head>\r\n <title>Обратная связь с сайта Quantum Reality</title>\r\n</head>\r\n\r\n<body>\r\n <h2>Имя:</h2>\r\n <p>{$name}</p>\r\n <h2>Реквизиты:</h2>\r\n <a href=\"tel:{$contact_phone}\">\r\n <p><small>{$contact_phone}</small></p>\r\n </a>\r\n <a href=\"mailto:{$email}\">\r\n \t<p><small>{$email}</small></p>\r\n </a>\r\n <h3>Название игры</h3>\r\n <p>{$game_name[0]['game_name']}</p>\r\n <h3>Количество персон</h3>\r\n <p>\r\n {$number_participants}\r\n </p>\r\n <h3>Комментарий</h3>\r\n <p>\r\n {$comment}\r\n </p>\r\n <h3>Дата</h3>\r\n <p>\r\n {$formated_date}<br/>\r\n {$shedule_name[0]['text_shedule']}\r\n </p>\r\n</body>\r\n\r\n</html>";
$headers = "Content-type: text/html; charset=utf-8 \r\n";
/* дополнительные шапки */
$headers .= "From: Quantum_Reality\r\n";
mail(SITE_ADMIN_EMAIL, $subject, $message, $headers);
$conn->close();
exit;
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "/db_config.php";
echo "<div id=\"new_table\" class=\"row\"></div>";
$sql_shedule = "SELECT id,text_shedule FROM work_schedule ORDER BY count_shedule ASC;";
//Результат
$sql_reserved = "SELECT id,date,work_schedule_fk FROM registered_users WHERE (date between CURDATE()-WEEKDAY(CURDATE())\r\n AND DATE_ADD(CURDATE()-WEEKDAY(CURDATE()), INTERVAL 21 DAY));";
$sql_reserved_holidays = "SELECT date FROM reserved_dates WHERE (date between CURDATE()-WEEKDAY(CURDATE())\r\n AND DATE_ADD(CURDATE()-WEEKDAY(CURDATE()), INTERVAL 21 DAY));";
$shedule_query = $conn->query($sql_shedule);
$reserved_query = $conn->query($sql_reserved);
$reserved_holidays_query = $conn->query($sql_reserved_holidays);
$result_shedule = mysqli_parse_array($shedule_query);
$result_reserved_holidays = mysqli_parse_array($reserved_holidays_query);
$result_reserved = mysqli_parse_array($reserved_query);
$date = strtotime(date('Y-m-d'));
echo '<script language="javascript">
var selectedGame = \'\';
var shedule = ' . json_encode($result_reserved) . ';
shedule = shedule.map(function (value) {
value.date = moment(value.date).format(\'DD.MM.YYYY\');
return value;
});
var workTimes = ' . json_encode($result_shedule) . ';
var holidays = ' . json_encode($result_reserved_holidays) . '.map(function (value) {
return value.date = moment(value.date).format(\'DD.MM.YYYY\');
});
firstRender();</script>';
mysqli_free_result($shedule_query);
mysqli_free_result($reserved_query);
<label for="inputGroupSize" class="control-label">Количество участников:</label>
<div class="input-group">
<input type="text" id="inputGroupSize" class="form-control bfh-number" data-min="2" data-max="4">
</div>
</div>
<!-- Выберите квест -->
<div class="form-group">
<label for="InputName" class="control-label">Выберите игру:</label>
<div class="input-group">
<div class="bfh-selectbox" data-name="selectbox1" id="Input-selectbox" data-value="2">
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "/db_config.php";
$sql_get_quest_selects = "SELECT id, game_name FROM game_list WHERE disabled = 0 AND game_type = '' ORDER BY id DESC";
$quest_query_selects = $conn->query($sql_get_quest_selects);
$result_quest_selects = mysqli_parse_array($quest_query_selects);
foreach ($result_quest_selects as $key => $value) {
echo "<div data-value=\"{$value['id']}\">{$value['game_name']}</div>";
}
mysqli_free_result($quest_query_selects);
?>
</div>
<span class="input-group-addon"><span class="glyphicon glyphicon-knight"></span></span>
</div>
<div class="help-block with-errors"></div>
</div>
<!-- COMMENT -->
<div class="form-group">
<label for="InputMessage" class="control-label">Комментарий:</label>
<div class="input-group">
