Selasa, 29 Oktober 2013

PHP Indonesia - Facebook: dah googling kmana mana masi belm ketemu nih... mi...

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/ 
Mobile Game Development Course

Learn how to create awesome HTML5 games that run on iPhone, iPad, Android and Desktop! Sign up today for this $99 online course.
From our sponsors
dah googling kmana mana masi belm ketemu nih... mi...
Oct 29th 2013, 16:24, by Herman Istyanto

Herman Istyanto 4:24pm Oct 29
dah googling kmana mana masi belm ketemu nih...
minta tlog para master master nie di grup ini...

saya mau menampilkan data dari database ke tabel secara horisontal
gimana ya contohnya kyk gini master.

header mata ajarnya itu diambil juga dr database.
jadi ada tiga tabel tbl siswa,nilai dan ma

tbl siswa filed nya nis dan nama
tbl nila filed nya idma dan nilai
tbl ma filed nya idma dan namama

terima kasih atas batuannya

Ade Xidsoft 4:28pm Oct 29
jgn lupa buat fungsi <th>no</th><th>nama</th> selebum memanggil GET table database. saya ada contohnya cuma besok pagi, tkp saya mlm ni mati listrik.

Herman Istyanto 4:30pm Oct 29
oke. terimakasih bantuannya

Al Ghurahy 4:51pm Oct 29
lhah tau nya nilai ipa dari si siswa dg no induk 34 gmn tuh? di tbl nilai kan gada no induk siswa?

Herman Istyanto 4:53pm Oct 29
iya maaf kuran filed nis di tabel nilai

Herman Istyanto 5:00pm Oct 29
tabelnya ini

Al Ghurahy 5:44pm Oct 29
o ya gampang itu, cara newvie nya: bisa pake nested loop query 3x, sambil iterasi buat tabel mendatar.

kl gak gt pake left join di query nya..

select siswa.nama, ma.makul, nilai.nilai from siswa
left join nilai on siswa.nis = nilai.nis
left join ma on ma.id_ma = nilai.id_ma
where 1

tinggal olah datanya

Herman Istyanto 5:46pm Oct 29
aku pakek php versi 5.3.1
agan Al Ghurahy sekalian contoh scriptnya dunk
maaf new bie bget nie

Herman Istyanto 5:50pm Oct 29
oke agan ibnu di coba dulu scriptnya maksih sblmnya

Ibnu Imam 5:50pm Oct 29
<table>
<tr>
<th>No</th>
<th>Nama</th>
<?php
$qma = mysql_query("SELECT makul FROM ma ORDER BY makul ASC");
while($rma = mysql_fetch_array($qma)) {
echo '<th>'.$rma['makul'].'</th>';
}
?>
</tr>
<?php
$no = 0;
$qsiswa = mysql_query("SELECT * FROM siswa ORDER BY nama ASC");
while($rsiswa = mysql_fetch_array($qsiswa)) {
$no++;
?>
<tr>
<td><?php echo $no;?></td>
<td><?php echo $rsiswa['nama'];?></td>
<?php
$qma2 = mysql_query("SELECT id_ma FROM ma ORDER BY makul ASC");
while($rma2 = mysql_fetch_array($qma2))
{
$qnilai = mysql_query("SELECT nilai FROM nilai
WHERE
nis = '".$rsiswa['nis']."' AND
id_ma = '".$rma2['id_ma']."'
");
$rnilai = mysql_fetch_array($qnilai);

echo '<td>'.$rnilai['nilai'].'</td>';
}
?>
</tr>
<?php
}
?>
</table>

Shine Sang Pahlawan 5:55pm Oct 29
design dulu yg rapih pakai CSS nanti tinggal masukin .$data['namadata'].

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