hotel-database-system/deleteComplete.php at master · catai9/hotel-database-system · 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
<head>
    <title>Delete Guest</title>
    <link rel="stylesheet" href="messageFormat.css">
</head>

<div>
<body>
    <!-- Provides a link back to the Home page. -->
    <a href="index.html" class="button">Back to Home</a> <br>

    <h1>Delete Guest Information</h1>

    <?php
    // Enable error logging:
        error_reporting(E_ALL ^ E_NOTICE);

        // mysqli connection via user-defined function.
        include('./my_connect.php');
        // Connection 1 is used for the first sql.
        $mysqli = get_mysqli_conn();
        // Connection 2 is used for the second sql.
        $mysqli2 = get_mysqli_conn();

        // SQL statements.
        // SQL #1: Checks if guest is in table as phpmyadmin will approve deletions even if ID not in table.
        $sql = "SELECT ID "
        . "FROM guest "
        . "WHERE ID = ? ";

        // SQL #2: Deletes the guest if the guest is in the table.
        $sql2 = "DELETE FROM guest "
        . "WHERE ID = ? ";

        // Prepared statement, stage 1: prepare the first sql query.
        $stmt = $mysqli->prepare($sql);

        // Prepared statement, stage 2: bind and execute the first sql query.
        $guest_ID = $_POST['guest_ID'];
        $stmt->bind_param('i', $guest_ID);
        $stmt->execute();
        $stmt->bind_result($guest_ID2);

        // Checks that the guest is in the database before the deletion query is executed. Displays a message if the guest is not in the database.
        if($stmt->fetch()){
            // Prepared statement, stage 1: prepare the second sql query.
            $stmt2 = $mysqli2->prepare($sql2);
            // Prepared statement, stage 2: bind and execute the second sql query.
            $stmt2->bind_param('i', $guest_ID2);
            // If statement checks that the query ran successfully. Displays a message if there is an issue in deletion.
            if ($stmt2->execute()) {
                echo '<p>Guest ' . $guest_ID2 . ' deleted successfully!</p>';
             }
            else {
                echo '<p>Guest not deleted. Please try again.</p>';
            }
        }
        else {
            echo '<p>Guest does not exist. Please try a different guest ID.</p>';
        }

        // Close statement and connection.
        $stmt->close();
        $stmt2->close();
        $mysqli->close();
        $mysqli2->close();

    ?>

</body>
</div>