1. Formlhs.html
2. Tampillhs.php
3. Tampildosen.php
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| <html><body><h3>Form Lembar Hasil Studi</h3><table border=1><form method=post action="tampillhs.php"><tr><td>No BP </td><td>=<input type=text name="nobp"</td></tr><tr><td>Semester </td><td>=<input type=text name="semester"</td></tr><tr><td>Tahun </td><td>=<input type=text name="tahun"</td></tr><tr><td><input type =submit value="OK"><input type=reset value ="Cancel"></td></tr></form></body></html> |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
| <?phpinclude"konek.php";$nobp= $_POST['nobp'];$semester= $_POST['semester'];$tahun = $_POST['tahun'];$krssql = mysql_query("select * from krs where nobp='$nobp' AND semester='$semester' AND tahun='$tahun'");$hasil=mysql_num_rows($krssql);if($hasil > 0 ){$mhssql = mysql_query("select * from mhs where nobp='$nobp'");$hasilmhs=mysql_fetch_row($mhssql);if ($hasilmhs){echo"<table border=1>";echo"<tr><td colspan=7>NOBP : $nobp<br>";echo"Nama : $hasilmhs[1]<br>";echo"Semester : $semester<br>";echo"Tahun : $tahun<br></td></tr>";}}?><tr> <th>No.</th> <th>Kode</th> <th>Nama Matakuliah</th> <th>SKS</th> <th>Nilai</th> <th>Mutu</th> <th>Bobot Mutu</th></tr><?php$sqlkrs = mysql_query("SELECT * FROM krs, mtk WHERE nobp='$nobp' AND krs.kodemk = mtk.kode AND krs.semester='$semester' AND krs.tahun='$tahun'");$jumsks = 0;$i = 1;$totbot=0;while($datakrs = mysql_fetch_array($sqlkrs)){ echo "<tr><td>$i</td>"; echo "<td>$datakrs[kode]</td>"; echo "<td>$datakrs[nama]</td>"; echo "<td>$datakrs[sks]</td>"; echo "<td>$datakrs[Nilai]</td>"; if ($datakrs['Nilai']=="A") $mutu=4; else if ($datakrs['Nilai']=="B") $mutu=3; else if ($datakrs['Nilai']=="C") $mutu=2; else if ($datakrs['Nilai']=="D") $mutu=1; else $mutu=0; echo "<td>$mutu</td>"; $bobotmutu = $datakrs['sks'] * $mutu; echo "<td>$bobotmutu</td>"; $jumsks = $jumsks + $datakrs['sks']; $totbot = $totbot + $bobotmutu; $i++;}echo "<tr><td colspan=6>JUMLAH SKS</td><td>$jumsks</td></tr>";echo "<tr><td colspan=6>JUMLAH Bobot</td><td>$totbot</td></tr>";$ipk = $totbot / $jumsks;echo "<tr><td colspan=6>IPK</td><td>$ipk</td></tr>";?></table> |
3. Tampildosen.php
1
2
3
4
5
6
| <?phpinclude "konek.php";$tampil="select * from dosen";$hasil=mysql_query($tampil);echo"<table border=1>";echo"Daftar Dosen";echo"<tr><th>No. </th> <th>Kode Dosen </th> <th>Nama Dosen </th> <th>Alamat Dosen </th></tr>";$nomor=1;while($data=mysql_fetch_row($hasil)){echo "<tr><td>$nomor</td>";echo "<td>$data[0]</td>";echo "<td>$data[1]</td>";echo "<td>$data[2]</td>";$nomor++;}echo"</table>";?> Sumber: |
