orderdetaljer

<?php
    include("connect.php");
    include("cart.php");

    if(isset($_POST["checkout"])){
        $sqlInsert = "INSERT INTO orders (kundid, orderdate) VALUES (" . $_SESSION["kund"] . ", now()  )";


        $conn->query($sqlInsert);
        $result = mysqli_query($conn,  "SELECT MAX(orderid) AS max FROM orders" );
        $row = $result->fetch_assoc();
        $orderID = $row['max'];

    foreach($_SESSION["cart"] as $key => $varunamn) {

        $sql ="INSERT INTO orderdetaljer (orderid, prodid, antal) VALUES (" . $orderID . ", " . $_SESSION["cart"][$key]["prodid"] . " , " . $_SESSION["cart"][$key]["amount"].")";

        $conn->query($sql);
    }
    }
    ?>