<?php 
header("Content-Type: text/html; charset=utf-8");
require_once("connMysql.php");
//預設每頁筆數
$pageRow_records = 8;
//預設頁數
$num_pages = 1;
//若已經有翻頁，將頁數更新
if (isset($_GET['page'])) {
  $num_pages = $_GET['page'];
}
//本頁開始記錄筆數 = (頁數-1)*每頁記錄筆數
$startRow_records = ($num_pages -1) * $pageRow_records;
//未加限制顯示筆數的SQL敘述句
$query_RecAlbum = "SELECT `album`.`album_id` , `album`.`album_date` , `album`.`album_location` , `album`.`album_title` , `album`.`album_desc` , `albumphoto`.`ap_picurl`, count( `albumphoto`.`ap_id` ) AS `albumNum` FROM `album` LEFT JOIN `albumphoto` ON `album`.`album_id` = `albumphoto`.`album_id` GROUP BY `album`.`album_id` , `album`.`album_date` , `album`.`album_location` , `album`.`album_title` , `album`.`album_desc` ORDER BY `album_date` DESC";
//加上限制顯示筆數的SQL敘述句，由本頁開始記錄筆數開始，每頁顯示預設筆數
$query_limit_RecAlbum = $query_RecAlbum." LIMIT ".$startRow_records.", ".$pageRow_records;
//以加上限制顯示筆數的SQL敘述句查詢資料到 $RecAlbum 中
$RecAlbum = mysql_query($query_limit_RecAlbum);
//以未加上限制顯示筆數的SQL敘述句查詢資料到 $all_RecAlbum 中
$all_RecAlbum = mysql_query($query_RecAlbum);
//計算總筆數
$total_records = mysql_num_rows($all_RecAlbum);
//計算總頁數=(總筆數/每頁筆數)後無條件進位。
$total_pages = ceil($total_records/$pageRow_records);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>網路相簿</title>
<style type="text/css"></style>
<link href="style3.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {	font-size: 18pt;
	font-weight: bold;
}
.style3 {color: #C6C3C6}
body {
	background-color: #FFFFFF;
}
#Layer4 {	position:absolute;
	width:200px;
	height:52px;
	z-index:2;
	left: 277px;
	top: 3px;
}
-->
</style>
</head>
<body>
<p><span class="style3"></span><span class="style3"></span>
</p>
<div id="Layer4"><img src="images/fu_photo.jpg" width="467" height="61" /></div>
<p>&nbsp;</p>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>
   <td background="images/album_r2_c1.jpg"><div id="mainRegion">
     <table width="90%" border="0" align="center" cellpadding="4" cellspacing="0">
       <tr>
         <td><div class="subjectDiv">  
           <div align="center"><img name="board_r1_c5" src="images/camera.jpg" width="94" height="81" border="0" alt="數位珍藏館"><span class="style1">[遺忘之地-富山部落實景]</span> </div>
         </div>
           <div class="actionDiv">相簿總數: <?php echo $total_records;?></div>  
           <div class="normalDiv"></div>
<?php	while($row_RecAlbum=mysql_fetch_assoc($RecAlbum)){ ?>
           <div class="albumDiv">
           <div class="picDiv"><a href="albumshow.php?id=<?php echo $row_RecAlbum["album_id"];?>"><?php if($row_RecAlbum["albumNum"]==0){?><img src="images/nopic.png" alt="暫無圖片" width="120" height="120" border="0" /><?php }else{?><img src="photos/<?php echo $row_RecAlbum["ap_picurl"];?>" alt="<?php echo $row_RecAlbum["album_title"];?>" width="120" height="120" border="0" /><?php }?></a></div>
           <div class="albuminfo"><a href="albumshow.php?id=<?php echo $row_RecAlbum["album_id"];?>"><?php echo $row_RecAlbum["album_title"];?></a><br />
             <span class="smalltext">共 <?php echo $row_RecAlbum["albumNum"];?> 張</span><br>
             <br>
           </div>
           </div>
           <?php }?>
           <div class="navDiv">
             <?php if ($num_pages > 1) { // 若不是第一頁則顯示 ?>
             <a href="?page=1">|&lt;</a> <a href="?page=<?php echo $num_pages-1;?>">&lt;&lt;</a>
             <?php }else{?>
             |&lt; &lt;&lt;
  <?php }?>
  <?php
  	  for($i=1;$i<=$total_pages;$i++){
  	  	  if($i==$num_pages){
  	  	  	  echo $i." ";
  	  	  }else{
  	  	      echo "<a href=\"?page=$i\">$i</a> ";
  	  	  }
  	  }
  	  ?>
  <?php if ($num_pages < $total_pages) { // 若不是最後一頁則顯示 ?>
  <a href="?page=<?php echo $num_pages+1;?>">&gt;&gt;</a> <a href="?page=<?php echo $total_pages;?>">&gt;|</a>
  <?php }else{?>
  &gt;&gt; &gt;|
  <?php }?>
           </div></td>
         </tr>
     </table>
   </div></td>
  </tr>
  <tr>
   <td align="center" background="images/album_r2_c1.jpg" class="trademark">&nbsp;</td>
  </tr>
  <tr>
   <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>
