我正在尝试显示多个引导 div，每个 div 都有一个来自数据库和其他信息的图像轮播

Question

显示图像工作正常。。然而，其他div显示在第一个div中，而其他信息(如标题、描述等(没有显示。我想要的是像六行一样显示(每行有两列(。。每个div都有一个图像和其他信息的转盘。。我正在建一个房地产网站。。请帮忙。

<div class="container py-4">
<div class="row py-4">
<div class="col-sm-12">
<h1 id="stylish-font">Featured properties</h1>
</div>
</div>

<?php
include"validations/connection.php";

**Query to select data from database**
$sql = "SELECT * FROM property order by propertyId desc";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
echo'
<div class="row py-4">
';
while ($row = $result->fetch_assoc()) {
echo"
<div class='col-sm-6'>

";  
$id= $row['propertyId'];
$sqltwo = "SELECT * FROM propertyimages WHERE propertyId = '$id'";
$resulttwo = $conn->query($sqltwo);
if ($resulttwo->num_rows > 0) {
echo'
<div id="carouselExampleControls" class="carousel slide" data-bs-ride="carousel">
<div class="carousel-inner">
';
while ($rowtwo = $resulttwo->fetch_assoc()) {
$active = $rowtwo['active'];
if ($active == 1) {
echo'
<div class="carousel-item active">
<img src="uploads/'.$rowtwo['imageName'].'" class="d-block w-100" alt="Image">
</div>
';
}
else {        
echo'
<div class="carousel-item">
<img src="uploads/'.$rowtwo['imageName'].'" class="d-block w-100" alt="Image">
</div>
';
}
}
echo'
</div>
<button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleControls" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#carouselExampleControls" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden>Next</span>
</button>
</div>
';
}
";

</div>
";
echo"
<div class='row'>
<p>".$row['propertytitle']."</p>
<p>".$row['description']."</p>
</div>
";
}

echo'
</div>              
';
}

?>

</div>

Answer 1

我们需要更多信息。。。为什么变量$no？我看不出它在代码中有用，你可以把html的表和包含的循环放在一起