Advertisement
Guest User

Untitled

a guest
Apr 27th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.06 KB | None | 0 0
  1. <?php
  2. include ('header.php');
  3. //CONECTARE BAZA DE DATE
  4.  
  5. $servername = "localhost";
  6. $username = "xxx";
  7. $password = "xxx";
  8. $dbname = "xxx";
  9.  
  10. // creaza conexiunea
  11. $databaseConnection = new mysqli($servername, $username, $password, $dbname);
  12. // verifica conexiunea
  13.     if ($databaseConnection->connect_error) {
  14.         die("Conexiunea a esuat: " . $databaseConnection->connect_error);
  15. }
  16.  
  17. //CONECTARE BAZA DE DATE END
  18. ?>
  19. <html>
  20. <head>
  21.     <title>Postari</title>
  22. </head>
  23. <body>
  24.     <?php
  25.     $afisare = ("SELECT * FROM postari ORDER BY id DESC");
  26.     $afisam = $databaseConnection->query($afisare);
  27.     if ($afisam->num_rows > 0) {
  28.         //afisare folosind while
  29.         while($rowz = $afisam->fetch_assoc()) {
  30.         ?>
  31.         <div class="container" style="width: 80%;">
  32. <div class="row">
  33.   <div class="span8">
  34.     <div class="row">
  35.       <div class="span8">
  36.         <h4><strong><a href="#"><?php echo $rowz["titlu"]; ?></a></strong></h4>
  37.       </div>
  38.     </div>
  39.     <div class="row">
  40.       <div class="span2">
  41.           <div class="col-md-4">
  42.         <a href="#" class="thumbnail">
  43.             <img src="<?php echo $rowz["link"]; ?>" alt="">
  44.         </a>
  45.       </div>
  46.       </div>
  47.       <div class="span6">
  48.           <div class="col-md-8">      
  49.         <p class="textNou">
  50.           <?php echo $rowz["textMic"]; ?>
  51.         </p>
  52.         <p><a class="btn btn-default" class="buton<?php echo $rowz["id"];?>">Citeste mai mult...</a></p>
  53. <script>
  54.         var clasa=".buton"."<?php echo $rowz["id"]; ?>";
  55.         $(clasa).click(function() {
  56.         $(".textNou").text("<?php echo $rowz["text"]; ?>");
  57.         });
  58.  
  59. </script>
  60.         </div>
  61.       </div>
  62.     </div>
  63.     <div class="row">
  64.       <div class="span8">
  65.         <p></p>
  66.         <p>
  67.           <i i class="fa fa-user" aria-hidden="true"></i> de <a href="#"><?php echo $rowz["nume"]; ?></a>
  68.           | <i class="fa fa-calendar" aria-hidden="true"></i> <?php echo $rowz["data"]; ?>
  69.         </p>
  70.       </div>
  71.     </div>
  72.   </div>
  73. </div>
  74. </div>
  75. <hr>
  76.         <?php }} ?>
  77.  
  78. </body>
  79. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement