Advertisement
Guest User

Untitled

a guest
Nov 28th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.95 KB | None | 0 0
  1. <div id="tags" style="float: left; padding-left: 50px;">
  2. <p>Ultimas 10 TAGS cadastradas</p>
  3. <?php
  4. $servername = "";
  5. $username = "";
  6. $password = "";
  7. $dbname = "";
  8.  
  9. // Create connection
  10. $conn = new mysqli($servername, $username, $password, $dbname);
  11. // Check connection
  12. if ($conn->connect_error) {
  13. die("Connection failed: " . $conn->connect_error);
  14. }
  15.  
  16. $sql = "SELECT skype, tag FROM tag ORDER BY tag DESC LIMIT 10";
  17. $result = $conn->query($sql);
  18.  
  19. if ($result->num_rows > 0) {
  20. // output data of each row
  21. while($row = $result->fetch_assoc()) {
  22. echo "Skype do Dono: " . $row["skype"]. " Tag: " . $row["tag"]. "<br>";
  23. }
  24. } else {
  25. echo "Nenhum clã cadastrado";
  26. }
  27. $conn->close();
  28. ?>
  29. </div>
  30. <div id="videos" style="float: right; padding-left: 50px;">
  31. <p>Ultimos 3 Videos no PDB</p>
  32. <?php
  33. $servername = "";
  34. $username = "";
  35. $password = "";
  36. $dbname = "";
  37.  
  38. // Create connection
  39. $conn = new mysqli($servername, $username, $password, $dbname);
  40. // Check connection
  41. if ($conn->connect_error) {
  42. die("Connection failed: " . $conn->connect_error);
  43. }
  44.  
  45. $sql = "SELECT nomecanal, link FROM video";
  46. $result = $conn->query($sql);
  47.  
  48. if ($result->num_rows > 0) {
  49. // output data of each row
  50. while($row = $result->fetch_assoc()) {
  51.  
  52. }
  53. } else {
  54. echo "Nenhum video cadastrado";
  55. }
  56. $conn->close();
  57. ?>
  58.  
  59.  
  60. <?php
  61. $url = $row["link"];
  62. parse_str( parse_url( $url, PHP_URL_QUERY ), $v );
  63. $object = '<iframe width="560" height="315" src="https://www.youtube.com/embed/'.$v['v'].'" frameborder="0" allowfullscreen></iframe>';
  64. echo $object;
  65. ?>
  66.  
  67. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement