htdocs/admin_frontpage.php at main · SonofLastPanda/htdocs · 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
<!DOCTYPE html>
<?php
include 'connect.php'; //Including database connection

session_start();
#To prevent unlogged in users to enter this page, and non-admins
if (!isset($_SESSION['username']) || $_SESSION['admin']==FALSE) {
  header("location: login.php");
  die();
}

$FROM = $_GET["FROM"];
$TO = $_GET["TO"];
$result = mysqli_query($link,"SELECT regulation.FROM, regulation.TO, regulation.Boarding, regulation.Qurantine, regulation.Vaccine, regulation.Regulation, regulation.Face_Mask, regulation.Public_Transportation, regulation.Businesses, regulation.Restaurants, regulation.Reminder, regulation.Sources FROM regulation");
include "close_db.php";
?>
<html>
  <head>
    <link href="styles.css" rel="stylesheet" type="text/css"/> <!-- Connecting to the css file named styles.css -->
    <div class="header">
    <h1><img src="logo1.2.png" alt="BatGirl logo" width="50" height="50" style= "margin-bottom: -10px; margin-left: 15px; margin-right: 0px;">CoTRACK-19<form method="get" action="logout.php"><button type="submit" id="myButton" class="button button_header" style="margin-right:7px; top:-53px;";>LOG OUT</form><form method="get" action="index.php"><button type="submit" id="myButton" class="button button_header" style="margin-right:7px; top:-53px;";>HOME</form></h1>
    </div>
  </head>
<body>
<div class="container">
      <img src="map_background.png" class=body_frontpage>
        <div class="boxed_top" style= "padding-top: 10px;">
            <h4 style= "color:#40798C; position: relative; top: 10px; line-height:1.2;" >Edit Depature and Destination<h4>
            <form action="admin_frontpage.php">
            <div style="float: left; display:flex; flex-direction: row;"><p style="padding-left:20px; padding-top:5px;">Departure: &nbsp; </p> <select name="FROM" style="top:-10px; left:-25px; height:25px; margin-top:15px;"> <!--Drop down list-->
            <?php
            // include "connect.php"; //Including database connection

            $result = mysqli_query($link,"SELECT DISTINCT regulation.FROM FROM regulation");
            while($row = mysqli_fetch_assoc($result)) {
            $catname = $row["FROM"];
            print "<option>$catname</option>";
            }
            ?> </select></div>
            <div style="float: left; display:flex; flex-direction: row;"><p style="padding-left:20px;">Destination: </p> <select name="TO" style="top:-10px; left:-25px; height:25px; margin-top:10px;"> <!--Drop down list -->
            <?php
            // include "connect.php"; //Including database connection
            $result2 = mysqli_query($link,"SELECT DISTINCT regulation.TO FROM regulation");
            while($row2 = mysqli_fetch_assoc($result2)) {
            $catname2 = $row2["TO"];
            print "<option>$catname2</option>";
            }
            // include 'closeDB.php'; //Closing database conncetion
            ?> </select></div>
            <button id="admin_country_button" class="button button_register" style="margin-top:15px; left:3px;">APPLY</button>
        </form>
        </div>
        <div class="boxed_bottom">
            <br>
            <h4 style= "color:#40798C; position: relative; top: 10px;">Admin Information</h4>
            <p style= "position: relative; top: -10px; margin-bottom:-15px; left:-23px;">Edit admin information below:</p><br>
            <form action="admin_frontpage.php">
            <div><b><p style="text-align:left; margin-bottom:5px;">Email:</p></b><input type="text" placeholder="New Email" name="useremail" pattern="[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,4}$" style="margin-left:0px; color:#40798C;"></div><br>
            <div><b><p style="text-align:left; margin-bottom:5px; margin-top:5px;">Password:</p></b><input type="password" placeholder="New Password" name="userpassword" minlength= "8" style="margin-left:0px;"></div><br>
            <div><b><p style="text-align:left; margin-bottom:5px; margin-top:5px;">Confirm Password:</p></b><input type="password" placeholder="Confirm Password" name="confirmpassword" style="margin-left:0px;"><br>
            <button onclick="location.href = 'www.yoursite.com';" id="myButton" class="button button_register"; style="left:0px; top:30px;">UPDATE</button>
            </form>
            <div>
      </div>
    </div>
    <div class="boxed_info">
      <form action="update_database.php">
        <h1> <?php echo "From: $FROM &nbsp &nbsp To: $TO &nbsp" ?></h1>
        <div class=boxed_c_l style= "background-color:#fcfaf4; border-style:dotted; left:425px; top: 214px; height: 475px; width:900px; border-color:#E2E8E5, border-width:5px; margin-bottom:50px;">
               <?php
                  include 'connect.php';
                  $result = mysqli_query($link,"SELECT regulation.FROM, regulation.TO, regulation.Boarding, regulation.Qurantine, regulation.Regulation,regulation.Vaccine, regulation.Face_Mask, regulation.Public_Transportation, regulation.Businesses, regulation.Restaurants, regulation.Reminder,regulation.ID FROM regulation");
                  while($row = mysqli_fetch_row($result)){
                  if (($row[0]=="$FROM")&&($row[1]=="$TO")){
                    // Listing all info
                    echo "<input type='hidden' name='id' value='$row[11]'/> ";
                    echo "<input type='hidden' name='from' value='$FROM'/> ";
                    echo "<input type='hidden' name='to' value='$TO'/> ";
                    echo "<div class='scroll_text_country' id='style' style='position:fixed; top: 270px; float:left; text-align:justify; height:400px; width:720px; background:#fcfaf4; margin-bottom:0px; margin-right:50px; margin-left:50px; scroll-margin-bottom: 2em;'>";
                    echo "<form>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:-36px; margin-bottom:-20px;'>Boarding</p>";
                    echo "<textarea name='boarding' rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[2] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Quarantine</p>";
                    echo "<textarea name='quarantine'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[3] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Vaccination</p>";
                    echo "<textarea name='vaccination'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[4] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Face Mask</p>";
                    echo "<textarea name='face_mask'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[6] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Public Transportation</p>";
                    echo "<textarea name='transport'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[7] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Businesses</p>";
                    echo "<textarea name='business'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[8] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Restaurants</p>";
                    echo "<textarea name='restaurants'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[9] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Reminder</p>";
                    echo "<textarea name='reminder'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[10] </textarea>";
                    echo "<p style='font-size:22pt; font-weight:bolder; position:relative; left:-50px; top:20px;'>Sources</p>";
                    echo "<textarea name='sources'  rows='10'; cols='95'; style='color:#40798C; font-family:'Red Hat Display'; font-size:12pt; position:relative; left:20px; top:20px; margin-bottom:-20px;'> $row[11] </textarea>";
                    }}
                    echo "</form>";
                  include "close_db.php"
                ?>
        </div>
        <button id="button_admin"; class="button button_admin"; style="position:fixed; top:745px; left:850px;">UPDATE</button>
                  </form>
      </div>

</div>
</body>
  <?php include "close_db.php" ?>
</div>
</div>
</html>