parkinglot/remove.php at master · vikraman22/parkinglot · 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

<?php

require_once 'connect.php';

    $connection = mysqli_connect('localhost', 'root', '', 'parking');

    $park_date;
    $park_cost;

    if (isset($_POST['details']))
    {
        $veh_no =  $_POST['v_num'];

        $query = "SELECT DATEDIFF(CURRENT_DATE,(SELECT Parking_date from book_details where vehicle_no = '$veh_no') ) as cost";
        $date_query = "SELECT Parking_date from book_details where vehicle_no = '$veh_no'";

        $result =  mysqli_query($connection, $query);
        $date_result = mysqli_query($connection, $date_query);

        if (!$result) {
            die('sql query failed');
        }


        $cost = mysqli_fetch_array($result);
        $parking_date = mysqli_fetch_array($date_result);

        if (is_null($parking_date))
            echo '<script>alert("No vehicles found")</script>';

        else
        {
            $park_cost = ($cost[0] + 1) * 30;
            $park_date = $parking_date[0];
        }
    }


    if (isset($_POST['remove'])) {

        $vechicle = $_POST['v_num'];

        $query = "DELETE FROM book_details where vehicle_no='$vechicle'";
        mysqli_query($connection, $query);

        echo '<script>alert("Vehicle removed and Money collected")</script>';
    }

?>


<!doctype html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://fonts.googleapis.com/css2?family=Josefin+Sans:wght@700&display=swap" rel="stylesheet">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-BmbxuPwQa2lc/FVzBcNJ7UAyJxM6wuqIj61tLrc4wSX0szH/Ev+nYRRuWlolflfl" crossorigin="anonymous">
    <title>Parking Lot</title>
    <style>
        #main {
            background-image: url("Images/matte_black.jpg");
            font-family: 'Josefin Sans', sans-serif;
            background-size: 100% 100%;
        }

        .forms {
            width: 50%;
        }

        #btns {
            width: 25%;
        }
    </style>
</head>


<body id="main">
    <br>
    <form action="remove.php" method="post">
        <div class="container">
            <div class="jumbotron bg-success text-dark shadow">
                <br>
                <center>
                    <h1 class="display-1">REMOVE A VEHICLE</h1>
                </center>
            </div><br><br>
            <form name="details">
                <small class="text-muted">Vehicle Number</small>

                <input type="text" class="form-control btn-outline-success border forms" name="v_num" id="vhno" placeholder="Vehicle Number"><br>
                <!-- <small class="text-muted">Phone Number</small>

                    <input type="text" class ="form-control btn-outline-success border forms" name="phone_no" id="phone_no" placeholder="phone Number"><br>
                     -->
                <p class="text-success h3">Date of parking: <?php echo  $park_date ?>
                <p class="text-success h3" name="park_date"></p>
                </p>

                <p class="text-success h3">Total Cost: <?php echo  $park_cost  ?>
                <p class="text-success h3" name="cost"></p>
                </p>


            </form>
            <center>
                <button class="btn btn-outline-success" id="btns" name="details">DETAILS</button><br><br>

                <button class="btn btn-outline-success" id="btns" name="remove">REMOVE</button><br><br>
                <a id="btns" class="btn btn-outline-success" href="admin.php">HOME</a>
            </center>
        </div>
    </form>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta2/dist/js/bootstrap.bundle.min.js" integrity="sha384-b5kHyXgcpbZJO/tY9Ul7kGkf1S0CWuKcCD38l8YkeH8z8QjE0GmW1gYU5S9FOnJ0" crossorigin="anonymous"></script>

</body>

</html>