97
if ($_REQUEST['btn_del'])
{
$db->setQuery("DELETE FROM `hall` WHERE id = '$_GET[slct_del]'");
$db->query();
header("location:../modules/menu.php?hall");
}
if ($_REQUEST['btn_edit'])
{
$db->setQuery("UPDATE `hall` SET num='$_GET[edit_num]',
info='$_GET[edit_info]', cnt_row='$_GET[edit_cnt_row]',
cnt_place='$_GET[edit_cnt_place]'
WHERE id = '$_GET[slct_edit]'");
$db->query();
header("location:../modules/menu.php?hall");
}
if (isset($_POST['jSlct']))
{
$id = json_decode(stripslashes($_POST["jSlct"]));
if ($id == 0)
{
$arr = 0;
echo json_encode($arr);
exit;
}
else
98
{
$db->setQuery("SELECT * FROM hall WHERE id = '$id'");
$db->query();
$res = $db->loadRow();
echo json_encode($res);
exit;
}
}
Модуль handler_place.php
<?php
require_once "../includes/header.php";
session_start();
if ($_REQUEST['btn_create']) {
$num = $_GET['new_num'];
$db->setQuery("SELECT * FROM hall WHERE id = '$_GET[slct_hall]'");
$db->query();
$data = $db->loadRow();
if ($data['cnt_place'] < $num) {
$msg = 'Неверное количество мест!';
header("location:../modules/menu.php?place&msg=" . $msg);
exit;
}
for ($i = 1; $i < $num + 1; $i++) {
99
$db->setQuery("SELECT * FROM place WHERE num = $i AND num_row =
'$_GET[new_row]' AND hall_id = '$_GET[slct_hall]'");
$db->query();
$isExist = $db->loadRow();
if (!$isExist) {
$db->setQuery("INSERT INTO place (num, num_row, hall_id)
VALUES ($i, '$_GET[new_row]', '$_GET[slct_hall]')");
$msg = '';
if (!$db->query()) {
if ($db->_errorNum == 1305) {
$msg = 'Номер ряда некорректный!';
}
}
}
}
header("location:../modules/menu.php?place&msg=" . $msg);
}
if ($_REQUEST['btn_del']) {
$db->setQuery("DELETE FROM `place` WHERE id = '$_GET[slct_place_dell]' AND
hall_id = '$_GET[slct_del_hall]'");
$db->query();
header("location:../modules/menu.php?place");
}
if ($_REQUEST['btn_edit'])
100
{
$db->setQuery("UPDATE `place` SET num='$_GET[edit_num]',
num_row='$_GET[edit_row]'
WHERE id = '$_GET[slct_place_edit]'");
$db->query();
header("location:../modules/menu.php?place");
}
if (isset($_POST['jSlct'])) {
$arr = json_decode(stripslashes($_POST["jSlct"]));
$placeId = $arr[0];
$hallId = $arr[1];
if ($placeId == 0 || $hallId == 0) {
$arr = 0;
echo json_encode($arr);
exit;
} else {
$db->setQuery("SELECT * FROM place WHERE id = '$placeId' AND hall_id =
'$hallId'");
$db->query();
$res = $db->loadRow();
echo json_encode($res);
exit;
}
}
if (isset($_POST['jHall'])) {
$id = json_decode(stripslashes($_POST['jHall']));
101
if ($id == 0) {
$arr = 0;
echo json_encode($arr);
exit;
} else {
$db->setQuery("SELECT p.id, p.num FROM hall h
INNER JOIN place p ON h.id = p.hall_id
WHERE h.id = '$id'");
$db->query();
$res = $db->loadRowList();
echo json_encode($res);
exit;
}
}
Модуль handler_user.php
<?php
require_once "../includes/header.php";
session_start();
if ($_REQUEST['btn_del']) {
$db->setQuery("DELETE FROM user WHERE id = '$_GET[slct_user_del]'");
$db->query();
header("location:../modules/menu.php?user");
}
if ($_REQUEST['btn_save']) {
102
if (!$_SESSION['admin']) {
$db->setQuery("UPDATE user SET login = '$_GET[login]', fio = '$_GET[fio]',
address = '$_GET[address]', phone = '$_GET[phone]', age = '$_GET[age]' WHERE id =
'$_SESSION[id]'");
} else {
$db->setQuery("UPDATE user SET login = '$_GET[edit_login]', fio =
'$_GET[edit_fio]',
address = '$_GET[edit_address]', phone = '$_GET[edit_phone]', age = '$_GET[edit_age]'
WHERE id = '$_GET[slct_edit]'");
}
$msg = '';
if (!$db->query()) {
if ($db->_errorNum == 1305) {
$msg = 'Такой логин уже используется! Выбери другой логин.';
}
}
if (!$_SESSION['admin']) {
header("location:../modules/menu.php?profile&msg=" . $msg);
} else {
header("location:../modules/menu.php?user&msg=" . $msg);
}
}
if (isset($_POST['jSlct'])) {
$id = json_decode(stripslashes($_POST["jSlct"]));
if ($id == 0) {
$arr = 0;
103
echo json_encode($arr);
exit;
} else {
$db->setQuery("SELECT * FROM user WHERE id = '$id'");
$db->query();
$res = $db->loadRow();
echo json_encode($res);
exit;
}
}