Guest User

Untitled

a guest
Nov 17th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.65 KB | None | 0 0
  1. <div class="video-sec">
  2. <h4 class="heading-small">Mídias</h4>
  3. <div class="video-block">
  4. <ul class="nav nav-pills justify-content-center mb-4" id="pills-nav" role="tablist">
  5.  
  6. <?php
  7. // Atribui uma conexão PDO
  8. $conexao = Connection::getInstance();
  9.  
  10. $controle_ativo = 3;
  11. //$controle_num_slide = 1;
  12. $sql = "SELECT * FROM db_post WHERE status=1 AND category='Mídia' ORDER BY created DESC LIMIT 3";
  13.  
  14. $stm = $conexao->prepare($sql);
  15. $stm->execute();
  16.  
  17. while($post = $stm->fetch(PDO::FETCH_OBJ)) {
  18. if($controle_ativo == 3) { ?>
  19. <li class="nav-item">
  20. <a class="nav-link active" id="nav-pills-01" data-toggle="pill" href="#<?=$post->post_id?>"><?=$post->title?></a>
  21. </li>
  22. <?php
  23. $controle_ativo = 2;
  24. } else {
  25. ?>
  26. <li class="nav-item">
  27. <a class="nav-link" id="nav-pills-02" data-toggle="pill" href="#<?=$post->post_id?>"><?=$post->title?></a>
  28. </li>
  29. <?php
  30. //$controle_num_slide++;
  31. }
  32. }
  33. ?>
  34. </ul>
  35. <div class="tab-content" id="nav-pills-content">
  36. <?php
  37. // Atribui uma conexão PDO
  38. $conexao = Connection::getInstance();
  39.  
  40. $controle_ativo = 3;
  41. $sql = "SELECT * FROM db_post WHERE status=1 AND category='Mídia' ORDER BY created DESC LIMIT 3";
  42.  
  43. $stm = $conexao->prepare($sql);
  44. $stm->execute();
  45.  
  46. while($post = $stm->fetch(PDO::FETCH_OBJ)) {
  47. if($controle_ativo == 3) { ?>
  48. <div class="tab-pane fade show active" id="<?=$post->post_id?>" role="tabpanel">
  49. <div class="row">
  50. <div class="col-sm-6">
  51. <div class="embed-responsive embed-responsive-16by9"> <!-- 21by9, 16by9, 4by3, 1by1 -->
  52. <iframe class="embed-responsive-item" src="<?=$post->url?>"></iframe>
  53. </div>
  54. </div>
  55. <div class="col-sm-6">
  56. <p class="display-5"><?=$post->content?></p>
  57. <p class="card-text">
  58. <small class="text-time">
  59. <em>Publicado em <?=date('M,d',strtotime($post->created))?></em>
  60. </small>
  61. </p>
  62. </div>
  63. </div>
  64. </div>
  65. <?php
  66. $controle_ativo = 2;
  67. } else {
  68. ?>
  69. <div class="tab-pane fade" id="<?=$post->post_id?>a" role="tabpanel">
  70. <div class="row">
  71. <div class="col-sm-6">
  72. <div class="embed-responsive embed-responsive-16by9"> <!-- 21by9, 16by9, 4by3, 1by1 -->
  73. <iframe class="embed-responsive-item" src="<?=$post->url?>"></iframe>
  74. </div>
  75. </div>
  76. <div class="col-sm-6">
  77. <p class="display-5"><?=$post->content?></p>
  78. <p class="card-text">
  79. <small class="text-time">
  80. <em>Publicado em <?=date('M,d',strtotime($post->created))?></em>
  81. </small>
  82. </p>
  83. </div>
  84. </div>
  85. </div>
  86. <?php
  87. }
  88. }
  89. ?>
  90. </div>
Add Comment
Please, Sign In to add comment