if(isset($_POST['buy_submit'])){
		$user = $_SESSION["username"];
		$id_user = $mysqli->query("SELECT id_customer FROM customers WHERE username ='$user'"); // lay ra ID cua tai khoan dang dnag nhap
		$requiredate = $_POST['requiredate'];
		$query = "INSERT INTO `order` (`id_customer`,`orderDate`,`requiredDate`) VALUES ($id_user,CURRENT_DATE,$requiredate)";
		$mysqli->query($query);
		$id_order = $mysqli->query("SELECT id_order FROM `order` WHERE id_customer ='$id_user' AND shippedDate='$requiredate'");
		foreach ($_SESSION["products"] as $item){
			$id = $item["id"];
			$quantity = $item["quantity"];
			$price = $item["price"];
			$result2=	$mysqli->query("INSERT INTO orderdetail(id_order,cd_code,quantityOrdered,priceEach) VALUES ('$id_order','$id','$quantity','$price')");
		}

	}