ClearCalc/delete_standard.php at master · nickhh/ClearCalc · GitHub

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
/*
 * delete_standard.php
 */
//require('user_authentication.php');
include('common_functions.php');

$config_parameters = parse_ini_file("../../config_clearance.ini", true);

//configuration of database
$db_host = $config_parameters['database_setup']['host'];
$db_user = $config_parameters['database_setup']['user'];
$db_password = $config_parameters['database_setup']['password'];
$db = $config_parameters['database_setup']['database'];

$connection_error = False;
$con = mysqli_connect($db_host,$db_user,$db_password,$db);

// Check connection
if (mysqli_connect_errno()){
    $connection_error = True;
    $error_message = '<div class="body_text">Failed to connect to MySQL: ' . mysqli_connect_error() . ' </div>';
}

if($connection_error){
    echo $error_message;
    echo(html_footer());
} else {
    if(isset($_GET['id'])){
        $id = $_GET['id'];
        $result = mysqli_query($con, "delete from standards where id='$id'");
        if($result){
            header('location:list_standards.php');
        } else {
            echo(html_header());
            echo '<div class="body_text">Ups! Pinligt! Der er sket en fejl.</div>';
            echo(html_footer());
        }
    }
}

?>