想让注释部分也循环输出可以吗??怎么做啊??
for($i=0;$i<$datarow;$i++){
$sql_arr = mysqli_fetch_assoc($sql);
$house_address = $sql_arr['house_address'];
echo "<div class='panel panel-info'>
<div class='panel-heading'>
<h4>".$house_address." <span>点击可收起</span></h4>
</div>
<div class='panel-body'>
<div class='row'>
// <div class='col-sm-6 col-md-3'>
// <div class='thumbnail'>
// <img src='image/0.jpg' alt='...'>
// <div class='caption'>
// <h3>房间号 <span>出租状态</span></h3>
// <p>出租价格</p>
// <p><a href='#' class='btn btn-primary' role='button'>查看详情</a> <a
// href='#exampleModal' class='btn btn-default' role='button'
// data-toggle='modal' data-target='#exampleModal'>抄表</a></p>
// </div>
// </div>
// </div>
</div>
</div>
</div>";
}
如图,这是大的循环输出
想让这里面的也循环输出
问题是注释的那部分循环数据从哪来的?如果数据是读取$house_address的数据,应该在读取一次数据库记录后循环,类似下面这样
for($i=0;$i<$datarow;$i++){
$sql_arr = mysqli_fetch_assoc($sql);
$house_address = $sql_arr['house_address'];
echo "<div class='panel panel-info'>
<div class='panel-heading'>
<h4>".$house_address." <span>点击可收起</span></h4>
</div>
<div class='panel-body'>
<div class='row'>";
$sql="select * from yourtable where house_address='$house_address'";///////////注意改sql语句
$query=mysqli_query($conn,$sql);///注意改链接对象变量名
while ( $r = mysqli_fetch_assoc($query)) {
//题主注意修改这里的代码输出需要的内容
echo "<div class='col-sm-6 col-md-3'>
<div class='thumbnail'> $r["xxx"]
<img src='image/0.jpg' alt='...'>
<div class='caption'>
<h3>房间号 <span>出租状态</span></h3>
<p>出租价格</p>
<p><a href='#' class='btn btn-primary' role='button'>查看详情</a> <a
href='#exampleModal' class='btn btn-default' role='button'
data-toggle='modal' data-target='#exampleModal'>抄表</a></p>
</div>
</div>
</div>
";
}
echo "</div></div></div>";
}