- 最後登錄
- 2022-5-7
- 在線時間
- 95 小時
- 註冊時間
- 2014-10-7
- 閱讀權限
- 20
- 精華
- 0
- UID
- 14915321
- 帖子
- 189
- 積分
- 118 點
- 潛水值
- 6980 米
| 1. 先把你的相片資料用array存起來
2. 再用for迴圈輸出相片資料- <?php
- require_once("connect.php");
- $album_id = $_GET["album_id"];
- $link = create_connection();
- //相簿名稱及主人
- $sql = "SELECT name, owner FROM album WHERE id = $album_id";
- $result = execute_sql("album", $sql, $link);
- $album_name = mysql_result($result, 0, "name");
- $album_owner = mysql_result($result, 0, "owner");
-
- echo "<p align='center'>$album_name</p>";
-
- //取得相簿裡所有照片
- $sql = "SELECT id, name, filename FROM photo WHERE album_id = $album_id";
- $result = execute_sql("album", $sql, $link);
- $total_fields = mysql_num_fields($result);
- $photo_id = array();
- $photo_name = array();
- $file_name = array();
- //顯示相片
- while ($row = mysql_fetch_assoc($result))
- {
- array_push($photo_id, $row["id"]);
- array_push($photo_name, $row["name"]);
- array_push($file_name, $row["filename"]);
- }
- ?>
- <div id="wowslider-container1">
- <div class="ws_images" style="position:relative; top:70px;">
- <ul>
- <?php
- for ($i = 0; $i <= $total_fields-1; $i++)
- {
- echo"<li><img src= 'Photo/".$file_name[$i]."'></li>";
- }
- ?>
- </ul>
- </div>
- <div class="ws_bullets">
- <div>
- <?php
- for ($i = 0; $i <= $total_fields-1; $i++)
- {
- echo "<a href=#><span><img src= 'Thumbnail/".$file_name[$i]."'></span></a>";
- }
- ?>
- </div>
- </div>
- <div class="ws_shadow"></div>
- </div>
- <script type="text/javascript" src="engine3/wowslider.js"></script>
- <script type="text/javascript" src="engine3/script.js"></script>
複製代碼 ... |
|