Untitled

<!DOCTYPE html>
<html lang="en">
<head>
    <title> Queery </title>
    <style>
    #wrap {
        display:inline-block;
        width=100%;
        margin:0 auto;
    }
    #left_col {
        float:left;
        width:500px;
    }
    #right_col {
        float:left;
        width:500px;
    }
    table, th, td {
     border: 1px solid black;
    }
    </style>
</head>
<body>
<?php
    //1.Create database connection
    $dbhost="localhost";
    $dbuser="root";
    $dbpass="";
    $dbname="classicmodels";

    $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

    // define variables and set to empty values
    $orderNumber=$startDate=$endDate = "";
    $columns = $_POST["check_list"];

    if ($_SERVER["REQUEST_METHOD"] == "POST") {
      $orderNumber = $_POST["orderNumber"];
      $startDate = $_POST["startDate"];
      $endDate = $_POST["endDate"];
    }

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    foreach($columns as $column){
        $cols .=  $column . ",";
    }
    $sql = "SELECT " . $cols . "FROM orderdetails,orders,products ";
    $result = $conn->query($sql);


?>
<h1>Query</h1>

<div id="wrap">
    <div id="left_col">
        <h2> Select Order Parameters </h2>
        <!-Input fields->
         <form action="dbqueery2.php" method="post">
        Order Number: <input type="text" name="orderNumber"> or <br> <br>
        Order Date (YYYY-MM-DD) <br>
        from: <input type="text" name="startDate"> to: <input type="text" name="endDate"> <br>
        <br><br><br><input type="submit"> <br>
    </div>

    <div id="right_col">
        <h2> Select Columns to Display </h2>
        <input type="checkbox" name="check_list[]" value=<?php "{row["orderNumber"]}" ?> > Order Number<br>
        <input type="checkbox" name="check_list[]" value=<?php "{row["orderDate"]}" ?>> Order Date<br>
        <input type="checkbox" name="check_list[]" value=<?php "{row["shippedDate"]}" ?>> Shipped Date<br>
        <input type="checkbox" name="check_list[]" value=<?php "{row["productName"]}" ?>> Product Name<br>
        <input type="checkbox" name="check_list[]" value=<?php "{row["productDescription"]}" ?>> Product Description<br>
        <input type="checkbox" name="check_list[]" value=<?php "{row["quantityOrdered"]}" ?>> Quantity Ordered<br>
        <input type="checkbox" name="check_list[]" value=<?php "{row["priceEach"]}" ?>> Price Each<br>
        </form>
    </div>

</div>
    <h3> SQL Query </h3>
<?php
    echo "<b>SELECT </b>". $orderNumber ;
    //3.Use returned data(if any)
    while ($row=mysqli_fetch_assoc($result)){
        echo "<tr>";
        foreach($row as $value){
            echo "<td>".stripslashes($value). "</td>";
        }
    }

    // if ($result->num_rows > 0) {
    //     echo "<table><tr>
    //     <th>ID</th>
    //     <th>Name</th></tr>";
    //     // output data of each row
    //     while($row = $result->fetch_assoc()) {
    //         echo "<tr><td>".$row["orderNumber"]."</td><td>"
    //         .$row["orderLineNumber"]
    //         . "</td></tr>";
    //     }
    //     echo "</table>";
    // } else {
    //     echo "0 results";
    // }


    //4.Release returned data
    mysqli_free_result($result);
?>
</body>
</html>

<?php
    //5. Close database connection
    mysqli_close($conn);
?>