Advertisement
Guest User

Untitled

a guest
Mar 4th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. <?php
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "joes_hot_spot";
  7.  
  8. // Create connection
  9. $conn = mysqli_connect($servername, $username, $password, $dbname);
  10. // Check connection
  11. if (!$conn) {
  12.     die("Connection failed: " . mysqli_connect_error());
  13. }
  14.  
  15. $sql = "SELECT * FROM menu_item";
  16. $result = mysqli_query($conn, $sql);
  17.  
  18.  
  19. if (mysqli_num_rows($result) > 0) {
  20. echo " <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">";
  21.     // output data of each row
  22.     while($row = mysqli_fetch_assoc($result)) {
  23.         echo " <div class="col-lg-4 col-md-4 col-sm-4 col-xs-4"> ";
  24.             echo "<div class="menu-item">;
  25.                 echo "<img src='" .$row['item_picture'] . "'></img> <br> ";
  26.                 echo $row['item_name'] . " <br>";
  27.                 echo $row['Item_ID'] . " <br>";
  28.                 echo $row['Item_type'] . " <br> ";
  29.                 echo $row['Item_price'] . " <br> ";
  30.                 echo $row['Item_description'] . " ";
  31.             echo "</div>";
  32.        
  33.    }
  34.     echo "</div>";
  35. } else {
  36.    echo "0 results";
  37. }
  38.  
  39. mysqli_close($conn);
  40. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement