1 回答

TA貢獻1860條經(jīng)驗 獲得超9個贊
我認(rèn)為你可以這樣做:
$result = $this->connect()->query("SELECT * FROM wm_products ORDER BY RAND() LIMIT 2");
$i = 0;
$html = "";
if($result->num_rows > 0) {
$html .= "<div class='new-product'>";
while($row = $result->fetch_assoc()) {
if($i%2 == 0) {
$html .= "<div class='row'>
<div class='col-sm-6'>
<p>{$row->text}</p>
</div>
<div class='col-sm-6'>
<img src='{$row->image}' alt=''>
</div>
</div>";
} else {
$html .= "<div class='row'>
<div class='col-sm-6'>
<img src='{$row->image}' alt=''>
</div>
<div class='col-sm-6'>
<p>{$row->text}</p>
</div>
</div>";
}
$i++;
}
$html .= "</div>";
}
echo $html;
假設(shè)您在 SQL 查詢中的列被命名為text和image。否則,將$row->textand替換為$row->image相應(yīng)的列名。
- 1 回答
- 0 關(guān)注
- 150 瀏覽
添加回答
舉報