Show sourcecode
The following files exists in this folder. Click to view.
access-deneid.png
diagramresultat.php
insert-admin.php
login.php
logout.php
personliga-resultat.php
quiz-sida.php
ransa-quiz-session.php
ransa-skapa-quiz-session.php
resultat.php
session-variabler-unset.php
signin.php
skapa-inloggning-tabell.php
skapa-quiz-tabeller.php
skapa-quiz.php
start.php
tabort-kunder-quiz.php
åtkomst-nekad.php
tabort-kunder-quiz.php
137 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
<?php
session_start();
include('session-variabler-unset.php');
if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] != true){
header("Location: login.php");
exit;
}
if($_SESSION["type"] != "admin"){
header("Location: åtkomst-nekad.php");
exit;
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Ta bort</title>
<style>
table{
border-collapse:collapse;
margin:20px 0;
font-size:16px;
text-align: left;
}
table,th,td{
border:1px solid #ddd;
}
th,td {
padding: 10px;
}
tr:hover{
background-color:#f1f1f1;
}
caption{
background-color:darkblue;
color:white;
font-weight:bold;
font-size:20px;
}
</style>
</head>
<body>
<?php
include ('../../dbconnection.php');
$id = null;
$id2 = null;
//ta bort kund
if (isset($_POST['id']) && !empty($_POST['id'])) {
$id = $_POST['id'];
try {
$sql = "DELETE FROM kunder WHERE id=?";
$stmt = $dbconn->prepare($sql);
$data = array($id);
$stmt->execute($data);
}
catch(PDOException $e)
{
$e->getMessage();
}
}
//ta bort quiz
if (isset($_POST['id2']) && !empty($_POST['id2'])) {
$id2 = $_POST['id2'];
try {
$sql = "DELETE FROM quizer WHERE id=?";
$stmt = $dbconn->prepare($sql);
$data = array($id2);
$stmt->execute($data);
}
catch(PDOException $e)
{
$e->getMessage();
}
}
//kunder tabell
$sql = "SELECT * FROM kunder";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
$output = "<table><caption>Kunder</caption>";
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$idx = htmlentities($res['id']);
$name = htmlentities($res['name']);
$username = htmlentities($res['username']);
$type = htmlentities($res['type']);
$output .= "<tr>".
"<td>$idx</td>".
"<td>$name</td>".
"<td>$username</td>".
"<td>$type</td>".
"<td><form method='post' action=''>".
"<input type='hidden' name='id' value='$idx'>".
"<button type='submit'>Ta bort</button></form></td>".
"</tr>";
}
$output .= "</table>";
echo "$output";
echo "<br>";
//Quizer tabell
$sql = "SELECT * FROM quizer";
$stmt = $dbconn->prepare($sql);
$data = array();
$stmt->execute($data);
$output = "<table><caption>Quizer</caption>";
while ($res = $stmt->fetch(PDO::FETCH_ASSOC)) {
$idx2 = htmlentities($res['id']);
$namn = htmlentities($res['namn']);
$output .= "<tr>".
"<td>$idx2</td>".
"<td>$namn</td>".
"<td><form method='post' action=''>".
"<input type='hidden' name='id2' value='$idx2'>".
"<button type='submit'>Ta bort</button></form></td>".
"</tr>";
}
$output .= "</table>";
echo "$output";
$dbconn = null;
?>
<a href="start.php">Tillbaka till start</a>
</body>
</html>