Advertisement
Guest User

Untitled

a guest
Jun 14th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. <?php
  2. $servername = "servidor";
  3. $username = "usuari";
  4. $password = "password";
  5. $dbname = "bbdd";
  6. // Create connection
  7. $conn = new mysqli($servername, $username, $password, $dbname);
  8. // Check connection
  9. if ($conn->connect_error) {
  10. die("Connection failed: " . $conn->connect_error);
  11. }
  12. $sql = "SELECT * FROM `biblioteca_recursos`";
  13. $result = $conn->query($sql);
  14. if ($result->num_rows > 0) {
  15. // output data of each row
  16. while($row = $result->fetch_assoc()) {
  17. ?>
  18. <div class="col-md-1 col-sm-6 mix <?php echo "$row[categoria]";?> <?php echo "$row[tags]";?>">
  19. <div class="item-box">
  20. <figure>
  21. <span class="item-hover">
  22. <span class="overlay dark-5"></span>
  23. <span class="inner">
  24. <a class="ico-rounded" href="<?php echo "$row[link]";?>">
  25. <span class="glyphicon glyphicon-home size-20"></span>
  26. </a>
  27. </span>
  28. </span>
  29. <img src="<?php echo "$row[url_imatge]";?>" height="100" width="100"alt="">
  30. </figure>
  31. <div>
  32. <p class="text-center"><?php echo "$row[nom]";?></p>
  33. </div>
  34. </div>
  35. </div>
  36. <?php }
  37. } else {
  38. echo "0 results";
  39. }
  40. $conn->close();
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement