Postingan lainnya
gimana cara membatasi gambar yg tampil di carousel hanya 3 pict?
misi mas , ada yang tau cara membatasi gambar di carousel , saolnya gambar yg ada di database pada muncul semua di carouselnya
<div class="container">
<div id="carouselExampleControls" class="carousel slide" data-ride="carousel">
<ol class="carousel-indicators">
<li data-target="#carouselExampleIndicators" data-slide-to="0" class="active"></li>
<li data-target="#carouselExampleIndicators" data-slide-to="1"></li>
<li data-target="#carouselExampleIndicators" data-slide-to="2"></li>
</ol>
<div class="carousel-inner" style=" width:100%; height: 400px !important;">
<div class="carousel-item active">
<img class="d-block w-100" src="https://twistedsifter.files.wordpress.com/2016/07/dulmen_bornste_waldweg.jpg" alt="First slide">
</div>
<?php
$stmt = $pdo->prepare('SELECT * FROM galeri ORDER BY id_galeri DESC');
$stmt->execute();
while ($data=$stmt->fetch(PDO::FETCH_ASSOC))
{
extract($data);
# code...
?>
<div class="carousel-item">
<img class="d-block w-100" src="admin/image/<?php echo $data['image']?>" height="555" alt="Second slide">
</div>
<?php
} ?>
<a class="carousel-control-prev" href="#carouselExampleControls" role="button" data-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="sr-only">Previous</span>
</a>
<a class="carousel-control-next" href="#carouselExampleControls" role="button" data-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="sr-only">Next</span>
</a>
</div>
</div>
</div>
0
2 Jawaban:
Jawaban Terpilih
batesin querynya aja pake limit, jadi "SELECT * FROM galeri ORDER BY id_galeri DESC limit 3"
1