98
</li>
<li class='nav-item'>
<a href='baseofknowlege.php' class='nav-link waves-effect'>База
знаний</a>
</li>
<li class='nav-item'>
<a href='logout.php' class='nav-link waves-effect'>Выйти</a>
</li>
</ul>
<? } else if($_SESSION['status'] == 3) { ?>
<ul class='navbar-nav mr-auto'>
<li class='nav-item'>
<a href='allrequests.php' class='nav-link waves-effect'>Все заявки</a>
</li>
<li class='nav-item'>
<a href='closedrequests.php' class='nav-link waves-effect'>Закрытые
заявки</a>
</li>
<li class='nav-item'>
<a href='listofusers.php' class='nav-link waves-effect'>Список
сотрудников</a>
</li>
99
<li class='nav-item'>
<a href='baseofknowlege.php' class='nav-link waves-effect'>База
знаний</a>
</li>
<li class='nav-item'>
<a href='logout.php' class='nav-link waves-effect'>Выйти</a>
</li>
</ul>
<? } else if($_SESSION['status'] == 10) { ?>
<ul class='navbar-nav mr-auto'>
<li class='nav-item'>
<a href='allrequests.php' class='nav-link waves-effect'>Все заявки</a>
</li>
<li class='nav-item'>
<a href='closedrequests.php' class='nav-link waves-effect'>Закрытые
заявки</a>
</li>
<li class='nav-item'>
<a href='register.php' class='nav-link waves-effect'>Регистрация нового
пользователя</a>
</li>
<li class='nav-item'>
100
<a href='listofspec.php' class='nav-link waves-effect'>Список
сотрудников</a>
</li>
<li class='nav-item'>
<a href='baseofknowlege.php' class='nav-link waves-effect'>База
знаний</a>
</li>
<li class='nav-item'>
<a href='logout.php' class='nav-link waves-effect'>Выйти</a>
</li>
</ul>
<? } else { ?>
<ul class='navbar-nav mr-auto'>
<li class='nav-item'>
<a href='login.php' class='nav-link waves-effect'>Войти</a>
</li>
</ul>
<? } ?>
</div>
</div>
</nav>
</header>
101
Приложение 3- footer.php
<footer class="bg-dark text-center font-small fixed-bottom">
<div class="pt-1">
<p class="text-white navbar-text mr-3">Если возникли проблемы
с сайтом, свяжитесь с нашими специалистами: +7 (777) 777-77-77</p>
<a href="#"><i class="navbar-text text-white fab fa-vk mr-
3"></i></a>
<a href="#"><i class="navbar-text text-white fab fa-telegram-plane
mr-3"></i></a></div></footer>
<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
integrity="sha384-
q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo
" crossorigin="anonymous"></script>
<script
src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"
integrity="sha384-
UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHND
z0W1" crossorigin="anonymous"></script>
<script
src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
integrity="sha384-
JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM
" crossorigin="anonymous"></script>
</body>
</html>
102
Приложение 4 login.php
<?php
require 'includes/header.php';
if($_SESSION['status'] >= 1) {
echo "
";
} else {
?>
<main>
<div class="container border border-secondary rounded">
<h5 class="text-center my-4">Введите данные для
входа:</h5>
<form action="login.php" method="POST">
<div class="form-group">
<div
class="form-group"> <label>Логин</label> <input type="text"
name="login" value="<?php echo @$data['login']; ?>" class="form-control"
required>
</div>
<div class="form-group">
<label>Пароль</label>
103
<input type="password" name="password" value="<?php echo
@$data['password']; ?>" class="form-control" required>
</div>
<button type="submit"
class="btn btn-primary my-2 py-2">Авторизоваться</button>
</div>
</form>
</div>
</main>
}
if(isset($_POST['login']) and isset($_POST['password'])) {
$login = $_POST['login'];
$password = $_POST['password'];
$query = "SELECT * FROM users WHERE login='$login' and
password='$password'";
$result = mysqli_query($connection, $query) or
die(mysqli_error($connection));
$count = mysqli_num_rows($result);
if($count == 1) {
$_SESSION['login'] = $login;
104
$query = "SELECT status FROM users WHERE login='$login'";
$result = mysqli_query($connection, $query) or
die(mysqli_error($connection));
$row = mysqli_fetch_row($result);
$_SESSION['status'] = $row[0];
$query = "SELECT id FROM users WHERE login='$login'";
$result = mysqli_query($connection, $query) or
die(mysqli_error($connection));
$row = mysqli_fetch_row($result);
$_SESSION['id'] = $row[0];
$query = "SELECT org FROM users WHERE login='$login'";
$result = mysqli_query($connection, $query) or
die(mysqli_error($connection));
$row = mysqli_fetch_row($result);
$_SESSION['org'] = $row[0];
$query = "SELECT name FROM users WHERE login='$login'";
$result = mysqli_query($connection, $query) or
die(mysqli_error($connection));
$row = mysqli_fetch_row($result);
$_SESSION['name'] = $row[0];
$query = "SELECT phone FROM users WHERE
login='$login'";
$result = mysqli_query($connection, $query) or
105
die(mysqli_error($connection));
$row = mysqli_fetch_row($result);
$_SESSION['phone'] = $row[0];
$query = "SELECT email FROM users WHERE login='$login'";
$result = mysqli_query($connection, $query) or
die(mysqli_error($connection));
$row = mysqli_fetch_row($result);
$_SESSION['email'] = $row[0];
echo("<meta http-equiv='refresh' content='1'>"); } else {
?>
<div class="my-5 py-5 alert alert-danger" role="alert">
<h4 class="alert-heading text-center my-5 py-5">Неверный
логин или пароль</h4>
</div> } }
if(isset($_SESSION['login'])) {
$login = $_SESSION['login']; ?>
<div class="my-5 py-5 alert alert-success" role="alert">
<h4 class="alert-heading text-center my-5 py-5">Вы успешно
авторизовались!</h4>
</div>
}
require 'includes/footer.php'; ?>
106
Приложение 5 register.php
<?php require 'includes/header.php';
if($_SESSION['status'] == 10) { ?> <main> <?php
if(isset($_POST['login']) and isset($_POST['password'])) {
$login = $_POST['login'];
$password = $_POST['password'];
$name = $_POST['name'];
$org = $_POST['org'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$status = $_POST['status'];
$query = "INSERT INTO users (login, password, name,
org, phone, email, status)
VALUES ('$login', '$password', '$name', '$org', '$phone',
'$email', '$status')";
$result = mysqli_query($connection, $query);
if($result){
$smsg = "Пользователь зарегистрирован!";
} else { $fmsg = "Ошибка!"; } }
?>
<div class="container border border-secondary rounded my-3 py-3">
<form action="register.php" method="POST">
107
<div class="form-group">
<?php if(isset($smsg)){ ?><div class="alert
alert-success" role="aler"><? echo $smsg;?></div><? }?>
<?php if(isset($fmsg)){ ?><div class="alert
alert-danger" role="aler"><? echo $fmsg;?></div><? }?>
<label>ФИО пользователя</label>
<input type="text" name="name"
value="<?php echo @$data['name']; ?>" class="form-control" required> </div>
<div class="form-group">
<label>Организация</label>
<input type="text" name="org"
value="<?php echo @$data['org']; ?>" class="form-control" required> </div>
<div class="form-group">
<label>Номер телефона</label>
<input type="text" name="phone"
value="<?php echo @$data['phone']; ?>" class="form-control" required> </div>
<div class="form-group">
<label>Электронная почта</label>
<input type="text" name="email"
value="<?php echo @$data['email']; ?>" class="form-control" required> </div>
<div class="form-group">
<label>Логин</label>
<input type="text" name="login"