/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