Isi tabel prodi diatas sesuka hati anda...
lalu kita buat tampilan tambah, edit, hapusnya, silahkan kopi paste koding dibawah ini :
<?php
mysql_connect("localhost","root","")or die("Tidak Konek Coy");
mysql_select_db("latihan_a1") or die("Database tidak ada");
?>
<html>
<head>
<title>Aplikasi Data Program Studi</title>
<style type="text/css">
body{background:#ebebeb;font-family:Tahoma;font-size:80%;}
#kotak{width:600px;padding:10px;background:#fff;color:#000;border:1px solid #ebebeb;margin:10px auto;}
h3{display:block;padding:5px 0;border-bottom:1px solid #000;border-top:1px solid #000;}
a{padding:2px 10px;background:#f3f3f3;text-decoration:none;}
</style>
</head>
<body>
<div id="kotak">
<!-- form -->
<?php
if($_GET['a']== 'edit'){
$d=mysql_fetch_array(mysql_query("SELECT * FROM prodi WHERE kd_prodi='$_GET[id]'"));
?>
<h3>Edit Program Studi</h3>
<form method="POST" action="<?php $_SERVER['PHP_SELF']; ?>?proses=edit">
<table>
<tr>
<td>Kode Prodi</td>
<td><input type="text" name="txtKode" size="5" value="<?php echo $d['kd_prodi']; ?>" readonly /></td>
</tr>
<tr>
<td>Nama Prodi</td>
<td><input type="text" name="txtNama" size="30" value="<?php echo $d['nm_prodi']; ?>"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="tbUpdate" value="Update"/></td>
</tr>
</table>
</form>
<?php
}else{
?>
<h3>Input Program Studi</h3>
<form method="POST" action="<?php $_SERVER['PHP_SELF']; ?>">
<table>
<tr>
<td>Kode Prodi</td>
<td><input type="text" name="txtKode" size="5"/></td>
</tr>
<tr>
<td>Nama Prodi</td>
<td><input type="text" name="txtNama" size="30"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="tbSimpan" value="SIMPAN"/></td>
</tr>
</table>
</form>
<?php
}
?>
<!-- blok proses -->
<?php
if($_GET['proses']=='edit'){
mysql_query("UPDATE prodi SET nm_prodi='$_POST[txtNama]' WHERE kd_prodi='$_POST[txtKode]'");
}
elseif($_GET['a']=='hapus'){
mysql_query("DELETE FROM prodi WHERE kd_prodi='$_GET[id]'");
}else{
if(isset($_POST['tbSimpan'])){
if(empty($_POST['txtKode']) or empty($_POST['txtNama'])){
echo "<script>window.alert('Form Masih Ada Yang Kosong!');
window.location=('./dataprodi.php')</script>";
}else{
mysql_query("INSERT INTO prodi(kd_prodi,nm_prodi)
VALUES('$_POST[txtKode]','$_POST[txtNama]')");
}
}
}
?>
<!-- blok tampilkan data -->
<h3>Data Program Studi</h3>
<a href="./dataprodi.php">Tambah Data</a><br/><br/>
<table border="1" cellpadding="4" cellspacing="0" width="100%">
<tr bgcolor="#ebebeb"><th>No.</th><th>Kode Prodi</th><th>Nama Prodi</th><th>?</th></tr>
<?php
$no=1;
$sql_prodi=mysql_query("SELECT * FROM prodi ORDER BY kd_prodi ASC");
$jml_data=mysql_num_rows($sql_prodi);
while($data=mysql_fetch_array($sql_prodi)){
echo "<tr>
<td align='center'>$no</td>
<td align='center'>$data[kd_prodi]</td>
<td>$data[nm_prodi]</td>
<td width='130px'align='center'><a href='?a=edit&id=$data[kd_prodi]'>Edit</a> |
<a href='?a=hapus&id=$data[kd_prodi]' onClick='return confirm(\"Apakah Anda benar ingin menghapus?\")'>Hapus</a></td>
</tr>";
$no++;
}
echo "<tr bgcolor='#f3f3f3'>
<td colspan='4' align='right'>Jumlah Prodi : <b>$jml_data</b></td>
</tr>";
?>
</table>
</div>
</body>
</html>
mysql_connect("localhost","root","")or die("Tidak Konek Coy");
mysql_select_db("latihan_a1") or die("Database tidak ada");
?>
<html>
<head>
<title>Aplikasi Data Program Studi</title>
<style type="text/css">
body{background:#ebebeb;font-family:Tahoma;font-size:80%;}
#kotak{width:600px;padding:10px;background:#fff;color:#000;border:1px solid #ebebeb;margin:10px auto;}
h3{display:block;padding:5px 0;border-bottom:1px solid #000;border-top:1px solid #000;}
a{padding:2px 10px;background:#f3f3f3;text-decoration:none;}
</style>
</head>
<body>
<div id="kotak">
<!-- form -->
<?php
if($_GET['a']== 'edit'){
$d=mysql_fetch_array(mysql_query("SELECT * FROM prodi WHERE kd_prodi='$_GET[id]'"));
?>
<h3>Edit Program Studi</h3>
<form method="POST" action="<?php $_SERVER['PHP_SELF']; ?>?proses=edit">
<table>
<tr>
<td>Kode Prodi</td>
<td><input type="text" name="txtKode" size="5" value="<?php echo $d['kd_prodi']; ?>" readonly /></td>
</tr>
<tr>
<td>Nama Prodi</td>
<td><input type="text" name="txtNama" size="30" value="<?php echo $d['nm_prodi']; ?>"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="tbUpdate" value="Update"/></td>
</tr>
</table>
</form>
<?php
}else{
?>
<h3>Input Program Studi</h3>
<form method="POST" action="<?php $_SERVER['PHP_SELF']; ?>">
<table>
<tr>
<td>Kode Prodi</td>
<td><input type="text" name="txtKode" size="5"/></td>
</tr>
<tr>
<td>Nama Prodi</td>
<td><input type="text" name="txtNama" size="30"/></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="tbSimpan" value="SIMPAN"/></td>
</tr>
</table>
</form>
<?php
}
?>
<!-- blok proses -->
<?php
if($_GET['proses']=='edit'){
mysql_query("UPDATE prodi SET nm_prodi='$_POST[txtNama]' WHERE kd_prodi='$_POST[txtKode]'");
}
elseif($_GET['a']=='hapus'){
mysql_query("DELETE FROM prodi WHERE kd_prodi='$_GET[id]'");
}else{
if(isset($_POST['tbSimpan'])){
if(empty($_POST['txtKode']) or empty($_POST['txtNama'])){
echo "<script>window.alert('Form Masih Ada Yang Kosong!');
window.location=('./dataprodi.php')</script>";
}else{
mysql_query("INSERT INTO prodi(kd_prodi,nm_prodi)
VALUES('$_POST[txtKode]','$_POST[txtNama]')");
}
}
}
?>
<!-- blok tampilkan data -->
<h3>Data Program Studi</h3>
<a href="./dataprodi.php">Tambah Data</a><br/><br/>
<table border="1" cellpadding="4" cellspacing="0" width="100%">
<tr bgcolor="#ebebeb"><th>No.</th><th>Kode Prodi</th><th>Nama Prodi</th><th>?</th></tr>
<?php
$no=1;
$sql_prodi=mysql_query("SELECT * FROM prodi ORDER BY kd_prodi ASC");
$jml_data=mysql_num_rows($sql_prodi);
while($data=mysql_fetch_array($sql_prodi)){
echo "<tr>
<td align='center'>$no</td>
<td align='center'>$data[kd_prodi]</td>
<td>$data[nm_prodi]</td>
<td width='130px'align='center'><a href='?a=edit&id=$data[kd_prodi]'>Edit</a> |
<a href='?a=hapus&id=$data[kd_prodi]' onClick='return confirm(\"Apakah Anda benar ingin menghapus?\")'>Hapus</a></td>
</tr>";
$no++;
}
echo "<tr bgcolor='#f3f3f3'>
<td colspan='4' align='right'>Jumlah Prodi : <b>$jml_data</b></td>
</tr>";
?>
</table>
</div>
</body>
</html>
Bagaimana mudahkan, Selamat Mencoba :D
0 komentar:
Post a Comment