CSP203_LAB/updateMenu.php at master · shikherjaiswal/CSP203_LAB · 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
<?php
session_start();
$servername = "localhost";
$username = "cyborg";
$password = "toor";
$dbname = "lab";
$link = new mysqli($servername, $username, $password, $dbname);
if ($link->connect_error) {
   die("Connection failed: " . $link->connect_error);
}
if(isset($_SESSION["name"])){
    if($_SERVER["REQUEST_METHOD"]=="POST"){
       $userInput = $_POST['umenu'];
       $day = $_POST['Day'];
       $foodTime  = $_POST['FoodTime'];

       $sql = "update menu set food = '$userInput' where day = '$day' AND time='$foodTime'";
       $foodresult = $link->query($sql);
       //if($foodresult->num_rows>0){
       //  while($row=$foodresult->fetch_assoc()){
        //  $print2 = $print2."<th>".$row['food']."</th>";
       //  }
       //  $print2 = $print2."</tr></table>";
      // }
       $msg = "Menu Update Successful";
     }
   }
   else
   {
    echo 'Please login again !!';
    header('location :home.html');
   }
?>

<html>
<head>
 	<title>My Mess</title>
 	<link rel = "stylesheet" type="text/css" href="styles/register.css">
</head>
 <?php echo $msg;?>
 </br> </br>
<body>
<div id="registerBack"></div>
<div id="register">
<br><br><br>
<form action = "updateMenu.php" method = "POST" class="registerForm">

<input list = "day" name="Day" placeholder = "Select Day">
<datalist id="day">
<option selected disabled>DAY</option>
<option value="Monday">Monday</option>
<option value="Tuesday">Tuesday</option>
<option value="Wednesday">Wednesday</option>
<option value="Thursday">Thursday</option>
<option value="Friday">Friday</option>
<option value="Saturday">Saturday</option>
<option value="Sunday">Sunday</option>

</datalist><br>

<input list = "foodTime" name="FoodTime" placeholder="Breakfast/Lunch/Dinner">
<datalist id="foodTime">


<option value="Breakfast">Breakfast</option>
<option value="Lunch">Lunch</option>
<option value="Dinner">Dinner</option>
</datalist>
<br>

<input type="text" name="umenu" placeholder = "New Menu"><br><br><br>
 <input type="submit" value="Submit">
<a class='logout' href='http://localhost:80/ZEUS/logout.php'>Logout</a>
   <a class='home' href='http://localhost:80/ZEUS/admin.php'>Home</a>


 </form>
 </div>
 </body>

 </html>