在我的页面上,我想对数据库进行查询并对结果进行分页,以便它们根据当前时间查看页面的人数按降序排列。我想让它从左到右读取前三行,然后切换到新行,然后从左到右读取结果4到6,等等,等等。
我把表格布置成这样:
<div class="popular1">
<table class="pop-table-thumb">
<tr colspan="3">
<div class="pop-table-header">
Most popular
</div>
<br>
</tr>
<tr>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
</tr>
<tr>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
</tr>
<tr>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
<td>
<div class="pop-thumb">
<img class="img-thumb" src="Images/DefaultThumbnail.gif"/>
</div>
</td>
</tr>
</table>
</div>
我知道如何做基本的分页和列出从关联查询的结果,例如:
$query = mysql_query("SELECT `something` FROM `something`");
while ($assoc_array = mysql_fetch_assoc($query)) {
echo '<p>', $assoc_array['something'] ,'</p>';
}
有谁知道我该怎么做吗?
您可以轻松地创建3宽行,通过使用计数器和模数%
<div class="popular1">
<table class="pop-table-thumb">
<tr>
<td colspan="3"><div class="pop-table-header">Most popular</div><br></td>
</tr>
<?php
$counter = 1; // basic counter to be used in the while loop
while($row = .....){
if($counter%3 == 1){ // if modulus == 1 (ie. 1,4,7) start a row
echo'<tr>';}
// This is where you can change your data from your database
echo '<td><div class="pop-thumb"><img class="img-thumb" src="Images/DefaultThumbnail.gif"/></div></td>';
if($row%3 == 0){ // if modulus == 0 (ie. 3,6,9) close the row
echo'</tr>';}
$counter++;} // increase the counter
?>
</table>
</div>