Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <h1>Album</h1>
- <?php
- ob_start();
- $host="localhost";
- $username="root";
- $password="";
- $db_name="watax";
- $tbl_name="album";
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- $query = "select * from album ";
- //$query2 = "SELECT foto from album WHERE nama_album = persahabatan ";
- $sql = mysql_query($query) or die(mysql_error());
- while($query_row = mysql_fetch_assoc($sql))
- {
- $a = $query_row['id'];
- $b = $query_row['foto'];
- $c = $query_row['nama_album'];
- //di sini kita diperlukan akses untuk menampilkan, contohnya tampilslideshow.php. Liat kode tampilslideshow.php di bawah
- echo"<p><a class='group1' href='tampilslideshow.php?id=$a' title='$c'>$c</a></p>";
- }
- //<!-- This contains the hidden content for inline calls -->
- ?>
- //kode tampilslideshow.php
- <?php
- //memanggil id data album
- if(isset($_GET['id']))
- {
- //ambil data $_GET['id']
- $kodealbum=$_GET['id'];
- //Eksekusi query lagi
- $host="localhost";
- $username="root";
- $password="";
- $db_name="watax";
- $tbl_name="album";
- mysql_connect("$host", "$username", "$password")or die("cannot connect");
- mysql_select_db("$db_name")or die("cannot select DB");
- $query = "select * from album Where id='$kodealbum'";
- $sql = mysql_query($query) or die(mysql_error());
- while($query_row = mysql_fetch_array($sql))
- {
- //nah disini gambarnya untuk slideshow
- $a = $query_row['id'];
- $b = $query_row['foto'];
- $c = $query_row['nama_album'];
- //menampilkan gambar, di sini dibuat class slideshownya
- echo "<img src='$b'>";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement