/Users/johnr/Desktop/IA pdf Downloads/Criteria__P__-_Coding_Project_Upload_all_2022-05-03/Final CS IA_Agraj/database.php
 1 <?php
 2 include 'connection.php';
 3 $PhoneNumber = $_POST['Phone'];
 4 $CustomerName = $_POST['Name'];
 5 $Comments = $_POST['Comments'];
 6 $Email = $_POST['email'];
 7 $Food = $_POST['Food'];
 8 $OrderDate = date('Y/m/d');
 9 $ShippingDate = $_POST['ShipDate'];
10 if(empty($Food)) 
11    {
12     echo("You didn't select any items.");
13   }
14 else{
15 $FoodStr = implode(',',$Food);
16 } 
17 echo $Email;
18 $sql = "INSERT INTO orders(customer_name, phone_number, email, order_date, shipping_date, comments, food) VALUES ('".$CustomerName."','".$PhoneNumber."','".$Email."','".$OrderDate."','".$ShippingDate."','".$Comments."','".$FoodStr."')";
19 if ($conn->query($sql) === TRUE) {
20   echo "New order created successfully";
21 } else {
22   echo "Error: " . $sql . "<br>" . $conn->error;
23 }
24 
25 $conn->close();
26