display_products

<?php
    $server_name = "localhost";
    // $serverUsername = ""
    $serverUserName = "";
    //$servPassword  = ""
    $servPassword = "";
    $db_name = "Credentials";

    //create connection
    $conn = new mysqli($server_name, $serverUserName, $servPassword, $db_name);

    //check connection
    if ($conn->connect_error) {
    die("Connection Failed : " . $conn->connect_error);
    }

    $sql = "SELECT * FROM products.products";
    $result = $conn->query($sql);

        //start div and list
        echo "<div id='products'>";
        echo "<ul>";

        //loop through products and output as list items within products div
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $prod_name = $row['prod_name'];
            $prod_description = $row['prod_description'];
            $prod_price = $row['prod_price'];
            $qty = $row['qty'];

                    echo "<li>";
                        echo "<h1>$prod_name</h1>";
                        echo "<p>$prod_description</p>";
                        echo "<p>$prod_price</p>";
                        echo "<p>$qty</p>";
                    echo "</li>";

        }
    }
        //close ul and div
        echo "</ul>";
        echo "</div>";

?>