我正在使用 mysqli fetch 數組從 mysql 表中獲取數據，在獲取后我想要輪播項目顯示他從數組中的索引號，以便我可以使用索引號識別它們以提供活動屬性<?php $qry = mysqli_query($koneksi, "SELECT * FROM t_berita ORDER BY tanggal DESC LIMIT 3"); while($row = mysqli_fetch_array($qry, MYSQLI_ASSOC)){ $qrygbr = mysqli_query($koneksi, "SELECT * FROM t_gambar WHERE id_berita = '".$row['id']."'");; $rowcount=mysqli_num_rows($qry); while ($rowgbr = mysqli_fetch_array($qrygbr, MYSQLI_ASSOC)) { # code... ?> <div class="carousel-item active"> <div class="card"> <div class="card-body" style="padding: 0;"> <div class="row"> <div class="col-lg-6"><img class="img-fluid" style="width: 100%;height: 100%;background-image: url(data:image/jpeg;base64,<?php echo base64_encode($rowgbr['gambar']);?>);background-position: center;background-size: cover;background-repeat: no-repeat;" /></div> <div class="col-lg-6"> <div class="d-md-flex d-lg-flex flex-column justify-content-md-center align-items-md-center justify-content-lg-center align-items-lg-start" style="padding-top: 20px;padding-left: 10px;padding-right: 10px;height: 100%;margin-bottom: 20px;"> <h4><?php echo $row['judul']; ?></h4> <h6 class="text-muted card-subtitle mb-2">
3 回答
哈士奇WWW
TA貢獻1799條經驗 獲得超6個贊
更改第二個查詢
$qrygbr = mysqli_query($koneksi, "SELECT @a:=@a+1 serial_number,t_gambar.* FROM t_gambar, (SELECT @a:= 0) AS a WHERE t_gambar.id_berita = '".$row['id']."'");
while ($rowgbr = mysqli_fetch_array($qrygbr, MYSQLI_ASSOC)) {
echo $rowgbr['serial_number']; //this is you your needed serial number
}
繁花如伊
TA貢獻2012條經驗 獲得超12個贊
以下內容應該可以幫助您了解您需要做什么。我在循環中應用了一個 $count 變量，以隨著循環的繼續而增加。我已將變量添加到
向您展示它是如何工作的。
<?php
$koneksi = mysqli_connect('localhost', 'admbumm_DedSec', 'omnimon786.,', 'admbumm_selipin');
$qry = mysqli_query($koneksi, "SELECT * FROM t_berita ORDER BY tanggal DESC LIMIT 3");
while($row = mysqli_fetch_array($qry, MYSQLI_ASSOC)){
$qrygbr = mysqli_query($koneksi, "SELECT * FROM t_gambar WHERE id_berita = '".$row['id']."'");
$rowcount=mysqli_num_rows($qry);
$count = 1;
while ($rowgbr = mysqli_fetch_array($qrygbr, MYSQLI_ASSOC)) {
# code...
?>
<div class="carousel-item active">
<div class="card">
<div class="card-body" style="padding: 0;">
<div class="row">
<div class="col-lg-6"><img class="img-fluid" style="width: 100%;height: 100%;background-image: url(data:image/jpeg;base64,<?php echo base64_encode($rowgbr['gambar']);?>);background-position: center;background-size: cover;background-repeat: no-repeat;" /></div>
<div class="col-lg-6">
<div class="d-md-flex d-lg-flex flex-column justify-content-md-center align-items-md-center justify-content-lg-center align-items-lg-start" style="padding-top: 20px;padding-left: 10px;padding-right: 10px;height: 100%;margin-bottom: 20px;">
<h4><?php
echo $row['judul'];
?></h4>
<h6 class="text-muted card-subtitle mb-2">
<?php
echo $row['tanggal'].$rowgbr[];
?>
</h6>
<p>
<?php
echo $row['artikel'];
?>
</p>
<p>
<p>
<?php
echo $count;
?>
</p>
</p>
<div class="d-flex"></div><a class="btn btn-primary" role="button" href="bacaberita.php?id=<?php echo $row['id'] ?>">Read More</a></div>
</div>
</div>
</div>
</div>
</div>
<?php
$count = $count + 1;
}
}
mysqli_close($koneksi);
?>
回首憶惘然
TA貢獻1847條經驗 獲得超11個贊
您可能想像這樣在 SQL 查詢中添加另一個變量 $qry = mysqli_query($koneksi, "SELECT * FROM t_berita ORDER BY tanggal DESC LIMIT 3");
至 $qry = mysqli_query($koneksi, "SELECT COUNT(*) as c,* FROM t_berita ORDER BY tanggal DESC LIMIT 3");
基本上，SQL 將計算可用的總行數并將其放入c。c所以你可以在你的 PHP 代碼中做一些簡單的循環
- 3 回答
- 0 關注
- 156 瀏覽
添加回答
舉報
0/150
提交
取消