我有一个使用php.html的照片库所以,不用数据库,工作很棒!使用此代码的照片和缩略图:
<div id="js-grid-slider-thumbnail" class="cbp">
<div class="cbp-item">
<div class="cbp-caption">
<div class="cbp-caption-defaultWrap">
<img src="img/header/header_03.jpg" alt="">
</div>
</div>
</div><!-- end item -->
<div class="cbp-item">
<div class="cbp-caption">
<div class="cbp-caption-defaultWrap">
<img src="img/header/header_04.jpg" alt="">
</div>
</div>
</div><!-- end item -->
<div class="cbp-item">
<div class="cbp-caption">
<div class="cbp-caption-defaultWrap">
<img src="img/header/header_05.jpg" alt="">
</div>
</div>
</div><!-- end item -->
</div><!-- end js-grid-slider-thumbnail -->
<div id="js-pagination-slider">
<div class="cbp-pagination-item cbp-pagination-active">
<img src="img/header/header_03.jpg" alt="">
</div>
<div class="cbp-pagination-item">
<img src="img/header/header_04.jpg" alt="">
</div>
<div class="cbp-pagination-item">
<img src="img/header/header_05.jpg" alt="">
</div>
</div><!-- end js-pagination-slider -->
但我想使用数据库,我正在尝试使用SelectSQL,从id区域spring
的数据库中选择所有照片,但我看到了照片和缩略图,无法使用
<?php
$sql2 = mysql_query("select * from Photos where photoid='spring'");
while ($row = mysql_fetch_array($sql2)) { ?><div id="js-grid-slider-thumbnail" class="cbp">
<div class="cbp-item">
<div class="cbp-caption">
<div class="cbp-caption-defaultWrap">
<img src="img/portfolio/<? echo $row['link'];?>" alt="">
</div>
</div>
</div><!-- end item -->
</div><!-- end js-grid-slider-thumbnail --><?}?>
<div id="js-pagination-slider">
<?php while ($row2 = mysql_fetch_array($sql2)) { ?>
<div class="cbp-pagination-item cbp-pagination-active">
<img src="img/portfolio/<? echo $row2['link'];?>" alt="">
</div>
<?}?>
</div><!-- end js-pagination-slider -->
问题:照片效果不错但我看不到缩略图有人能帮我吗?感谢
将包装器放在外面,或者当循环作为JS的id时,只需要像下面一样对循环外使用的分页进行一次,所以只显示一次希望,这是有效的!
<?php
$sql2 = mysql_query("select * from Photos where photoid='spring'"); ?>
<div id="js-grid-slider-thumbnail" class="cbp">
<?php
while ($row = mysql_fetch_array($sql2)) { ?>
<div class="cbp-item">
<div class="cbp-caption">
<div class="cbp-caption-defaultWrap">
<img src="img/portfolio/<? echo $row['link'];?>" alt="">
</div>
</div>
</div><!-- end item -->
</div><!-- end js-grid-slider-thumbnail --><?}?>
<div id="js-pagination-slider">
<?php while ($row2 = mysql_fetch_array($sql2)) { ?>
<img src="img/portfolio/<? echo $row2['link'];?>" alt="">
</div>
<?}?>
</div><!-- end js-pagination-slider -->