<?php
header("Content-Type: application/json; charset=UTF-8");

include('business.php');
include('Menus.php');
include('subMenu.php');

$host = "localhost";
$username = "id5014742_maor1t";
$password = "123456";
$dbname = "id5014742_maor1t";

$obj = filter_input(INPUT_POST,'params');

 $array = json_decode($obj); // decode JSON to associative array
 $id = $array->id;
 $name = $array->name;
 $minimum = $array->minimum;
 $address = $array->address;
 $phonenumber = $array->phonenumber;
 $menusArr = $array->menus;


  $myJSON =json_encode($menusArr);



//  foreach ($menusArr as $value) {
//       echo $value->name;

//      foreach ($value->submenu as $value2) {
//       $submenu = new subMenu($value2->name,$value2->description);
//         echo $value2->name;
//   }
//         $menu = new Menus($value->name,$submenu);
//     echo     $menu->name;
//  }



// Create connection
$conn = new mysqli($host, $username, $password, $dbname) or die("error connect to SQL: ".mysqli_connect_error());
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO businesses ( businessId, name, minimum,address,phonenumber,menus) VALUES ('".$id."', '".$name."', '".$minimum."', '".$address."', '".$phonenumber."', '".$myJSON."')";

if (mysqli_query($conn, $sql)) {
    // echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);