Advertisement
eyuprog

Untitled

Oct 26th, 2013
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.85 KB | None | 0 0
  1.                     <h1>Album</h1>
  2.                     <?php
  3.     ob_start();
  4.     $host="localhost";
  5.     $username="root";  
  6.     $password="";  
  7.     $db_name="watax";  
  8.     $tbl_name="album";  
  9.      
  10.     mysql_connect("$host", "$username", "$password")or die("cannot connect");
  11.     mysql_select_db("$db_name")or die("cannot select DB");
  12.      
  13.     $query = "select * from album ";
  14.     //$query2 = "SELECT foto from album WHERE nama_album = persahabatan ";
  15.     $sql = mysql_query($query) or die(mysql_error());
  16.     while($query_row = mysql_fetch_assoc($sql))
  17.     {
  18.     $a = $query_row['id'];
  19.     $b = $query_row['foto'];
  20.     $c = $query_row['nama_album'];
  21.        
  22.      
  23. //di sini kita diperlukan akses untuk menampilkan, contohnya tampilslideshow.php. Liat kode tampilslideshow.php di bawah
  24.     echo"<p><a class='group1' href='tampilslideshow.php?id=$a' title='$c'>$c</a></p>";    
  25.     }
  26.            
  27.                     //<!-- This contains the hidden content for inline calls -->
  28.            
  29.      
  30.             ?>
  31.            
  32. //kode tampilslideshow.php
  33. <?php
  34. //memanggil id data album
  35. if(isset($_GET['id']))
  36. {
  37. //ambil data $_GET['id']
  38. $kodealbum=$_GET['id'];
  39. //Eksekusi query lagi
  40.   $host="localhost";
  41.     $username="root";  
  42.     $password="";  
  43.     $db_name="watax";  
  44.     $tbl_name="album";  
  45.      
  46.     mysql_connect("$host", "$username", "$password")or die("cannot connect");
  47.     mysql_select_db("$db_name")or die("cannot select DB");
  48.      
  49.     $query = "select * from album Where id='$kodealbum'";
  50.    $sql = mysql_query($query) or die(mysql_error());
  51.     while($query_row = mysql_fetch_array($sql))
  52.     {
  53. //nah disini gambarnya untuk slideshow
  54.     $a = $query_row['id'];
  55.     $b = $query_row['foto'];
  56.     $c = $query_row['nama_album'];
  57. //menampilkan gambar, di sini dibuat class slideshownya
  58.     echo "<img src='$b'>";
  59.     }
  60.  
  61. }
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement