Annyeonghaseyo chingu...
Kali ini saya akan memposting tentang Web
Programming PHP dan MySQL...
Mulai dari input,simpan,lihat,edit,dan
delete. Yang berminat silahkan copas tapi tinggalkan jejak dulu ya (kasih
kritik atau komentar apapun yang membangun dan tidak men-judge sembarangan).
Terima kasih.
Baiklah untuk postingan kali ini yaitu tentang pembuatan
form formulir sebelumnya anda buat dulu strukturnya di localhost/phpmyadmin
dengan ketentuan sebagai berikut:
Field
Type
Size
Key
id
int
10
auto increment primary key
nama
varchar
100
alamat
varchar
100
city
varchar
50
telepon
varchar
12
pekerjaan
varchar
50
foto
varchar
100
Untuk folder
fotonya kalian buat sendiri di php codernya dengan nama PRODUK.
Ingat!!! Simpan
folder produk tersebut di tempat dimana anda menyimpan script php.
Tampilan input (simpan dengan nama input_formulir.php)
Scriptnya:
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Title here!</title>
</head>
<body bgcolor=#80FF80>
<pre>
<h2><font
color="black"><font="Arial"><div
align="center">FORMULIR ONLINE SISWA SMAN 1 BANJARSARI</div></font></h2>
<h3><font
color="black"><font="Arial"><div
align="center">===========================================</div></font></h3>
<form encrype="multipart/form-data" method="POST"
action="simpan_formulir.php">
<table border="1" width="400"
align="center" cellspacing="1">
<tr>
<td width="200"><b>Nama
Siswa :
</b></td><td><b><input type="text"
name="nama" size=30 id="nama"></b></td></tr><tr>
<td
width="200"><b>Alamat
: </b></td><td><b><input type="text"
name="alamat" size=30
id="alamat"></b></td></tr><tr>
<td
width="200"><b>Kota
: </b></td><td><b><input type="text"
name="kota" size="30" id="kota"></b></td></tr><tr>
<td
width="200"><b>Telepon
: </b></td><td><b><input type="text"
name="telepon" size="30"
id="telepon"></b></td></tr><tr>
<td width="200"><b>Pekerjaan Orang Tua :
</b></td><td><select size="1"
name="pekerjaan"
id="pekerjaan"><option>Karyawan</option><option>PNS</option><option>Buruh</option></select><br></td>
</tr>
<tr>
<td><b>Masukkan Foto Anda
:<td><input type="file" name="gambar"
id="produk"></b></td><tr>
<td border="0" align="center"
colspan="2">
<input type="submit" name=tsimpan
value="Simpan"> <input type="reset" name=treset
value="Reset">
</tr></td>
</table>
</pre>
</body>
</html>
B. Koneksi (simpan dengan nama koneksi1.php)
Scriptnya:
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Title here!</title>
</head>
<body>
<?
$koneksi1=mysql_connect("localhost","root","password")or
die("koneksi gagal".mysql_error());
mysql_select_db("formulir");
?>
</body>
</html>
C. TAMPILAN SIMPAN
(simpan dengan nama simpan_fromulir.php)
<!doctype html public "-//W3C//DTD HTML 4.0
//EN">
<html>
<head>
<title>Title
here!</title>
</head>
<body bgcolor=#FFFF80>
<?
include "koneksi1.php";
$img=$_FILES['gambar']['name'];
$simpan=mysql_query("INSERT INTO
siswa(gambar,id,nama,alamat,kota,telepon,pekerjaan)
VALUES
('$gambar','$id','$nama','$alamat','$kota','$telepon','$pekerjaan')");
copy($HTTP_POST_FILES['gambar']['tmp_name'],"$gambar/$img");
if ($simpan)
echo "<center><font color=blue
size=7><blink>DATA BERHASIL
DIKIRIM</blink></font></center>";
else
echo "<center><font color=blue
size=7><blink>DATA GAGAL
DIKIRIM</blink></font></center>";
?><p>
<hr size=7 width=70% align=center color=red>
<a
href="lihat_formulir.php"><center><input type=submit
value="Lihat Data Siswa"</center></a>
</body>
</html>
D.
Tampilan entry
formulir (simpan dengan nama lihat_fromulir.php).
Scriptnya:
<!doctype html public "-//W3C//DTD HTML 4.0
//EN">
<html>
<head>
<title>Title here!</title>
</head>
<body bgcolor=#66FF66>
<pre>
<table bgcolor=#FFFF59 align="center" border=1 width=60%>
<tr><td colspan="4" align="center"><h2><marquee>:::TAMPIL DATA CALON SISWA:::</marquee></h2>
<hr size=5 width=90% align=center color=black></td><tr>
<?php
$koneksi1=mysql_connect("localhost","root","password")or die("Koneksi gagal".mysql_error());
if($koneksi1)
{
mysql_select_db("formulir",$koneksi1) or die ("Database gagal dibuka".mysql_error());
$sql=mysql_query("SELECT * FROM siswa",$koneksi1)or die ("Query gagal".mysql_error());
while ($data=mysql_fetch_array($sql)){
?>
<tr>
<td align=center width="20%" rowspan="5"><img src="produk/<? echo $data['gambar'];?>"width=70% border=2 /></td>
<td>Nama Siswa</td><td>:</td><td><?php echo $data['nama'];?></td>
</tr>
<tr>
<td>Alamat</td><td>:</td><td><?php echo $data['alamat'];?></td>
</tr>
<tr>
<td>Kota</td><td>:</td><td><?php echo $data['kota'];?></td>
</tr>
<tr>
<td>Telepon</td><td>:</td><td><?php echo $data['telepon'];?></td>
</tr>
<tr>
<td>Pekerjaan</td><td>:</td><td><?php echo $data['pekerjaan'];?></td>
</tr>
<tr>
<td colspan="4" align=center><a href="edit_formulir.php?nama=<?php echo $data['nama'];?>">Edit</a> <a href="hapus_formulir.php?nama=<?php echo $data['nama'];?>">Delete</a><hr size=5 width=100% color=red>
</td>
</tr>
<?php
}}?>
</table>
<hr size=7 width=70% align=center color=grey>
<a href="input_formulir.php"><center><input type=submit value="Back To Home"</center></a>
</body>
</html>
<html>
<head>
<title>Title here!</title>
</head>
<body bgcolor=#66FF66>
<pre>
<table bgcolor=#FFFF59 align="center" border=1 width=60%>
<tr><td colspan="4" align="center"><h2><marquee>:::TAMPIL DATA CALON SISWA:::</marquee></h2>
<hr size=5 width=90% align=center color=black></td><tr>
<?php
$koneksi1=mysql_connect("localhost","root","password")or die("Koneksi gagal".mysql_error());
if($koneksi1)
{
mysql_select_db("formulir",$koneksi1) or die ("Database gagal dibuka".mysql_error());
$sql=mysql_query("SELECT * FROM siswa",$koneksi1)or die ("Query gagal".mysql_error());
while ($data=mysql_fetch_array($sql)){
?>
<tr>
<td align=center width="20%" rowspan="5"><img src="produk/<? echo $data['gambar'];?>"width=70% border=2 /></td>
<td>Nama Siswa</td><td>:</td><td><?php echo $data['nama'];?></td>
</tr>
<tr>
<td>Alamat</td><td>:</td><td><?php echo $data['alamat'];?></td>
</tr>
<tr>
<td>Kota</td><td>:</td><td><?php echo $data['kota'];?></td>
</tr>
<tr>
<td>Telepon</td><td>:</td><td><?php echo $data['telepon'];?></td>
</tr>
<tr>
<td>Pekerjaan</td><td>:</td><td><?php echo $data['pekerjaan'];?></td>
</tr>
<tr>
<td colspan="4" align=center><a href="edit_formulir.php?nama=<?php echo $data['nama'];?>">Edit</a> <a href="hapus_formulir.php?nama=<?php echo $data['nama'];?>">Delete</a><hr size=5 width=100% color=red>
</td>
</tr>
<?php
}}?>
</table>
<hr size=7 width=70% align=center color=grey>
<a href="input_formulir.php"><center><input type=submit value="Back To Home"</center></a>
</body>
</html>
E.
Form edit (simpan
dengan nama edit_formulir.php)
Scriptnya:
<!DOCTYPE HTML
PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta
http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled
Document</title>
</head>
<body
bgcolor=#000000>
<?
include
"koneksi1.php";
$nama=$_GET['nama'];
$tampil=mysql_query("select*from
siswa where nama='$nama'");
$data=mysql_fetch_array($tampil);
?>
<form
action="update_formulir.php" method="post">
<table
width="70%" border="2" align=center
bgcolor=#8F8F8F>
<tr>
<td colspan="4"
align="center"><h2><marquee>..:: EDIT DATA SISWA
::..</marquee></h2></td>
</tr>
<tr>
<td
width="34%" rowspan="8"><img src="produk/<? echo
$data['gambar'];?>"width="250" border="2"
name="gambar" id="gambar2"/></td>
<td width="30%"><b>Nama</b></td>
<td width="5%">:</td>
<td width="40%"><input name="nama"
type="text" id="nama" value="<? echo
$data['nama'];?>"/></td>
</tr>
<tr>
<td><b>Alamat</b> </td>
<td>:</td>
<td><input name="alamat" type="text"
id="alamat" value="<? echo
$data['alamat'];?>"/></td>
</tr>
<tr>
<td><b>Kota</b></td>
<td>:</td>
<td><input name="kota" type="text"
id="kota" value="<? echo
$data['kota'];?>"/></td>
</tr>
<tr>
<td><b>Telepon</b></td>
<td>:</td>
<td><input name="telepon" type="text"
id="telepon" value="<? echo
$data['telepon'];?>"/></td>
</tr>
<tr>
<td><b>Pekerjaan</b></td>
<td>:</td>
<td><select name="pekerjaan" id="pekerjaan">
<option <? if ($data['bonus']=="Karyawan") echo
"selected";?>>Karyawan</option>
<option <? if ($data['bonus']=="PNS") echo
"selected";?>>PNS</option>
<option <? if ($data['bonus']=="Buruh") echo
"selected";?>>Buruh</option>
</select></td>
<input type="hidden" name="id" value=<? echo
$row['id']?>></td>
</tr>
<td><b>Gambar</b></td>
<td>:</td>
<td><input type="file" name="gambar"
id="gambar"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><div align="left"><i>Pilih photo jika ingin
diganti</i></div></td>
</tr>
<tr>
<td colspan="4"><center><input type="submit"
name="update" value="Update"></center></td>
</tr>
</table>
</form>
</body>
</html>
F.
Update
formulir (simpan dengan nama update_formulir.php)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<?
include "koneksi1.php";
$ubah=("UPDATE siswa SET
gambar='$gambar',nama='$nama',alamat='$alamat',kota='$kota',telepon='$telepon',pekerjaan='$pekerjaan'
where nama='$nama'");
mysql_query($ubah);
echo"<meta http-equiv='refresh' content='0;
url=lihat_formulir.php?DATA TELAH BERUBAH'>";
?>
</body>
</html>
G.
Hapus
data formulir (simpan dengan nama hapus_formulir)
Scriptnya:
<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
<title>Title here!</title>
</head>
<body bgcolor=#8080FF>
<?
include"koneksi1.php";
$nama=$_GET['nama'];
$hapus=mysql_query("delete from siswa where nama='$nama'");
if ($hapus)
echo"<center><font size=6 color=blue>Data Siswa Dengan
Nama $nama Telah Terhapus </font><br>
<a href=lihat_formulir.php>Kembali</a></center>";
else
echo"Data Siswa gagal dihapus <a href=lihat_formulir.php>
Kembali</a>";
?>
</body>
</html>
