Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //pake fw nasgor
- //query dan fetch ganti aja ama fungsi yg biasa km pake.. saran pake mysqli
- $sql="select nim id, nama from siswa";
- //lebih baik jgn pake nama siswa di table.. pake nim aja lalu bikin table siswa
- $dt=query($sql);
- $s="<table>";
- while($r=fetch($dt))
- {
- $s.="<tr>".td($r[id]).td($r[nama]);
- $sql="select pel_id from pelajaran order by name";
- $dtPelajaran=queryFetchAll($sql);
- $n=0;$sub=0;
- foreach($dtPelajaran as $r2)
- {
- $sql="select nilai from nilai where id_mp=$r[pel_id] and nim=$r[id]";
- $dtNilai=queryFetch($sql);
- $s.=td($dtNilai[nilai]);
- $n++;$sub+=$dtNilai[nilai];
- }
- $rat=$sub/$n;
- $s.=td($rat)."</tr>";
- echo $s;$s='';
- }
- echo "</table>";
- //ngak tahu apa ini benar ato salah.. perbaiki yang menurut km bisa.. lalu share codenya
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement