1. Database (buka
localhost/phpmyadmin pada browser)
Buat folder baru
pada xampp/htdocs (buka localhost/nama_folder pada htdocs dengan browser)
2. a. Hal awal
b. Pilih Input Data Mahasiswa
c. Saat
Disimpan Dan otomatis masuk Ke dalam data
d.Data Otomatis tersimpan pada database
e. Saat di klik edit akan keluar Tampilan Sbb:
f. Saat di edit Data Mahasiswa
g.
Saat Klik Delete Data Akan Terhapus Dan Saaat Di Klik Kembali, Akan Kembali Ke Halaman Awal
Source
code :
Config.php
<?php
mysql_connect("localhost","root","");
mysql_select_db("db_praktikum");
?>
Index.php
<html>
<head><title>Tugas
Praktikum DASKOM 4</title></head>
<body>
<table align="center"
width="100%">
<tr><td
align="center">SELAMAT DATANG</td></tr>
<tr><td
align="center"><hr><a href="add_mhs.php">1.
INPUT DATA MAHASISWA</a><br><a
href="view_mhs.php">2. LIHAT DATA
MAHASISWA</a><hr></td></tr>
</table>
</body>
</html>
Add_mhs.php
<html>
<head><title>Tugas
Praktikum DASKOM 4</title></head>
<body>
<form
method="post" action="send_mhs.php">
<table
align="center" width="25%">
<tr><td
colspan="3" align="center"><hr>INPUTKAN DATA
ANDA<hr></td></tr>
<tr>
<td>NBI</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="nbi" value=""/></td>
</tr>
<tr>
<td>NAMA</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="nama" value=""/></td>
</tr>
<tr>
<td>KELAS</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="kelas" value=""/></td>
</tr>
<tr>
<td>ALAMAT</td>
<td
align="center"></td>
<td
align="center"><input type="text" name="alamat"
value=""/></td>
</tr>
<tr><td
colspan="3" align="left"><br><input
type="submit" value="simpan"/> <input
type="reset" value="reset"/><input
type="button" value="kembali"
onclick="location.href='index.php'"/> </td></tr>
</table>
</form>
</body>
</html>
send_mhs.php
<?php
include
"config.php";
mysql_query("insert into
tb_mhs (nbi,nama,kelas,alamat)
value('$_POST[nbi]','$_POST[nama]','$_POST[kelas]','$_POST[alamat]')");
echo
"<script>alert('Data Berhasil Ditambahkan !')</script>";
echo "<meta
http-equiv='refresh' content='0;url=view_mhs.php' />";
?>
View_mhs.php
<?php
include "config.php"; $nbi =
$_GET[nbi]; ?>
<html>
<head><title>Tugas
Praktikum DASKOM 4</title></head>
<body>
<hr><center>DATA
NAMA PRAKTIKUM</center><hr>
<table
border="1" align="center" width="50%">
<tr>
<td
align="center">NBI</td>
<td
align="center">NAMA</td>
<td
align="center">KELAS</td>
<td
align="center">ALAMAT</td>
<td
align="center">ACTION</td>
</tr>
<?php
$sql_mhs
= mysql_query("select * from tb_mhs");
$jum_mhs
= mysql_num_rows($sql_mhs);
if($jum_mhs
<>0){
while($row_mhs
= mysql_fetch_array($sql_mhs)){
?>
<tr>
<td><?php
echo $row_mhs[nbi];?></td>
<td><?php
echo $row_mhs[nama];?></td>
<td><?php
echo $row_mhs[kelas];?></td>
<td><?php
echo $row_mhs[alamat];?></td>
<td
align="center"><a href="edit_mhs.php?nbi=<?php echo
$row_mhs[nbi]; ?>">edit</a> / <a
href="del_mhs.php?nbi=<?php echo $row_mhs[nbi]; ?>"
onclick="return confirm('apakah anda yakin ?');"
>hapus</a></td>
</tr>
<?php
}
}
else{
echo"<tr><td
colspan='5' align='center'>Data Masih Kosong</td></tr>";
}
?>
</table>
<center><a
href="add_mhs.php">Tambah Data</a> <a href="index.php">Kembali</a></center>
</body>
</html>
View_mhs.php
<?php
include
"config.php";
$nbi =
$_GET[nbi];
?>
<html>
<head><title>Tugas
Praktikum DASKOM 4</title></head>
<body>
<hr><center>DATA
NAMA PRAKTIKUM</center><hr>
<table
border="1" align="center" width="50%">
<tr>
<td
align="center">NBI</td>
<td
align="center">NAMA</td>
<td
align="center">KELAS</td>
<td
align="center">ALAMAT</td>
<td
align="center">ACTION</td>
</tr>
<?php
$sql_mhs
= mysql_query("select * from tb_mhs");
$jum_mhs
= mysql_num_rows($sql_mhs);
if($jum_mhs
<>0){
while($row_mhs
= mysql_fetch_array($sql_mhs)){
?>
<tr>
<td><?php
echo $row_mhs[nbi];?></td>
<td><?php
echo $row_mhs[nama];?></td>
<td><?php
echo $row_mhs[kelas];?></td>
<td><?php
echo $row_mhs[alamat];?></td>
<td
align="center"><a href="edit_mhs.php?nbi=<?php echo
$row_mhs[nbi]; ?>">edit</a> / <a
href="del_mhs.php?nbi=<?php echo $row_mhs[nbi]; ?>"
onclick="return confirm('apakah anda yakin ?');"
>hapus</a></td>
</tr>
<?php
}
}
else{
echo"<tr><td
colspan='5' align='center'>Data Masih Kosong</td></tr>";
}
?>
</table>
<center><a
href="add_mhs.php">Tambah Data</a> <a
href="index.php">Kembali</a></center>
</body>
</html>
Del_mhs.php
<?php
include "config.php";
mysql_query("delete from
tb_mhs where nbi='$_GET[nbi]'");
header("location:$_SERVER[HTTP_REFERER]");
?>
Edit_mhs.php
<?php
include"config.php";
$sql_mhs=mysql_query("select
* from tb_mhs where nbi=$_GET[nbi]");
$row_mhs=mysql_fetch_array($sql_mhs);
?>
<html>
<head><title>Tugas
Praktikum DASKOM 4</title></head>
<body>
<form
method="post" action="update_mhs.php">
<table
align="center" width="25%">
<tr><td
colspan="3" align="center"><hr>PERBARUI DATA
ANDA<hr></td></tr>
<tr>
<td>NBI</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="nbi" value="<?php echo $row_mhs[nbi]; ?>"
readonly/></td>
</tr>
<tr>
<td>NAMA</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="nama" value="<?php echo $row_mhs[nama];
?>"/></td>
</tr>
<tr>
<td>KELAS</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="kelas" value="<?php echo $row_mhs[kelas];
?>"/></td>
</tr>
<tr>
<td>ALAMAT</td>
<td
align="center"></td>
<td
align="center"><input type="text"
name="alamat" value="<?php echo $row_mhs[alamat];
?>"/></td>
</tr>
<tr><td
colspan="3" align="left"><br><input
type="submit" value="perbarui"/> <input
type="reset" value="reset"/> <input
type="button" value="kembali"
onclick="location.href='index.php'"/></td></tr>
</table>
</form>
</body>
</html>
Update_mhs.php
<?php
include
"config.php";
mysql_query("update tb_mhs
set nama = '$_POST[nama]', kelas = '$_POST[kelas]', alamat = '$_POST[alamat]'
where nbi = '$_POST[nbi]'");
echo
"<script>alert('Data Berhasil Diperbarui !')</script>";
echo "<meta
http-equiv='refresh' content='0;url=view_mhs.php' />";
?>
0 komentar:
Posting Komentar