-
Notifications
You must be signed in to change notification settings - Fork 0
/
delete_exam.php
30 lines (30 loc) · 1.12 KB
/
delete_exam.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<?php
session_start();
if (!isset($_SESSION["user"]) && !isset($_SESSION["username"]) && !isset($_SESSION["password"])) {
header("Location: ./start.php");
}
else {
require_once "./database.php";
$username = $_SESSION["username"];
$password = $_SESSION["password"];
$db = new DB();
$db_connection = $db->connection();
$query = $db_connection->prepare('SELECT id_professor FROM professor WHERE username = :username AND password = :password');
$query->bindParam(":username", $username);
$query->bindParam(":password", $password);
$query->execute();
$id_professor = $query->fetch(PDO::FETCH_ASSOC);
/* Eliminar datos de la tabla exam */
$id_examen = $_GET["id"];
$query = $db_connection->prepare('DELETE FROM exam WHERE id_professor = :id_professor AND id_examen = :id_examen');
$query->bindParam(":id_professor", $id_professor["id_professor"]);
$query->bindParam(":id_examen", $id_examen);
$status = $query->execute();
if ($status) {
header("Location: ./professor.php");
}
else {
echo "Ha ocurrido un error, vuelve a intentarlo más tarde.";
}
}
?>