Guest User

Untitled

a guest
Jun 25th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. <?php
  2.  
  3. $SQL_Query = "SELECT * FROM your_table";
  4. $SQL_Run = mysqli_query($db, $SQL_Query);
  5.  
  6. while ($row = mysqli_fetch_assoc($SQL_Run)) {
  7. echo
  8. "<section class='wrapper style1'>
  9. <div class='inner'>
  10. <header class='align-center'>
  11. <h2>" . $row['imageurl'] . "</h2>
  12. <img src='" . $row['title'] . "'>
  13. <p>" . $row['description'] . "</p>
  14. </header>
  15. </div>
  16. </section>";
  17. }
  18.  
  19. ?>
  20.  
  21. <?php
  22. $servername = "127.0.0.1";
  23. $username = "root";
  24. $password = "yourpasswordhere";
  25. $dbname = "yourdatabasenamehere";
  26.  
  27. // Create connection
  28. $conn = new mysqli($servername, $username, $password, $dbname);
  29. // Check connection
  30. if ($conn->connect_error) {
  31. die("Connection failed: " . $conn->connect_error);
  32. }
  33.  
  34. $sql = "SELECT id, type, title FROM releases";
  35. $result = $conn->query($sql);
  36.  
  37. if ($result->num_rows > 0) {
  38. // output data of each row
  39. while($row = $result->fetch_assoc()) {
  40. echo "id: " . $row["id"]. " - Type: " . $row["type"]. " - Title " . $row["title"]. "<br>";
  41. }
  42. } else {
  43. echo "0 results";
  44. }
  45. $conn->close();
  46. ?>
Add Comment
Please, Sign In to add comment