Attendance-list/addAdmin.php

97 lines
3.2 KiB
PHP
Raw Permalink Normal View History

2023-08-18 14:00:24 +00:00
<?php
require_once 'db.php';
require_once 'checkLogin.php';
@session_start();
if($_SESSION['user_admin'] != 1)
{
//redirect to panel.php
$_SESSION["innfoError"] = "Brak uprawnień do tej strony";
header("Location: panel.php");
exit();
}
//pobierz wszystkie dane użytkowników, których nie ma w tabeli admini kolumna kto
$sql = "SELECT * FROM uzytkownicy WHERE id NOT IN (SELECT kto FROM admini) AND aktywne = 1";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$uzytkownicy = $stmt->fetchAll(PDO::FETCH_ASSOC);
//print_r($uzytkownicy);
if($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['addAdmin']))
{
$user = $_POST['user'];
$sql = "INSERT INTO admini (kto) VALUES (:kto)";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(':kto', $user, PDO::PARAM_INT);
$stmt->execute();
$_SESSION['innfoError'] = "Dodano admina";
header("Location: dictionaries.php");
exit();
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Panel <?php echo $_SESSION["user_login"]; ?></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div id="panel">
<div id="panel">
<header>
<h1>Witaj <?php echo $_SESSION["user_imie"]; ?></h1>
</header>
<nav>
<?php
require_once 'nav.php';
?>
</nav>
<main id="work">
<div class="error">
<?php
if(isset($_SESSION['innfoError']))
{
echo $_SESSION['innfoError'];
unset($_SESSION['innfoError']);
}
?>
</div>
<form action="addAdmin.php" method="post">
<table class="form">
<tr>
<td colspan="2">
<h3>Dodaj admina</h3>
</td>
</tr>
<tr>
<td>
<label for="user">Wybierz użytkownika</label>
</td>
<td>
<select name="user" id="user">
<?php
foreach($uzytkownicy as $user)
{
?>
<option value="<?php echo $user['id']; ?>"><?php echo $user['imie']." ".$user['nazwisko']." (".$user['login'].")"; ?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="addAdmin" class="btn" value="Dodaj"/>
</td>
</tr>
</table>
</form>
</main>
</div>
</div>
<?php
require_once 'footer.php';
?>
</body>
</html>