Terlebih dahulu,
buat database “poltek” dan buat table “mahasiswa”.
CREATE TABLE
`mahasiswa`{
`nim` int(10) NOT NULL,
`nama` varchar(30) NOT NULL,
`tanggallahir` varchar(20) NOT NULL,
`alamat` text NOT NULL,
`notelp` int(15) NOT NULL,
PRIMARY KEY (`nim`)
}
Selanjutnya
buatlah file dengan nama data.php pada editor (saya menggunkan Dreamveawer CS
5), lalu ketikan code sebagai berikut :
<?php
mysql_connect('localhost','root','')
or die("Koneksi Gagal"); //
koneksi ke database
mysql_select_db('poltek') or die
("Database tidak bisa dibuka");
// pilih database
?>
<html>
<head>
<title>Tugas
UAS</title>
<style
type="text/css">
body{background:#CCC;font-family:Tahoma;font-size:12px;}
#row{
width:800px;padding:10px;background:#fff;color:#000;margin:auto;
}
</style>
</head>
<body
>
<div
id="row">
<?php
//======prose
untuk ekseskusi tambah,ubah dan hapus===========
//=================PROSES
CAPTCHA========================
function
acak(){
$panjangacak = 5;
$base="ABCDEFGHKLMNOPQRSTWXYZabcdefghjkmnpqrstwxyz123456789";
$max=strlen($base)-1;
$acak="";
mt_srand((double)microtime()*1000000);
while
(strlen($acak)<$panjangacak){
$acak.=$base{mt_rand(0,$max)};
}
return $acak;
}
//=============PROSES
SIMPAN=====================
if(isset($_POST['simpan'])){
$capta1=$_POST['capta1'];
$capta2=$_POST['capta2'];
$nama=$_POST['nama'];
$nim=$_POST['nim'];
$tgl_lahir=$_POST['tgl_lahir'];
$alamat=$_POST['alamat'];
$telp=$_POST['telp'];
if($capta1==$capta2){
$query=mysql_query("insert
into mahasiswa values ('$nim','$nama','$alamat','$tgl_lahir','$telp')") or
die(mysql_error());
header
('location:uas.php?message=sukses');
}else {
header
('location:uas.php?message=gagal');
}
}
//================EDIT=====================
if(isset($_GET['proses'])=='edit'){
mysql_query("UPDATE
mahasiswa SET
nama='$_POST[nama]',tanggallahir='$_POST[tgl_lahir]',alamat='$_POST[alamat]',notelp='$_POST[telp]'
WHERE nim='$_POST[nim]'");
}
//================HAPUS==================
if(isset($_GET['d'])=='hapus'){
mysql_query("DELETE
FROM mahasiswa WHERE nim='$_GET[id]'");
}
?>
<?php
if(isset($_GET['data'])==
'edit'){
$data=mysql_fetch_array(mysql_query("SELECT
* FROM mahasiswa WHERE nim='$_GET[id]'"));
?>
<!--======================
FORM EDIT =============================-->
<hr
color="#000000"/>
<h3
align="center">Edit Mahasiswa</h3>
<hr
color="#000000"/>
<form
method="post" action="?proses=edit" class="cmxform
form-horizontal tasi-form" >
<table
align="center">
<tr>
<td>Nim
:</td>
<td><input
type="text" name="nim" value="<?php echo
$data['nim']; ?>" readonly="readonly"></td>
</tr>
<tr>
<td>Nama
: </td>
<td
width='227'><input type="text" name="nama"
value="<?php echo $data['nama']; ?>"></td>
</tr>
<tr>
<td>Tanggal
Lahir</td>
<td><input
type="text" name="tgl_lahir" value="<?php echo
$data['tanggallahir']; ?>"></td>
</tr>
<tr>
<td> </td>
<td>*Format
tanggal (01-01-1991)</td>
</tr>
<tr>
<td>Alamat</td>
<td><input
type="text" name="alamat" value="<?php echo
$data['alamat']; ?>"></td>
</tr>
<tr>
<td>Telepon</td>
<td><input
type="text" name="telp" value="<?php echo
$data['notelp']; ?>"></td>
</tr>
<tr>
<td> </td>
<td
><input type="submit"
value="Ubah">
<input
type="reset" value="Batal"></td>
</tr>
</table>
</form>
<?php
}else{
?>
<!--====================
FORM TAMABAH ============================-->
<hr
color="#000000"/>
<h3 align="center">Tambah
Mahasiswa</h3>
<hr
color="#000000"/>
<form
method="post" action="" class="cmxform form-horizontal
tasi-form">
<table
align="center">
<tr>
<td>Nama
: </td>
<td
width='227'><input type="text"
name="nama"></td>
</tr>
<tr>
<td>Nim :</td>
<td><input
type="text" name="nim"></td>
</tr>
<tr>
<td>Tanggal
Lahir</td>
<td><input
type="text" name="tgl_lahir"></td>
</tr>
<tr>
<td> </td>
<td>*Format
tanggal (01-01-1991)</td>
</tr>
<tr>
<td>Alamat</td>
<td><input
type="text" name="alamat"></td>
</tr>
<tr>
<td>Telepon</td>
<td><input
type="text" name="telp"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input
type="text" name="capta1" style="background:#666;
text-align:center; font-size:25px" size="8"value="<?php
echo acak();?>" readonly="readonly"></td>
</tr>
<tr>
<td>Isi
Captcha</td>
<td><input
type="text" name="capta2"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td
><input type="submit" value="Simpan"
name="simpan">
<input
type="reset" value="Batal"></td>
</tr>
</table>
</form>
<?php
}
?>
<?php
if
(!empty($_GET['message']) && $_GET['message'] == 'sukses') {
echo '<h3
align="center">Berhasil menambah data!</h3>';
}
if
(!empty($_GET['message']) && $_GET['message'] == 'gagal') {
echo '<h3
align="center">Captcha Harus diisi dengan benar</h3>';
}
?>
<!--
=========== VIEW ====================-->
<br>
<hr
color="#000000"/>
<h3
align="center">Data Mahasiswa</h3>
<hr
color="#000000"/>
<br>
<table
border="1" align="center" width="100%">
<thead>
<tr>
<th
>Nama</th>
<th >Nim</th>
<th>Tanggal Lahir</th>
<th >Alamat</th>
<th >Telepon</th>
<th >Aksi</th>
</tr>
</thead>
<tbody>
<?php
$sql=mysql_query("select
* from mahasiswa");
while($data=mysql_fetch_array($sql)){
echo "
<tr>
<td align='center'>$data[nim]</td>
<td>$data[nama]</td>
<td
align='center'>$data[tanggallahir]</td>
<td>$data[alamat]</td>
<td
align='center'>$data[notelp]</td>
<td align='center'><a
href='?data=edit&id=$data[nim]'>Edit</a> || <a
href='?d=hapus&id=$data[nim]' >Hapus</a></td>
</tr> ";
}
?>
</tbody>
</table>
</div>
</body>
</html>
Jalankan
data.php berikut di browser dengan ketik : localhost/data.php.
Tampilan awall data.php
tampilan tabel mahasiswa :
Tampilan awall data.php
maka proses CRUD dalam satu halaman seudah selesai...
terima kasih..
terima kasih..
Tidak ada komentar:
Posting Komentar