Jumat, 31 Mei 2013

Pengimputan Nilai Mahasiswa Menggunakan PHP

 Udah pada pernah gak sobat belajar PHP?. Kita belajar bareng ia sobat, tanpa panjang lebar langsung saja ia. :)
<html>
<head>
<title>Input Nilai</title>
</head>
<body bgcolor=blue text=red>
<form action=nAkhir.php>
<center>
<table border=5 haigth=385 width=385>
<tr bgcolor=pink>
<td colspan=2><b><font size=4 color="green"><blink><marquee>NILAI MAHASISWA SI-M1106 STMIK BUDIDARMA</b></font></blink></marquee></td>
</TR>
</center>

<TR bgcolor=gray>
<TD><b>Npm</b></td>
<td><input type=text name=Npm size=20></td>
</tr>

<?

if ($Npm=="011120")
{
    $Nama='Sornop';
    $N_mid='75';
    $N_Uas='35';
   
}else if ($Npm=="201111")
{
    $Nama='Patuteng';
    $N_mid='45';
    $N_Uas='55';
}else if ($Npm=="01221")
{
    $Nama='Onco';
    $N_mid='57';
    $N_Uas='90';
}else if ($Npm=="11122")
{
    $Nama='Lamhot';
    $N_mid='90';
    $N_Uas='80';
}else if ($Npm=="121111")
{
    $Nama='Terang';
    $N_mid='85';
    $N_Uas='65';   
}

?>
<TR bgcolor=gray>
<TD><b>Nama</b></td>
<td><input type=text=Nama value='<?echo"$Nama"?>'size=20></td>
</tr>
<TR bgcolor=gray>
<TD><b>Nilai Mid</b></td>
<td><input type=text=name Value='<?echo"$N_mid"?>' size=20></td>
</tr>

<TR bgcolor=gray>
<TD><b>Nilai Uas</b></td>
<td><input type=text=name value='<?echo"$N_Uas"?>' size=20></td>
</tr>
<?
   $N_akhir = $N_mid*40/100 + $N_Uas*60/100;
?>

<TR bgcolor=gray>
<TD><b>Nilai Akhir</b></td>
<td><input type=text=name value='<?echo"$N_akhir"?>' size=20></td>
</tr>


<?

if ($N_akhir>=80){
    $nilai_huruf="A";
}else if ($N_akhir>=70){
    $nilai_huruf="B";
}else if ($N_akhir>=60){
    $nilai_huruf="C";
}else if ($N_akhir>=50){
    $nilai_huruf="D";
}else if ($N_akhir>=0){
    $nilai_huruf="E";
}

?>

<TR bgcolor=gray>
<TD><b>Nilai Huruf</b></td>
<td><input type=text=nilai_huruf value='<?echo"$nilai_huruf"?>'size=20></td>
</tr>

<TR bgcolor=orange>
<TD><b><p align=center><input type=submit name=xproses value=Proses></b></p></td>
<td><b><p align=center><input type=reset name=xbatal value=Batal></b></p></td>
</tr>
<tr bgcolor=green>
<td colspan=2><blink><font size=4 color=yellow><I><p align=center><b>Created By : Rasmi Aritonang <br>NPM : 1111564<b></p></I><font></br></td>
</tr>
</table>
</body>
</html>
Diposting oleh di

Form Lembar Hasil Studi (LHS) dengan Menggunakan PHP

1. Formlhs.html
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>
2. Tampillhs.php
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
<?php
include"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
<?php
include "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:
http://ahmadrizal.wordpress.com/category/pemrograman-web/
 
 
 
 
 
 
 
 
 
 
 
Diposting oleh di
Langganan: Postingan (Atom)