Belajar PHP : Mebuat input , view, edit , delete

pertama tama kita siapkan file file nya
1. buat data basenya terlebih dahulu
Create table user ( No int(15) auto_increment, Nama varchar (255), Alamat varchar (255), Primary key(no) )

2. buat file koneksi ke data base deri nama koneksi.php
$dbhost="localhost"; $dbname="namadb"; $dbuser= "root"; $dbpass="";< mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); ?>
3. buat form input kali ini kita simpan dengan nama index.php
<form method="POST" action="proses.php"><br /> <table width="200" border="0" bgcolor="#CCCCCC"><br /> <tr> <td colspan="2">Input Form </td> </tr>< <tr> <td>Nama</td> <td><input ype="text" name="nama" /></td> </tr> <tr> <td>Alamat</td> <td><input type="text" name="alamat" /></td> </tr> <tr> <td>&nbsp;</td> <td><input name="submit" type=submit value=Input /> <label> <input type="reset" name="batal" value="Batal" /> </label></td> </tr><br /> </table><br /> </form>
4. buat form pemroses nya simpan dengan nama proses.php
<? include("koneksi.php"); $nama = $_POST['nama']; $alamat = $_POST['alamat']; $q = "insert into user(nama, alamat) values ('$nama', '$alamat')"; $h = mysql_query($q); if ($h){ echo "<blink>berhasil</blink>"; echo "<br />";<br /> echo "<a href='index.php'>kembali</a> "; echo "<a href='view.php'>Lihat hasil</a>"; }& else { echo "gagal"; } ?>
5. selanjutnya kita buat form edit , simpan dengan nama edit.php
<? include"koneksi.php"; $id = $_GET['id']; $q = "select * from user where No = $id"; $h = mysql_query($q); $row=mysql_fetch_array($h); ?> <form method=post action=prosesedit.php> <input type=hidden name="id" value="<?echo $row['No'];?>"> <table width="200" border="1"> <tr><br /> <td>&nbsp;</td> <td>Edit Form </td> </tr> <tr> <td>Nama</td> <td><input type="text" name="nama_edit" value="<?echo $row['Nama'];?>" /></td> </tr> <tr> <td>Alamat</td> <td><input type="text" name="alamat_edit" value="<?echo $row['Alamat'];?>" /></td> </tr> <tr> <td>&nbsp;</td> <td><input name="submit" type="submit" value="Edit" /> <input name="reset" type="reset" value="reset" /></td> </tr> </table> <br> </form>
6. buat proses edit , simpan dengan nama prosesedit.php
<? include "koneksi.php"; $id = $_POST['id']; $nama = $_POST['nama_edit']; $alamat = $_POST['alamat_edit']; $q = "update user set Nama='$nama', Alamat='$alamat' where No=$id"; $h = mysql_query($q); //echo $q;exit; if($h) { echo "berhasil"; } else { echo "Gagal"; } echo "<br>"; echo "<a href=paging.php>Lihat Data</a>"; ?>
7. buat halaman view, simpan dengan nama view.php
<? include "koneksi.php"; //langkah 1 $batas = 5; $halaman = $_GET['halaman']; if (empty($halaman)){ $posisi = 0; $halaman = 1; } else { $posisi = ($halaman-1)*$batas; } //langkah 2<br /> echo "<table width='50% border='0'>";<br /> echo "<tr><td>no</td><td>Nama</td><td>Alamat</td><td>Aksi</td></tr>"; $tampil = "select * from user limit $posisi, $batas"; $hasil = mysql_query($tampil); $no = $posisi + 1; while ($data = mysql_fetch_array($hasil)){<br /> echo "<tr><td>$no</td><td>$data[Nama]</td><td>$data[Alamat]</td><td><a href=edit.php?id=$data[No]>Edit</a> | <a href=hapus.php?id=$data[No]>Hapus</a> | <a href=index.php>Tambah</a></td></tr>"; $no++; } echo "</table><br>"; //langkah 3 $tampil2 = mysql_query("select * from user"); $jmldata = mysql_num_rows($tampil2); $jmlhalaman = ceil($jmldata/$batas); $file="view.php"; // langkah 4 if($halaman > 1){ $previous = $halaman-1; echo "<a href=$file?halaman=1>1 first</a> | <a href=$file?halaman=$previous> Prev</a>"; } else { echo "1 first | Prev"; // langkah 5 for($i=1; $i<=$jmlhalaman; $i++) echo "<a href=$file?halaman=$i>$i</a> |"; } else { echo "<b>$i</b>"; } //langkah 6 if($halaman<$jmlhalaman){ $next=$halaman+1; echo "<a href=$file?halaman=$next> Next</a> | <a href=$file?halaman=$halaman=$jmlhalaman>Last</a>"; } ?>
8.terahir buat proses hapusnya , simpan dengan nama hapus.php
<? include"koneksi.php"; $id = $_GET['id']; $q = "delete from user where No=$id"; $h = mysql_query($q); if ($h){ echo "Berhasil"; else { echo "Gagal"; } echo "<a href=view.php>Kembali</a>"; ?>

untuk lebih simpel nya bisa di download di sini