Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include ('header.php');
- //CONECTARE BAZA DE DATE
- $servername = "localhost";
- $username = "xxx";
- $password = "xxx";
- $dbname = "xxx";
- // creaza conexiunea
- $databaseConnection = new mysqli($servername, $username, $password, $dbname);
- // verifica conexiunea
- if ($databaseConnection->connect_error) {
- die("Conexiunea a esuat: " . $databaseConnection->connect_error);
- }
- //CONECTARE BAZA DE DATE END
- ?>
- <html>
- <head>
- <title>Postari</title>
- </head>
- <body>
- <?php
- $afisare = ("SELECT * FROM postari ORDER BY id DESC");
- $afisam = $databaseConnection->query($afisare);
- if ($afisam->num_rows > 0) {
- //afisare folosind while
- while($rowz = $afisam->fetch_assoc()) {
- ?>
- <div class="container" style="width: 80%;">
- <div class="row">
- <div class="span8">
- <div class="row">
- <div class="span8">
- <h4><strong><a href="#"><?php echo $rowz["titlu"]; ?></a></strong></h4>
- </div>
- </div>
- <div class="row">
- <div class="span2">
- <div class="col-md-4">
- <a href="#" class="thumbnail">
- <img src="<?php echo $rowz["link"]; ?>" alt="">
- </a>
- </div>
- </div>
- <div class="span6">
- <div class="col-md-8">
- <p class="textNou">
- <?php echo $rowz["textMic"]; ?>
- </p>
- <p><a class="btn btn-default" class="buton<?php echo $rowz["id"];?>">Citeste mai mult...</a></p>
- <script>
- var clasa=".buton"."<?php echo $rowz["id"]; ?>";
- $(clasa).click(function() {
- $(".textNou").text("<?php echo $rowz["text"]; ?>");
- });
- </script>
- </div>
- </div>
- </div>
- <div class="row">
- <div class="span8">
- <p></p>
- <p>
- <i i class="fa fa-user" aria-hidden="true"></i> de <a href="#"><?php echo $rowz["nume"]; ?></a>
- | <i class="fa fa-calendar" aria-hidden="true"></i> <?php echo $rowz["data"]; ?>
- </p>
- </div>
- </div>
- </div>
- </div>
- </div>
- <hr>
- <?php }} ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement