Hi, selamat pagi semuanya, dari tadi malam saya gak tidur-tidur karena banyak sekali tugas yang harus saya cari. Pada pagi hari ini mata pun sudah kecil, kayaknya sudah mau tidur aja bawaannya. Karena saya hari ini mau posting, maka saya harus lanjut menulis pada postingan ini yaitu saya akan membagi tutorial cara membuat web CRUD yaitu aplikasi yang terdapat fitur create, read, update, dan delete menggunakan PHP. OK, langsung saja kita ke langkahnya.
Buatlah database dengan nama test, dengan nama tabel costumer
Buat file
koneksi.php
<?php
$conn=mysql_connect('localhost','root','');
mysql_select_db('test',$conn);
?>
Buat form input atau tambah data baru.
costumer.php
<div class="formset">
<form method="post">
<table align="center" >
<tr><td colspan="2" align="center"><h2>Data Customer</h2></td></tr>
<tr>
<td width="137">Id Customer</td><td width="353"><input type="text" name="ic" size="10" maxlength="10" id="ic" /></td></tr>
<tr>
<td>Nama Customer</td><td><input type="text" name="nc" size="50" maxlength="50" id="nc" /></td></tr>
<tr>
<td>Jurusan</td><td><input type="text" name="jr" size="50" maxlength="50" id="nc" /></td></tr>
<tr><td height="38" ></td><td><input name="Simpan" type="submit" value="Simpan" />
<input type="reset" value="Reset"/></td></tr>
</table>
</form>
</div>
Buat form update data.
<div class="formset">
<form method="post">
<table align="center" >
<tr><td colspan="2" align="center"><h2>Data Customer</h2></td></tr>
<tr>
<td width="137">Id Customer</td><td width="353"><input name="ic" type="text" id="ic" value="<?php echo $xx[0] ?>" size="10" maxlength="10" readonly /></td></tr>
<tr>
<td>Nama Customer</td><td><input name="nc" type="text" id="nc" value="<?php echo $xx[1] ?>" size="50" maxlength="50"/></td></tr>
<tr>
<td>Jurusan</td><td><input name="jr" type="text" id="nc" value="<?php echo $xx[2] ?>" size="50" maxlength="50"/></td></tr>
<tr><td height="38" ></td><td><input name="update" type="submit" value="Update" />
<input type="submit" value="Reset" name="reset" /></td></tr>
</table>
</form>
</div>
Untuk menggunakan salah satu form
kita gunakan if.
<?php
include 'koneksi.php';
if (isset($_GET['nocus'])){
$nokam=$_GET['nocus'];
$sa=mysql_query("select *from customer where id_costumer='$nokam'",$conn);
$xx=mysql_fetch_array($sa);
?>
//masukkan form update data.
<?php
} else {
?>
//masukkan form input/add data baru
<?php
}
Untuk koding proses simpan dan update data pastekan koding dibawah ini.
if($_SERVER['REQUEST_METHOD'] == "POST"){
if (isset($_POST['reset'])){
echo "<meta http-equiv='refresh' content='0; url=?p=customer'>";
exit;
}
$id = $_POST['ic'];
$nama = $_POST['nc'];
$jr = $_POST['jr'];
if ($id=="" || $nama=="" || $jr=="" ){
echo "<script>alert('Data belum lengkap...')</script>";
} else {
if (isset($_POST['Simpan'])){
$queri="insert into customer values ('$id','$nama','$jr')";
mysql_query($queri,$conn);
echo "<script>alert('Data sudah disimpan...')</script>";
} else if (isset($_POST['update'])){
$queri="update customer set nama_costumer='$nama',jurusan='$jr' where id_costumer='$id'";
mysql_query($queri,$conn);
echo "<meta http-equiv='refresh' content='0; url=?p=customer'>";
echo "<script>alert('Data sudah diupdate...')</script>";
}
}
}
?>
Selanjutnya menampilkan data yang tersimpan kedalam sebuah tabel, pastekan koding berikut pada bari paling bawah.
<table width="70%" border="1" align="center" class="tabel">
<tr><th width="9%">No</th>
<th width="15%" >Id Customer</th>
<th width="36%">Nama Customer</th>
<th width="26%">Jurusan</th>
<th width="20%" colspan="2">Modify</th>
</tr>
<?php
$queri="select *from customer";
$hasil=mysql_query($queri);
$jm=mysql_num_rows($hasil);
$no=1;
while ($data=mysql_fetch_array($hasil)){
echo "<tr><td align='center'>$no</td><td align='center'>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td><a href='?p=customer&nocus=$data[0]'>edit <a href='hapus.php?nocus=$data[0]' onClick=\"return confirm('Anda yakin ingin menghapus $data[1] ?')\">hapus</a></td></tr>";
$no++;
}
?>
</table>
Koding lengkapnya adalah sebagai berikut
<?php
include 'koneksi.php';
if (isset($_GET['nocus'])){
$nokam=$_GET['nocus'];
$sa=mysql_query("select *from customer where id_costumer='$nokam'",$conn);
$xx=mysql_fetch_array($sa);
?>
<div class="formset">
<form method="post">
<table align="center" >
<tr><td colspan="2" align="center"><h2>Data Customer</h2></td></tr>
<tr>
<td width="137">Id Customer</td><td width="353"><input name="ic" type="text" id="ic" value="<?php echo $xx[0] ?>" size="10" maxlength="10" readonly /></td></tr>
<tr>
<td>Nama Customer</td><td><input name="nc" type="text" id="nc" value="<?php echo $xx[1] ?>" size="50" maxlength="50"/></td></tr>
<tr>
<td>Jurusan</td><td><input name="jr" type="text" id="nc" value="<?php echo $xx[2] ?>" size="50" maxlength="50"/></td></tr>
<tr><td height="38" ></td><td><input name="update" type="submit" value="Update" />
<input type="submit" value="Reset" name="reset" /></td></tr>
</table>
</form>
</div>
<?php
} else {
?>
<div class="formset">
<form method="post">
<table align="center" >
<tr><td colspan="2" align="center"><h2>Data Customer</h2></td></tr>
<tr>
<td width="137">Id Customer</td><td width="353"><input type="text" name="ic" size="10" maxlength="10" id="ic" /></td></tr>
<tr>
<td>Nama Customer</td><td><input type="text" name="nc" size="50" maxlength="50" id="nc" /></td></tr>
<tr>
<td>Jurusan</td><td><input type="text" name="jr" size="50" maxlength="50" id="nc" /></td></tr>
<tr><td height="38" ></td><td><input name="Simpan" type="submit" value="Simpan" />
<input type="reset" value="Reset"/></td></tr>
</table>
</form>
</div>
<?php
}
if($_SERVER['REQUEST_METHOD'] == "POST"){
if (isset($_POST['reset'])){
echo "<meta http-equiv='refresh' content='0; url=?p=customer'>";
exit;
}
$id = $_POST['ic'];
$nama = $_POST['nc'];
$jr = $_POST['jr'];
if ($id=="" || $nama=="" || $jr=="" ){
echo "<script>alert('Data belum lengkap...')</script>";
} else {
if (isset($_POST['Simpan'])){
$queri="insert into customer values ('$id','$nama','$jr')";
mysql_query($queri,$conn);
echo "<script>alert('Data sudah disimpan...')</script>";
} else if (isset($_POST['update'])){
$queri="update customer set nama_costumer='$nama',jurusan='$jr' where id_costumer='$id'";
mysql_query($queri,$conn);
echo "<meta http-equiv='refresh' content='0; url=?p=customer'>";
echo "<script>alert('Data sudah diupdate...')</script>";
}
}
}
?>
<table width="70%" border="1" align="center" class="tabel">
<tr><th width="9%">No</th>
<th width="15%" >Id Customer</th>
<th width="36%">Nama Customer</th>
<th width="26%">Jurusan</th>
<th width="20%" colspan="2">Modify</th>
</tr>
<?php
$queri="select *from customer";
$hasil=mysql_query($queri);
$jm=mysql_num_rows($hasil);
$no=1;
while ($data=mysql_fetch_array($hasil)){
echo "<tr><td align='center'>$no</td><td align='center'>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td><a href='?p=customer&nocus=$data[0]'>edit <a href='hapus.php?nocus=$data[0]' onClick=\"return confirm('Anda yakin ingin menghapus $data[1] ?')\">hapus</a></td></tr>";
$no++;
}
?>
</table>
Buat file hapus.php
hapus.php
<?php
if (isset($_GET['nocus'])){
mysql_query("delete from customer where id_costumer='$_GET[nocus]'");
echo '<meta http-equiv="refresh" content="0;URL=customer.php">';
}
?>
Hasilnya seperti dibawah ini.
