我正在使用 PDO 將圖像從數據庫插入到 Bootstrap 輪播。我的意思是（加載圖像路徑），但問題是當我使用fetchall();或fetch獲取所有行值時，如下所示：require_once '..\Config.php';$dbCon = "mysql:host=$host;dbname=$db_name";$conn = new PDO($dbCon, $username, $password);$getquery = $conn->prepare('SELECT (imageurl) FROM special');$getquery->execute();$result = $getquery->fetchall();echo $result['imageurl'];輸出是：Efexor.jpg path upload/17.jpg upload/17.jpg upload/19.jpg upload/18.jpg upload/18.jpg*這是 imageurl 列中的所有行，所以當我循環foreach( $result) 加載從數據庫到 Bootstrap 輪播的圖像。它不起作用<div id="demo" class="carousel slide" data-ride="carousel"> <!-- Indicators --> <ul class="carousel-indicators"> <? $i = 0; foreach($result as $row){ $actives = ''; if($i == 0){ $actives ='active'; } ?> <li data-target="#demo" data-slide-to="<?= $i; ?>" class="<?= $actives;?>"></li> <? $i++ ; }?> </ul> <!-- The slideshow --> <div class="carousel-inner"> <? $i = 0; foreach($result as $row){ $actives = ''; if($i == 0){ $actives ='active'; } ?> <div class="carousel-item <?= $actives;?>"> <img src="<?= $row['imageurl']?>"> </div> <? echo $row['imageurl'];?> <? $i++; }?> </div> <!-- Left and right controls --> <a class="carousel-control-prev" href="#demo" data-slide="prev"> <span class="carousel-control-prev-icon"></span> </a> <a class="carousel-control-next" href="#demo" data-slide="next"> <span class="carousel-control-next-icon"></span> </a></div>
1 回答
倚天杖
TA貢獻1828條經驗 獲得超3個贊
試試這樣：
<!-- The slideshow -->
<div class="carousel-inner">
<?
$i = 0;
$full_url = 'YOUR URL AND PATH TO IMAGE FOLDER HERE';
foreach($result as $row){
$actives = '';
if($i == 0){
$actives ='active';
}
?>
<div class="carousel-item <?= $actives;?>">
<img src="<?= $full_url . $row['imageurl']?>">
</div>
<? echo $full_url . $row['imageurl'];?>
<? $i++; }?>
</div>
- 1 回答
- 0 關注
- 102 瀏覽
添加回答
舉報
0/150
提交
取消