cypress/delete_report_group.php at master · CDBAT/cypress · 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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
session_start();

$mysql_connect = mysqli_connect("localhost", "id16543739_cdbat", "Cypress@12345", "id16543739_cypress");

// Check if database connected properly
if (!$mysql_connect) {
    die(mysqli_connect_error());
}

?>

<!doctype html>

<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Delete Report Tab</title>
    <link rel="stylesheet" href="stylesheets/edit_report.css"/>
</head>

<?php

$email = $_SESSION['email'];

$sqlQuery = "SELECT damage_type, city, street1, street2, damage_info FROM Forms where email = '$email'";
$queryResult = $mysql_connect->query($sqlQuery);

if ($queryResult) {

    include 'header.php';

    $queryRowCount = mysqli_num_rows($queryResult);

?>

<body>
    <div class='jumbotron' style="background-color:white">
        <div class='bg order-1 order-md-2'></div>
        <div class='contents order-2 order-md-1'>
            <div class='container'>
                <div class='row align-items-center justify-content-center'>
                    <div class='col-md-12 py-5'>
                        <h3><?php checkLanguage("Delete Report", "Supprimer le Rapport"); ?></h3>
                        <p class='mb-4'>
                        <?php
                        if ($queryRowCount > 0) {
                            checkLanguage("Choose a report to delete.", "Choisissez un rapport à supprimer.");
                        }
                        else {
                            checkLanguage("You have no reports.", "Vous n'avez aucun rapport.");
                        }
                        ?>
                        </p>

                        <table class='table table-striped'>
                            <thead class='thead-dark'>
                                <tr>
                                    <th scope='col'><?php checkLanguage("Damage Type", "Type de Dommage"); ?></th>
                                    <th scope='col'><?php checkLanguage("City", "Ville"); ?></th>
                                    <th scope='col'><?php checkLanguage("Street 1", "Rue 1"); ?></th>
                                    <th scope='col'><?php checkLanguage("Street 2", "Rue 2"); ?></th>
                                </tr>
                            </thead>

                            <tbody>
                            <?php
                            while ($row = $queryResult->fetch_assoc()) {
                                printf("<tr class='clickable' onclick='setFormID(\"%s\", \"%s\", \"%s\", \"%s\")'>\n", $row['damage_type'], $row['city'], $row['street1'], $row['street2']);
                                    printf("<td>%s</td>\n", $row['damage_type']);
                                    printf("<td>%s</td>\n", $row['city']);
                                    printf("<td>%s</td>\n", $row['street1']);
                                    printf("<td>%s</td>\n", $row['street2']);
                                print("</tr>");
                            }
                            ?>
                            </tbody>
                        </table>

                        <p class='my-4' id='report_selected'></p>

                        <form onsubmit="return confirmDeleteReport()" id='delete_report_form' action='' method='POST'>
                            <input type='text' id='formID' name='formID' value=''/>
                            <button class='btn btn-md btn-danger' type='submit' id='submit_delete_report' name='submit_delete_report'><?php checkLanguage("Delete Report", "Supprimer le Rapport"); ?></button>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>

<?php
}

// User tried to delete the report
if (isset($_POST['submit_delete_report'])) {

    // Get info from form
    $email = $_SESSION['email'];
    $form_id = $email . $_POST['formID'];


    $sqlQuery = "DELETE FROM Forms WHERE form_id=\"$form_id\"";

    if ($mysql_connect->query($sqlQuery) === TRUE) {
        $message = checkLanguageAlert("You successfully deleted the report.", "Vous avez supprimé le rapport avec succès.");
        echo "<script type='text/javascript'>alert('$message');</script>";

        echo'
        <script>
        window.location.replace("https://cypress-cdbat.000webhostapp.com/index.php");
        </script>
        ';
    }
    else {
        echo "Error deleting record: " . $mysql_connect->error;
    }
}

?>

<script src="scripts/delete_report.js"></script>

</html>