昨天我没有得到这个问题的答案。https://stackoverflow.com/questions/15206351/jquery-slider-with-newest-content-first-gets-reversed-thumbnails-clicking-on-fi
所以我尝试了一个更简单的解决方案。我想修改这段代码:
$news_countpp = 6;
$result = mysqli_query($con,"SELECT * FROM tbl_news ORDER BY id DESC LIMIT ".($news_page * $news_countpp).", $news_countpp");
while($row = mysqli_fetch_array($result))
{
echo "<div><a href='#".$row['id']."' class='cross-link'><img src='/assets/images/news/news_".$row['id']."_slider_thumb.jpg' alt='".$row['news_img_alt']."' class='nav-thumb' alt='temp-thumb' style='width:60px; height:40px;'></a></div>";
}
Part <a href='#".$row['id']."
将从#6到#1依次返回降序数字。(最新消息最高ID)我想要的数字升序而不是(不是根据id),而不是它的工作。
我尝试用以下数组代替".row['id']。":
$thumblink = array ('1', '2', '3', '4', '5', '6');
for ($i = 0; $i < 6; $i++) {
echo $thumblink[$i];
}
但是这给了我的6个缩略图中的每个缩略图一个href "123456",而不是从1到6的升序数字。你知道我做错了什么吗?
$news_countpp = 6;
$result = mysqli_query($con,"SELECT * FROM tbl_news ORDER BY id DESC LIMIT ".($news_page * $news_countpp).", $news_countpp");
$i = 1
while($row = mysqli_fetch_array($result))
{
echo "<div><a href='#".$i."' class='cross-link'><img src='/assets/images/news/news_".$row['id']."_slider_thumb.jpg' alt='".$row['news_img_alt']."' class='nav-thumb' alt='temp-thumb' style='width:60px; height:40px;'></a></div>";
$i++;
}
我猜你在while
循环的每次迭代中遍历整个数组。相反,在while
循环之前将数组和计数器变量初始化为0
,并且每次迭代只访问一个元素(当您这样做时,将计数器增加1)。
这样怎么样?
$i = 0;
while($row = mysqli_fetch_array($result)) {
$i++;
echo
"<div>",
"<a href='#".$row['id']."' class='cross-link'>",
"<img src='/assets/images/news/news_", $row[$i], "_slider_thumb.jpg'
alt='".$row['news_img_alt']."'
class='nav-thumb' alt='temp-thumb'
style='width:60px; height:40px;'>",
"</a>",
"</div>";
}