MODUL DASAR PEMROGRAMAN WEB - allwaysedu fileMODUL 1 PEMROGRAMAN WEB PHP Email : [email protected] Site : http:// code.web.id

MODUL 1

PEMROGRAMAN WEB

PHP

Email : [email protected]

Site : http://www.freecode.web.id

M. Farid Rifai, S.Kom Page 2

Latihan1.php

<?

//Menampilkan teks pada browser

echo "Belajar Pemrograman WEB"."<br>";

echo "Dengan menggunakan PHP";

?>

Latihan2.php

<?

//Menggunakan varible

$nama="Fery ardiansyah";

$alamat="Bandung";

$usia=27;

//Memanggil variable yang sudah di inisialisasi

echo "Nama saya = ".$nama."<br>";

echo "Alamat saya = ".$alamat."<br>";

echo "Usia saya = ".$usia;

?>

Latihan3.php

<?

//Pemberian nilai pada variable

$bilangan_1=100;

$bilangan_2=50;

//Menggunakan operator

$tambah=$bilangan_1+$bilangan_2;

$kurang=$bilangan_1-$bilangan_2;

$kali=$bilangan_1*$bilangan_2;

$bagi=$bilangan_1/$bilangan_2;

//Pemanggilan variable & menampilkan pada browser

echo"Bilangan 1 = ".$bilangan_1."<br>";


echo"Hasil Penjumlahan = ".$tambah."<br>";

echo"Hasil Pengurangan = ".$kurang."<br>";

echo"Hasil Perkalian = ".$kali."<br>";

echo"Hasil Pembagian = ".$bagi."<br>";

?>


LATIHAN 4 & Latihan 5

Latihan4.php

<html>

<head>

<title>Latihan 4</title>

</head>

<body>

<form name="form1" method="post" action="latihan5.php">

<h3>FORM INPUT BILANGAN </h3>

<table width="100%" border="0">

<tr>

<td width="9%">Bilangan 1 </td>

<td width="91%"><input name="bil_1" type="text" id="bil_1"></td>

</tr>

<tr>

<td>Bilangan 2 </td>

<td><input name="bil_2" type="text" id="bil_2"></td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Hitung"> </td>

</tr>

</table>

</form>

</body>

</html>

Latihan5.php

<?

//Pemberian nilai pada variable dari Form dengan method post

$bilangan_1=$_POST['bil_1'];

$bilangan_2=$_POST['bil_2'];

//Menggunakan operator

$tambah=$bilangan_1+$bilangan_2;

$kurang=$bilangan_1-$bilangan_2;

$kali=$bilangan_1*$bilangan_2;

$bagi=$bilangan_1/$bilangan_2;

//Pemanggilan variable & menampilkan pada browser




echo"Hasil Penjumlahan = ".$tambah."<br>";

echo"Hasil Pengurangan = ".$kurang."<br>";

echo"Hasil Perkalian = ".$kali."<br>";

echo"Hasil Pembagian = ".$bagi."<br>";

?>

Latihan 6 & Latihan 7 Latihan6.php

<html>

<head>

<title>Registrasi Member</title>

</head>

<body>


<h3>FORM REGISTRASI MEMBER </h3>


<tr>

<td width="12%">Email</td>

<td width="88%"><input name="email" type="text" id="email"></td>

</tr>

<tr>

<td>Nama</td>

<td><input name="nama" type="text" id="nama"></td>

</tr>

<tr>

<td><p>Pekerjaan</p>

</td>

<td><select name="pekerjaan" id="pekerjaan">

<option value="Karyawan">Karyawan</option>

<option value="Wiraswasta">Wiraswasta</option>

<option value="Siswa/Mahasiswa">Siswa/Mahasiswa</option>

</select></td>

</tr>

<tr>

<td>Jenis Kelamin </td>

<td><input name="jenkel" type="radio" value="Laki-laki">

Laki-Laki

<input name="jenkel" type="radio" value="Perempuan">

Perempuan</td>

</tr>

<tr>

<td>Alamat</td>


<td><textarea name="alamat" id="alamat"></textarea></td>

</tr>

<tr>

<td>Hobby</td>

<td><input name="h_reading" type="checkbox" id="h_reading" value="Reading">

Reading<br>

<input name="h_singing" type="checkbox" id="h_singing" value="Singing">

Singing<br>

<input name="h_sport" type="checkbox" id="h_sport" value="Sport">

Sport </td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Kirim">

<input type="reset" name="Reset" value="Reset"></td>

</tr>

</table>

</form>

</body>

</html>

Latihan7.php

<html>

<head>

<title>Tampil Registrasi</title>

</head>

<body>


<tr>

<td colspan="2"><h3>DATA MEMBER </h3></td>

</tr>

<tr>

<td width="12%"> </td>


</tr>

<tr>

<td>Email</td>

<td><? echo $_POST['email']; ?></td>

</tr>

<tr>

<td>Nama</td>

<td><? echo $_POST['nama']; ?></td>

</tr>


<tr>

<td>Pekerjaan</td>

<td><? echo $_POST['pekerjaan']; ?></td>

</tr>

<tr>

<td>Jenis Kelamin </td>

<td><? echo $_POST['jenkel']; ?></td>

</tr>

<tr>

<td>Alamat</td>

<td><? echo $_POST['alamat']; ?></td>

</tr>

<tr>

<td>Hobby</td>

<td><? echo $_POST['h_reading'].",".$_POST['h_singing'].",".$_POST['h_sport']; ?></td>

</tr>

</table>

</body>

</html>

Latihan 8 & Latihan 9

Latihan8.php

<html>

<head>

<title>Nilai Mahasiswa</title>

</head>

<body>


<h3>FORM NILAI MAHASISWA </h3>


<tr>

<td width="12%">NPM</td>

<td width="88%"><input name="npm" type="text" id="npm"></td>

</tr>

<tr>

<td>Nama</td>


</tr>

<tr>

<td><p>Jurusan</p></td>

<td><select name="jurusan" id="jurusan">


<option value="MIF">MIF</option>

<option value="TIK">TIK</option>

<option value="ARM">ARM</option>

<option value="MPRS">MPRS</option>

</select></td>

</tr>

<tr>

<td>Nilai UTS </td>

<td><input name="n_uts" type="text" id="n_uts"></td>

</tr>

<tr>

<td>Nilai UAS </td>

<td><input name="n_uas" type="text" id="n_uas"></td>

</tr>

<tr>

<td>Nilai TUGAS </td>

<td><input name="n_tugas" type="text" id="n_tugas"></td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Kirim">

<input type="reset" name="Reset" value="Reset"></td>

</tr>

</table>

<p> </p>

</form>

</body>

</html>

Latihan9.php

<html>

<head>


</head>

<body>


<tr>

<td colspan="2"><h3>NILAI MAHASISWA </h3></td>

</tr>

<tr>



</tr>

<tr>


<td>NPM</td>

<td><? echo $_POST['npm']; ?></td>

</tr>

<tr>

<td>Nama</td>

<td><? echo $_POST['nama']; ?></td>

</tr>

<tr>

<td>Jurusan</td>

<td><? echo $_POST['jurusan']; ?></td>

</tr>

<tr>

<td>Nilai UTS </td>

<td><? echo $_POST['n_uts']; ?></td>

</tr>

<tr>

<td>Nilai UAS </td>

<td><? echo $_POST['n_uas']; ?></td>

</tr>

<tr>

<td>Nilai Tugas</td>

<td><? echo $_POST['n_tugas']; ?></td>

</tr>

<tr>

<td>Total Nilai </td>

<td>

<?

$tn=(0.5 * $_POST['n_uas'])+(0.4 * $_POST['n_uts'])+(0.1 * $_POST['n_tugas']);

echo $tn;

?>

</td>

</tr>

<tr>

<td>Nilai Akhir </td>

<td>

<?

if($tn>=80){

$na="A";

$ket="Istimewa";

}elseif($tn>=70){

$na="B";

$ket="Baik";

}elseif($tn>=60){

$na="C";

$ket="Cukup";

}elseif($tn>=40){


$na="D";

$ket="Kurang";

}else{

$na="E";

$ket="Gagal";

}

echo $na;

?>

</td>

</tr>

<tr>

<td>Keterangan</td>

<td><? echo $ket; ?></td>

</tr>

</table>

</body>

</html>

APLIKASI DATABASE MYSQL

Nama Database: akademik

Tabel : mahasiswa

No Field Type Size Keterangan

1 npm Char 8 Primary key

2 nama Char 30

3 pwd Char 10

4 prodi Char 10

5 kelas Char 6

6 kota Char 20

7 telp Char 15

Tabel : matakuliah


1 kode_mk Char 10 Primary key

2 matakuliah Char 30

3 Sks Int

Tabel : nilai


1 Npm Char 8

2 Kode_mk Char 10

3 n_uts Int

4 n_uas Int


5 n_tugas Int

6 n_akhir Char 1

Nama File: db.php

<?

$host="localhost";

$user="root";

$pwd="";

$db="akademik";

//Koneksi ke Mysql

$conn=mysql_connect($host,$user,$pwd);

//Memilih database

mysql_select_db($db,$conn);

?>

Nama File: mahasiswa.php

<?

include"db.php";

$sql="SELECT * FROM Mahasiswa";

$result=mysql_query($sql);

?>

<html>

<head>

<title>Daftar Mahasiswa</title>

</head>

<body>

<h3>DAFTAR MAHASISWA</h3>

<table width="100%" border="1" cellspacing="0" cellpadding="0">

<tr bgcolor="#999999">

<td width="5%"><div align="center"><strong>NPM</strong></div></td>

<td width="17%"><div align="center"><strong>Nama</strong></div></td>

<td width="9%"><div align="center"><strong>Password</strong></div></td>

<td width="7%"><div align="center"><strong>Prodi</strong></div></td>

<td width="7%"><div align="center"><strong>Kelas</strong></div></td>

<td width="26%"><div align="center"><strong>Alamat</strong></div></td>

<td width="9%"><div align="center"><strong>Kota</strong></div></td>

<td width="10%"><div align="center"><strong>Telp</strong></div></td>

<td width="10%"><div align="center"><strong>Proses</strong></div></td>

</tr>

<?

while($row=mysql_fetch_array($result)){

?>

<tr>

<td><?=$row[npm]?></td>

<td><?=$row[nama]?></td>

<td><?=$row[pwd]?></td>


<td><?=$row[prodi]?></td>

<td><?=$row[kelas]?></td>

<td><?=$row[alamat]?></td>

<td><?=$row[kota]?></td>

<td><?=$row[telp]?></td>

<td><div align="center"><a href="edit_mhs.php?no=<?=$row[npm]?>">Edit</a> | <a

href="del_mhs.php?no=<?=$row[npm]?>">Hapus</a></div></td>

</tr>

<?

}

?>

</table>

<p><a href="insert_mhs.php">Tambah Record</a> </p>

<p> </p>

</body>

</html>

Nama File: insert_mhs.php

<?

//Memanggil file db.php

include"db.php";

//Pengecekan variable insert

if ((isset($_POST["insert"])) && ($_POST["insert"] == "form1")) {

//Memasukan ke table mahasiswa

$sql="INSERT INTO

mahasiswa(npm,nama,pwd,prodi,kelas,alamat,kota,telp)VALUES('".$_POST['npm']."','".$_POST['nama'].

"','".$_POST['password']."','".$_POST['prodi']."','".$_POST['kelas']."','".$_POST['alamat']."','".$_POST['kot

a']."','".$_POST['telp']."')";

//execute query


if($result){

//Menampilkan message box

echo"<script>alert('Data sudah tersimpan');</script>";

//menghubungkan(link) ke file mhs.php

echo"<script>location='mhs.php';</script>";

}

}

?>

<html>

<head>

<title>Input Mahasiswa</title>

</head>


<body>

<form name="form1" method="post" action="<? $_SERVER['PHP_SELF']; ?>">

<h3>FORM INPUT MAHASISWA</h3>

<table width="100%">

<tr>


<td width="88%"><input name="npm" type="text" id="npm"></td>

</tr>

<tr>

<td>Nama</td>


</tr>

<tr>

<td>Password</td>

<td><input name="password" type="text" id="password"></td>

</tr>

<tr>

<td>Program Studi </td>

<td><select name="prodi" id="prodi">





</select></td>

</tr>

<tr>

<td>Kelas</td>

<td><input name="kelas" type="text" id="kelas"></td>

</tr>

<tr>

<td>Alamat</td>

<td><textarea name="alamat" id="alamat"></textarea></td>

</tr>

<tr>

<td>Kota</td>

<td><input name="kota" type="text" id="kota"></td>

</tr>

<tr>

<td>Telp</td>

<td><input name="telp" type="text" id="telp"></td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Insert Record">

<input type="submit" name="Submit" value="Reset">


<input name="insert" type="hidden" id="insert" value="form1"></td>

</tr>

</table>

</form>

</body>

</html>

Nama File: del_mhs.php

<?


include"db.php";

//Query hapus record

$sql="DELETE FROM mahasiswa WHERE npm='".$_GET['no']."'";

//execute Query


if($result){

//Menampil message box

echo"<script>alert('Data sudah terhapus');</script>";

//Menghubungkan (link) ke file mhs.php

echo"<script>location='mhs.php';</script>"; }

?>

Nama File: edit_mhs.php

<?


include"db.php";

//Query menampilkan data mahasiswa berdasarkan NPM

$sql_mhs="SELECT * FROM mahasiswa WHERE npm='".$_GET['no']."'";

//Execute query

$rs_mhs=mysql_query($sql_mhs);

$row=mysql_fetch_array($rs_mhs);

//Pengecekan variable update

if ((isset($_POST["update"])) && ($_POST["update"] == "form1")) {

//Query update record mahasiswa

$sql_update="UPDATE mahasiswa SET

npm='".$_POST['npm']."',nama='".$_POST['nama']."',pwd='".$_POST['password']."',prodi='".$_POST['pr

odi']."',kelas='".$_POST['kelas']."',alamat='".$_POST['alamat']."',kota='".$_POST['kota']."',telp='".$_POST

['telp']."' WHERE npm='".$_POST['no']."'";

//Execute query

$rs_update=mysql_query($sql_update);

if($rs_update){


echo"<script>alert('Data sudah ter-update');</script>";



echo"<script>location='mhs.php';</script>";

}

}

?>

<html>

<head>

<title>Input Mahasiswa</title>

</head>

<body>


<h3>FORM EDIT MAHASISWA</h3>

<table width="100%">

<tr>


<td width="88%"><input name="npm" type="text" id="npm" value="<?=$row[npm]?>"></td>

</tr>

<tr>

<td>Nama</td>

<td><input name="nama" type="text" id="nama" value="<?=$row[nama]?>"></td>

</tr>

<tr>

<td>Password</td>

<td><input name="password" type="text" id="password" value="<?=$row[pwd]?>"></td>

</tr>

<tr>

<td>Program Studi </td>

<td><select name="prodi" id="prodi">

<option selected><?=$row[prodi]?></option>





</select></td>

</tr>

<tr>

<td>Kelas</td>

<td><input name="kelas" type="text" id="kelas" value="<?=$row[kelas]?>"></td>

</tr>

<tr>

<td>Alamat</td>

<td><textarea name="alamat" id="alamat"><?=$row[alamat]?></textarea></td>

</tr>

<tr>

<td>Kota</td>


<td><input name="kota" type="text" id="kota" value="<?=$row[kota]?>"></td>

</tr>

<tr>

<td>Telp</td>

<td><input name="telp" type="text" id="telp" value="<?=$row[telp]?>"></td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Update Record">

<input type="submit" name="Submit" value="Reset">

<input name="update" type="hidden" id="update" value="form1">

<input name="no" type="hidden" id="no" value="<?=$row[npm]?>"></td>

</tr>

</table>

</form>

</body>

</html>

TUGAS

1. Buatlah Halaman Daftar Matakuliah dari table matakuliah

2. Butalah Form menambah data Matakulaih

3. Buatlah Form meng-edit data Matakuliah

4. Buatlah script untuk menghapus data Matakuliah


Nama File: nilai.php

<?


include"db.php";

//Query Nilai

$sql="SELECT

mahasiswa.npm,mahasiswa.nama,matakuliah.kode_mk,matakuliah.matakuliah,nilai.n_uts,nilai.n_uas,nil

ai.n_tugas,nilai.n_akhir FROM mahasiswa,matakuliah,nilai WHERE mahasiswa.npm=nilai.npm AND

matakuliah.kode_mk=nilai.kode_mk";

//Execute query


?>

<html>

<head>


</head>

<body>

<h3>DAFTAR NILAI MAHASISWA

</h3>



<tr bgcolor="#999999">

<td width="8%"><div align="center"><strong>NPM</strong></div></td>

<td width="13%"><div align="center"><strong>Nama</strong></div></td>

<td width="11%"><div align="center"><strong>Kode Matakuliah </strong></div></td>

<td width="26%"><div align="center"><strong>Matakuliah</strong></div></td>

<td width="10%"><div align="center"><strong>Nilai UTS </strong></div></td>

<td width="8%"><div align="center"><strong>Nilai UAS </strong></div></td>

<td width="8%"><div align="center"><strong>Nilai Tugas </strong></div></td>

<td width="8%"><div align="center"><strong>Nilai akhir </strong></div></td>

<td width="8%"><div align="center"><strong>Proses</strong></div></td>

</tr>

<?

while($row=mysql_fetch_array($result)){

?>

<tr>

<td><?=$row[npm]?></td>

<td><?=$row[nama]?></td>

<td><?=$row[kode_mk]?></td>

<td><?=$row[matakuliah]?></td>

<td><?=$row[n_uts]?></td>

<td><?=$row[n_uas]?></td>

<td><?=$row[n_tugas]?></td>

<td><?=$row[n_akhir]?></td>

<td><div align="center">Edit | Hapus</div></td>

</tr>

<?

}

?>

</table>

<p><a href="insert_nilai.php">Tambah Record </a></p>

</body>

</html>

Nama File: insert_nilai.php

<?

include "db.php";

$sql_mhs="SELECT * FROM mahasiswa";


$sql_mk="SELECT * FROM matakuliah";

$rs_mk=mysql_query($sql_mk);

if ((isset($_POST["insert"])) && ($_POST["insert"] == "form1")) {


$rata=(0.5 * $_POST[uas]) + (0.4 * $_POST[uts]) + (0.1 * $_POST[tugas]);

if($rata >= 80)$na="A";

elseif($rata >= 70)$na="B";

elseif($rata >= 60)$na="C";

elseif($rata >= 40)$na="D";

else $na="D";

$sql="INSERT INTO nilai(npm,kode_mk,semester,n_uts,n_uas,n_tugas,n_akhir)

VALUES('".$_POST['npm']."','".$_POST['kode_mk']."','".$_POST['semester']."','".$_POST['uts']."','".$_POS

T['uas']."','".$_POST['tugas']."','$na')";

$result=mysql_query($sql) or die(mysql_error());

if($result){

echo"<script>alert('Data sudah tersimpan');</script>";

echo"<script>location='nilai.php';</script>";

}

}

?>

<html>

<head>


</head>

<body>




<tr>


<td width="91%"><select name="npm" id="npm">

<? while($row=mysql_fetch_array($rs_mhs)){ ?>

<option><?=$row[npm]?></option>

<? } ?>

</select></td>

</tr>

<tr>

<td>Kode MK </td>

<td><select name="kode_mk" id="kode_mk">

<? while($row=mysql_fetch_array($rs_mk)){ ?>

<option><?=$row[kode_mk]?></option>

<? } ?>

</select></td>

</tr>

<tr>

<td>Semester</td>


<td><select name="semester" id="semester">

<option value="1">1</option>






</select></td>

</tr>

<tr>

<td>Nilai UTS </td>

<td><input name="uts" type="text" id="uts" size="3"></td>

</tr>

<tr>

<td>Nilai UAS </td>

<td><input name="uas" type="text" id="uas" size="3"></td>

</tr>

<tr>

<td>Nilai Tugas </td>

<td><input name="tugas" type="text" id="tugas" size="3"></td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Insert Record">

<input type="reset" name="Reset" value="Reset">

<input name="insert" type="hidden" id="insert" value="form1"></td>

</tr>

</table>

</form>

</body>

</html>

Nama File: del_nilai.php

<?


include"db.php";

//Query hapus record

$sql="DELETE FROM nilai WHERE npm='".$_GET['no']."' AND kode_mk='".$_GET['kd']."'";

//execute Query


if($result){

//Menampil message box

echo"<script>alert('Data sudah terhapus');</script>";



}


?>

Nama File: edit_nilai.php

<?

//Memanggil db.php

include "db.php";

//Query Mhs

$sql_mhs="SELECT * FROM mahasiswa";


//Query MK

$sql_mk="SELECT * FROM matakuliah";

$rs_mk=mysql_query($sql_mk);

//Query menampilkan data mahasiswa berdasarkan NPM

$sql_nilai="SELECT * FROM nilai WHERE npm='".$_GET['no']."' AND kode_mk='".$_GET['kd']."'";

//Execute query

$rs_nilai=mysql_query($sql_nilai);

$row_nilai=mysql_fetch_array($rs_nilai);

//Pengecekan variable update

if ((isset($_POST["update"])) && ($_POST["update"] == "form1")) {

//Menghitung Rata-rata

$rata=(0.5 * $_POST[uas]) + (0.4 * $_POST[uts]) + (0.1 * $_POST[tugas]);

//Menentukan Nilai Akhir

if($rata >= 80)$na="A";

elseif($rata >= 70)$na="B";

elseif($rata >= 60)$na="C";

elseif($rata >= 40)$na="D";

else $na="D";

//Query update record mahasiswa

$sql_update="UPDATE nilai SET

npm='".$_POST['npm']."',kode_mk='".$_POST['kode_mk']."',semester='".$_POST['semester']."',n_uts='".

$_POST['uts']."',n_uas='".$_POST['uas']."',n_tugas='".$_POST['tugas']."',n_akhir='$na' WHERE

npm='".$_POST['no']."' AND kode_mk='".$_POST['kd']."'";

//Execute query

$rs_update=mysql_query($sql_update)or die(mysql_error());

if($rs_update){


echo"<script>alert('Data sudah ter-update');</script>";


//Menghubungkan (link) ke file nilai.php


}

}

?>

<html>

<head>

<title>Untitled Document</title>

</head>

<body>




<tr>


<td width="91%"><select name="npm" id="npm">

<option selected><?=$row_nilai[npm]?></option>

<? while($row=mysql_fetch_array($rs_mhs)){ ?>

<option>

<?=$row[npm]?>

</option>

<? } ?>

</select></td>

</tr>

<tr>

<td>Kode MK </td>

<td><select name="kode_mk" id="kode_mk">

<option selected><?=$row_nilai[kode_mk]?></option>

<? while($row=mysql_fetch_array($rs_mk)){ ?>

<option>

<?=$row[kode_mk]?>

</option>

<? } ?>

</select></td>

</tr>

<tr>

<td>Semester</td>

<td><select name="semester" id="semester">

<option selected><?=$row_nilai[semester]?></option>








</select></td>

</tr>

<tr>

<td>Nilai UTS </td>

<td><input name="uts" type="text" id="uts" size="3" value="<?=$row_nilai[n_uts]?>"></td>

</tr>

<tr>

<td>Nilai UAS </td>

<td><input name="uas" type="text" id="uas" size="3" value="<?=$row_nilai[n_uas]?>"></td>

</tr>

<tr>

<td>Nilai Tugas </td>

<td><input name="tugas" type="text" id="tugas" size="3" value="<?=$row_nilai[n_tugas]?>"></td>

</tr>

<tr>

<td> </td>

<td><input type="submit" name="Submit" value="Update Record">

<input type="reset" name="Reset" value="Reset">

<input name="update" type="hidden" id="update" value="form1">

<input name="no" type="hidden" id="no" value="<?=$row_nilai[npm]?>">

<input name="kd" type="hidden" id="kd" value="<?=$row_nilai[kode_mk]?>"></td>

</tr>

</table>

</form>

</body>

</html>

MODUL DASAR PEMROGRAMAN WEB - allwaysedu fileMODUL 1 PEMROGRAMAN WEB PHP Email : [email protected] Site : http:// code.web.id

Documents