Project Sederhana
-Program pendataan penyakit
-Rancangan:
-Tujuan : pendataan dan pengelolaan data penyakit
-Fitur :
-Input data penyakit
-Menampilkan data penyakit
-Hapus data penyakit
-Edit data penyakit
Berikut ini adalah bagian form_isi.php
<html> <body background="http://4.bp.blogspot.com/-aFSWCnw3Os8/UYpxjyw_OLI/AAAAAAAAAH8/FUcr4e-qCjc/s1600/Daft+Punk+For+Yves+Saint+Lauren.png"> <?php include "koneksi.php"; $kode_penyakit = $_POST['kode_penyakit']; $nama_penyakit = $_POST['nama_penyakit']; $definisi = $_POST['definisi']; $query = "insert into penyakit (kode,nama,definisi) values ('$kode_penyakit','$nama_penyakit','$definisi')"; $hasil = mysql_query($query); if($hasil){ echo "<h3 align='center'>Pengiriman Data Sukses !</h3>"; } else { echo "<h3 align='center'>Pengiriman Data Gagal ! <input type=button value=BACK OnClick=self.history.back();></h3>"; } ?> </body> </html>
skrinsut koneksi ke database, pakai koneksi.php
<?php mysql_connect("localhost","root",""); mysql_select_db("marty_pwd1"); ?>
jangan lupa buat database, namanya kalo bisa samain “marty_pwd1”, trus buat tabel nama, definisi, kode simpan_data.php
<html> <body background="http://4.bp.blogspot.com/-aFSWCnw3Os8/UYpxjyw_OLI/AAAAAAAAAH8/FUcr4e-qCjc/s1600/Daft+Punk+For+Yves+Saint+Lauren.png"> <?php include "koneksi.php"; $kode_penyakit = $_POST['kode_penyakit']; $nama_penyakit = $_POST['nama_penyakit']; $definisi = $_POST['definisi']; $query = "insert into penyakit (kode,nama,definisi) values ('$kode_penyakit','$nama_penyakit','$definisi')"; $hasil = mysql_query($query); if($hasil){ echo "<h3 align='center'>Pengiriman Data Sukses !</h3>"; } else { echo "<h3 align='center'>Pengiriman Data Gagal ! <input type=button value=BACK OnClick=self.history.back();></h3>"; } ?> </body> </html>
jadi kalau berhasi ada tulisan Pengiriman data sukses, jika gagal keluar tulisanPengiriman data gagal Menampilkan daftar data daftar_data.php
l> <body background="http://newnownext.mtvnimages.com/2013/04/daft-punk-2.jpg?width=2560&height=1024"> <table border="1" width="550" align="center"> <tr> <td height=20 align="center" width=50><b><font color='white'>Kode</font></b></td> <td align="center" width=200><b><font color='white'>Nama Penyakit</font></b></td> <td align='center' width=300><b><font color='white'>Definisi</font></b></td> </tr> <?php include "koneksi.php"; $qdata = mysql_query("select kode,nama,definisi from penyakit"); while($rdata = mysql_fetch_array($qdata)){ $kode = $rdata["kode"]; $nama = $rdata["nama"]; $definisi = $rdata["definisi"]; echo "<tr> <td align='center'><font color='white'>$kode</font></td> <td><font color='white'>$nama</font></td> <td><font color='white'>$definisi</font></td> </tr>"; } ?> </table> </body> </html>
skrinsur bero Hapus data pakai ini hapus_data.php
<html> <body background="http://4.bp.blogspot.com/-aFSWCnw3Os8/UYpxjyw_OLI/AAAAAAAAAH8/FUcr4e-qCjc/s1600/Daft+Punk+For+Yves+Saint+Lauren.png"> <?php include "koneksi.php"; ?> <table border="1" width="550" align="center"> <tr> <td height=20 align="center" width=50><b>Kode</b></td> <td align="center" width=170><b>NamaPenyakit</b></td> <td align='center' width=250><b>Definisi</b></td> <td align='center' width=80><b>Fungsi</b></td> </tr> <?php $hapus = (!empty($_GET['hapus']) ? $_GET['hapus'] : ''); if($hapus==1) { $kode = $_GET['kode']; $query2 = "delete from penyakit where kode='$kode'"; mysql_query($query2); } $qdata= mysql_query("select kode,nama,definisi from penyakit order by kode"); $i = 0; while($rdata= mysql_fetch_array($qdata)) { $pkode= $rdata["kode"]; $pnama= $rdata["nama"]; $pdefinisi= $rdata["definisi"]; echo "<tr><td align='center'>$pkode</td><td >$pnama</td> <td>$pdefinisi</td><td align='center'> <a href='hapus_data.php?kode=$pkode&hapus=1'>Hapus</a></td></tr>"; $i++; }?> </table> </body> </html>
gambare dab terakhir edit data edit_data.php
<html> <body background="http://4.bp.blogspot.com/-aFSWCnw3Os8/UYpxjyw_OLI/AAAAAAAAAH8/FUcr4e-qCjc/s1600/Daft+Punk+For+Yves+Saint+Lauren.png"> <?php include "koneksi.php"; ?> <table border="1" width="550" align="center"> <tr> <td height=20 align="center" width=50><b>Kode</b></td> <td align="center" width=170><b>Nama Penyakit</b></td> <td align='center' width=250><b>Definisi</b></td> <td align='center' width=80><b>Fungsi</b></td> </tr> <?php $kirim_edit = (!empty($_GET['kode']) ? $_GET['kode'] : ''); $edit = (!empty($_GET['edit']) ? $_GET['edit'] : ''); if($kirim_edit==1){ $query3 = "update penyakit set kode='$kode_penyakit', nama='$nama_penyakit', definisi='$definisi' where kode='$kodeg'"; mysql_query($query3); } $i=0; $qdata = mysql_query("select kode,nama,definisi from penyakit order by kode"); while($rdata = mysql_fetch_array($qdata)) { $pkode = $rdata["kode"]; $pnama = $rdata["nama"]; $pdefinisi = $rdata["definisi"]; echo "<tr> <td align='center'>$pkode</td><td >$pnama</td> <td>$pdefinisi</td><td align='center'> <a href='edit_data.php?kode=$pkode&edit=1'>Edit</a></td></tr>"; $i++; } ?> </table> <br> <?php if($edit==1) { $kode = $kirim_edit; $qdata2 = mysql_query("select nama, definisi from penyakit where kode='$kode'"); while($rdata2 = mysql_fetch_array($qdata2)) { $nama2 = $rdata2["nama"]; $definisi2 = $rdata2["definisi"]; } echo "<p align='center'>Ubah Data Penyakit <br><br>"; echo "<form method='post' action='edit_data.php'> <input type='hidden' name='kodeg' value='$kode'> <input type='hidden' name='kirim_edit' value=1>"; echo "<table border=0 width=500 align='center'>"; echo " <tr> <td width=150>Kode Penyakit </td><td><input type='text' name='kode_penyakit' size=4 value='$kode'></td> </tr> <tr> <td>Nama Penyakit </td> <td><input type='text' name='nama_penyakit' size=40 value='$nama2'></td> </tr> <tr> <td valign='middle'>Definisi Penyakit </td> <td><textarea name='definisi' cols=40 rows=6>$definisi2</textarea></td> </tr> <tr> <td colspan=2 align='center'><input type='submit' value='EDIT'></td> </tr>"; echo "</table></form></p>"; } ?> </body> </html>