<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "joes_hot_spot";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT * FROM menu_item";
$result = mysqli_query($conn, $sql);


if (mysqli_num_rows($result) > 0) {
echo " <div class='col-lg-12 col-md-12 col-sm-12 col-xs-12'>";
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo " <div class='col-lg-3 col-md-3 col-sm-3 col-xs-3'> ";
            echo "<div class='menu-item'>;
                echo "<img src='" .$row['item_picture'] . "'></img> <br> ";
                echo $row['item_name'] . " <br>";
                echo $row['Item_ID'] . " <br>";
                echo $row['Item_type'] . " <br> ";
                echo $row['Item_price'] . " <br> ";
                echo $row['Item_description'] . " ";
            echo "</div>";

    }
    echo "</div>";
} else {
    echo "0 results";
}

mysqli_close($conn);
?>