Senin, 28 Oktober 2013

PHP Indonesia - Facebook: kk kok $query2 nya gk kebaca yah , tolong di perba...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Want free Kindle ebooks?

Sign up to receive the best freebie Kindle ebook deals in your email every day.
From our sponsors
kk kok $query2 nya gk kebaca yah , tolong di perba...
Oct 25th 2013, 08:03, by Taufik Ismail

Taufik Ismail 8:03am Oct 25
kk kok $query2 nya gk kebaca yah , tolong di perbaiki dong ;

$query = "select * from album ";
$sql = mysql_query($query) or die(mysql_error());
while($query_row = mysql_fetch_assoc($sql))
{
$b = $query_row['foto'];
$c = $query_row['nama_album'];
$query2 = "SELECT foto from album WHERE nama_album = $c ";
echo"<p><a class='group1' href='../$query2' title='$c'>$c</a></p>";

Gandara Fajar Umbara 8:07am Oct 25
SELECT `foto` FROM `album` WHERE nama_album='$c'

Taufik Ismail 8:15am Oct 25
ok thx gan, work

Abu Unaisah Setianto 8:20am Oct 25
mysql_query untuk $query2 mungkin

Taufik Ismail 8:23am Oct 25
Gandara Fajar Umbara bang belom work , tadi lupa di ganti ama sebelum nya . malah link nya jadi select %60% foto dst..

Taufik Ismail 8:31am Oct 25
Abu Unaisah Setianto kalo mysql_query gk bisa , link nya jadi bllank

Gandara Fajar Umbara 8:33am Oct 25
ouh kurang jelas sih

Bobby Saputra 8:34am Oct 25
Mysql_connect nya gmn, am mysql_select_db nya

Taufik Ismail 8:36am Oct 25
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

Heru Rahmat Akhnuari 8:36am Oct 25
ini querynya mau dimasukin ke url mas ? wah gawat tuh

Bobby Saputra 8:36am Oct 25
Query sql nya jadiin satu j

Taufik Ismail 8:36am Oct 25
$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");

Taufik Ismail 8:49am Oct 25
Heru Rahmat Akhnuari iya

Taufik Ismail 8:50am Oct 25
Bobby Saputra cara nya ?

Heru Rahmat Akhnuari 8:50am Oct 25
link / href nya itu gunanya apa nanti mas?

Taufik Ismail 8:55am Oct 25
jadi gini saya mau buat image slider , saya ingin memunculkan foto nya sesuai dengan album nya ,

Heru Rahmat Akhnuari 8:58am Oct 25
$query = "select * from album ";
$sql = mysql_query($query) or die(mysql_error());
while($query_row = mysql_fetch_assoc($sql))
{
$a=$query_row['idfoto'];
$b = $query_row['foto'];
$c = $query_row['nama_album'];
echo"<p><a class='group1' href='tampil.php?id=$a' title=''>$c</a></p>";
}

Taufik Ismail 9:03am Oct 25
kalo href='' kosong gk bisa .

Heru Rahmat Akhnuari 9:04am Oct 25
udah di fix lagi tuh code nya

Taufik Ismail 9:26am Oct 25
aduh saya bingung tampil.php nya di ganti apa? coz href nya kan langsung link ke gambar ?

Heru Rahmat Akhnuari 9:33am Oct 25
tapi katanya tadi mau nampilin images slider kan ?
ada 2 file php, listalbum.php dan tampil.php
Nah, pada listalbum.php ditampilkan nama semua album. kode nya yg tadi :
$query = "select * from album ";
$sql = mysql_query($query) or die(mysql_error());
while($query_row = mysql_fetch_assoc($sql))
{
$a=$query_row['idfoto'];
$b = $query_row['foto'];
$c = $query_row['nama_album'];
echo"<p><a class='group1' href='tampil.php?id=$a' title=''>$c</a></p>";
}

Lalu saat dipilih album mana yg dipilih, setiap klik list album ada parameter url/segment url berupa id yang nilainya adalah $a. Dipanggil pada halaman tampil.php dengan kode :
if(isset($_GET['id']))
{
$query=mysql_query("Select foto from album where kode_album='".$_GET['id']."'");
while($datafoto=mysql_fetch_array($query))
{
echo "<img src='".$datafoto['foto']."'>";
}
}

Taufik Ismail 2:27am Oct 26
Heru Rahmat Akhnuari bang maaf baru online lagi .
jadi di table saya , cuman ada id nama_album foto .
jadi mau buat link seperti ini form_album/gallery/image.jpg .

inti permasalahan nya sih gimana cara excute queri ini $query2 = "SELECT foto from album WHERE nama_album = $c ";

saya coba di database work kok query nya .

Heru Rahmat Akhnuari 2:28am Oct 26
query string tanpa eksekusi query seperti mysql_query sama aja string, cek deh

Taufik Ismail 2:52am Oct 26
maksud nya gini bang $query2 = mysql_query("SELECT foto from album WHERE nama_album = $c ");

Taufik Ismail 2:52am Oct 26
tetep gk bisa bang

Heru Rahmat Akhnuari 5:19am Oct 26
coba tampilin source nya di pastebin

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar