-
Notifications
You must be signed in to change notification settings - Fork 0
/
deletarDisciplina.php
42 lines (32 loc) · 1.02 KB
/
deletarDisciplina.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
31
32
33
34
35
36
37
38
39
40
41
42
<?php
if (!function_exists('saveToPost')) {
function saveToPost($message, $messageType, $page) {
$_POST["message"] = $message;
$_POST["messageType"] = $messageType;
$_POST["page"] = $page;
}
}
$conn = mysqli_connect('localhost', 'root', '', 'ihc1');
if (!$conn)
die("Erro fatal. Não foi possível se conectar ao banco de dados.");
extract($_POST, EXTR_OVERWRITE);
extract($_GET, EXTR_OVERWRITE);
if ($flag_disc = isset($id)) {
$id_disc = $id;
unset($id);
unset($_GET['id']);
unset($_POST['id']);
}
$sql = "SELECT t.id as id_turma FROM turma t WHERE t.id_disciplina=" . $id_disc;
$disciplina_result = mysqli_query($conn, $sql);
while ($disciplina_corrente = mysqli_fetch_assoc($disciplina_result)) {
extract($disciplina_corrente, EXTR_OVERWRITE);
$_POST['id_turma'] = $id_turma;
include 'deletarTurma.php';
}
mysqli_query($conn, "DELETE FROM disciplina WHERE id =" . $id_disc);
if ($flag_disc) {
saveToPost("Entradas excluídas com sucesso!", "success", "listaDisciplinas");
include 'main.php';
}
?>