01.<html>
02.<head>
03.<title>ThaiCreate.Com Tutorial</title>
04. <script src="js/jquery-1.6.1.min.js" type="text/javascript"></script>
05. <link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen" charset="utf-8" />
06. <script src="js/jquery.prettyPhoto.js" type="text/javascript" charset="utf-8"></script>
07.
08. <style type="text/css" media="screen">
09.
10. body {
11. font: 62.5%/1.2 Arial, Verdana, Sans-Serif;
12. padding: 0 20px;
13. }
14.
15. </style>
16.
17. <script type="text/javascript" charset="utf-8">
18. $(document).ready(function(){
19. $("area[rel^='prettyPhoto']").prettyPhoto();
20.
21. $("a[rel^='prettyPhoto']").prettyPhoto({ animation_speed:'normal',theme:'light_square',slideshow:3000, autoplay_slideshow: true });
22. $("a[rel^='prettyPhoto']").prettyPhoto({ animation_speed:'fast',slideshow:3000, hideflash: true });
23.
24. });
25. </script>
26.
27.</head>
28.<body>
29.<?php
30. $objConnect = mysql_connect("localhost","root","root") or die("Error Connect to Database");
31. $objDB = mysql_select_db("mydatabase");
32.
33. $strSQL = "SELECT * FROM album WHERE AlbumID = '".$_GET["AlbumID"]."' ";
34. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
35. $objResult = mysql_fetch_array($objQuery);
36.?>
37.<h1><?php echo $objResult["AlbumName"];?></h1>
38.<?php
39.
40. $strSQL2 = "SELECT * FROM gallery WHERE AlbumID = '".$_GET["AlbumID"]."' ORDER BY GalleryID ASC ";
41. $objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
42.
43. echo"<table border=\"1\" cellspacing=\"1\" cellpadding=\"1\"><tr>";
44. $intRows = 0;
45. while($objResult2 = mysql_fetch_array($objQuery2))
46. {
47. echo "<td>";
48. $intRows++;
49. ?>
50. <center>
51. <a href="myfile/<?php echo $objResult2["GalleryShot"];?>" rel="prettyPhoto[gallery]" title="<?php echo $objResult2["GalleryName"];?>"><img src="myfile/<?php echo $objResult2["GalleryShot"];?>" width="100" height="100"></a><br>
52. <?php echo $objResult2["GalleryName"];?>
53. <br>
54. </center>
55. <?php
56. echo"</td>";
57. if(($intRows)%4==0)
58. {
59. echo"</tr>";
60. }
61. }
62. echo"</tr></table>";
63.
64. mysql_close($objConnect);
65. ?>
66.</body>
67.</html>
