Contoh Form Sederhana Pendaftaran Siswa Baru
LANGKAH-LANGKAH
1. Kita buat databasenya dulu
CREATE TABLE IF NOT EXISTS `tbl_daftar_mahasiswa` (
`id_daftar` int(10) NOT NULL auto_increment,
`tanggal_daftar` date default NULL,
`nama_pendaftar` varchar(75) default NULL,
`jns_kelamin` varchar(15) default NULL,
`status` varchar(20) default NULL,
`lulusan_sekolah` varchar(20) default NULL,
`tahun_ajaran` int(6) default NULL,
`pekerjaan` varchar(125) default NULL,
`alamat` varchar(150) default NULL,
`kelurahan` varchar(75) default NULL,
`kecamatan` varchar(75) default NULL,
`kota` varchar(75) default NULL,
`provinsi` varchar(75) default NULL,
`telp` varchar(20) NOT NULL default '',
PRIMARY KEY (`id_daftar`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2. Langkah kedua kita harus buat koneksi.php umtuk menyambungkan ke database
<?php
$host = "localhost";
$username = "root";
$password = "";
$database = "pendaftaran_db";
$koneksi = mysql_connect($host, $username, $password);
$pilihdatabase = mysql_select_db($database, $koneksi);
// if ($pilihdatabase) echo"Berhasil";
// else echo "Gagal Koneksi";
?>
3. Langkah ketiga kita buat index.html untuk tampilan utamanya
<html>
<head><title>Form Pendaftaran Mahasiswa Baru</title>
</head>
<link rel="stylesheet" type="text/css" href="style.css">
<body style="background-color: white">
<form action="insert.php" method="POST">
<table border='10' width='35%' cellpadding='2' cellspacing='2' align='center' bgcolor="#FFFFF" style="border-radius: 30px; box-shadow: rgba(0 10 0 10);">
<center><img src="header.png"</center>
<caption><h2>Formulir Pendaftaran Mahasiswa Baru</h2></caption>
<tr><td><b>Nama</b></td><td><input type="text" name="nama" size="30" maxlength="50"/></td></tr>
<tr><td><b>Jenis Kelamin</b></td><td><input type="radio" name="jenis_kelamin" value="pria"/><label for="jenis_kelamin">Laki-laki</label>
<input type="radio" name="jenis_kelamin" value="wanita"/><label for="jenis_kelamin">Perempuan</label>
</td></tr>
<tr><td><b>Status</b></td><td>
<select name="status">
<option value="Pilih Status Anda">Pilih Status Anda</option>
<option value="menikah">Menikah</option>
<option value="single">Single</option>
<option value="janda">Janda</option>
<option value="jomblo">Jomblo</option>
</select>
</td></tr>
<tr><td><b>Lulusan Sekolah<b/></td><td><input type="text" name="sekolah" size="30" maxlength="50"/></td></tr>
<tr><td><b>Tahun Ajaran</b></td><td><select name="tahun_ajaran">
<option>Pilih Tahun Ajaran</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
</select></td></tr>
<tr><td><b>Pekerjaan</b></td><td><input type="text" name="pekerjaan" size="30" maxlength="50"/></td></tr>
<tr><td><b>Alamat</b></td><td><textarea name="alamat" cols="30" rows="4"></textarea></td></tr>
<tr><td><b>Kelurahan</b></td><td><input type="text" name="kelurahan" size="30" maxlength="50"/></td></tr>
<tr><td><b>Kecamatan</b></td><td><input type="text" name="kecamatan" size="30" maxlength="50"/></td></tr>
<tr><td><b>Kota</b></td><td><input type="text" name="kota" size="30" maxlength="50"/></td></tr>
<tr><td><b>Provinsi</b><td><input type="text" name="provinsi"size"30" maxlenght="50"/></td></tr>
</select></td></tr>
<tr><td><b>No Telepon</b></td><td><input type="text" name="telepon" size="30" maxlength="50"/></td></tr>
<tr><td></td><td><input type="submit" name="kirim" value="Daftar!"/>
<label>
<input type="reset" name="Reset" id="button" value="Batal">
</label></td></tr>
</table>
<p align="center"><a href="lihatdata.php"><strong><i>Lihat Data </i></strong></a></p>
</form>
</body>
</html>
4. Langkah keempat kita buat insert.php untuk menambahkan data
<?php
include "koneksi.php";
$tanggal_daftar = date("Y-n-d");
$nama = $_POST['nama'];
$jenis_kelamin = $_POST['jenis_kelamin'];
$status = $_POST['status'];
$sekolah = $_POST['sekolah'];
$tahun_ajaran = $_POST['tahun_ajaran'];
$pekerjaan = $_POST['pekerjaan'];
$alamat = $_POST['alamat'];
$kelurahan = $_POST['kelurahan'];
$kecamatan = $_POST['kecamatan'];
$kota = $_POST['kota'];
$provinsi = $_POST['provinsi'];
$telepon = $_POST['telepon'];
$query_insert = "insert into tbl_daftar_mahasiswa(tanggal_daftar, nama_pendaftar, jns_kelamin, status, lulusan_sekolah,
tahun_ajaran, pekerjaan, alamat, kelurahan, kecamatan, kota, provinsi, telp)
values('$tanggal_daftar', '$nama', '$jenis_kelamin', '$status', '$sekolah',
'$tahun_ajaran', '$pekerjaan', '$alamat', '$kelurahan','$kecamatan', '$kota',
'$provinsi','$telepon');";
$insert = mysql_query($query_insert);
if($insert)
{
include("redirectview.php");
}
else
{
echo "Gagal update ... ";
echo "<META HTTP-EQUIV=Refresh CONTENT='2; URL=lihatdata.php'>";
}
?>
5. Langkah kelima kita buat file lihatdata.php guna untuk melihat semua data yang sudah di tambah
<?php
include "koneksi.php";
$select = "select * from tbl_daftar_mahasiswa order by id_daftar desc";
$select_query = mysql_query($select);
?>
<html>
<head>
<title>Lihat Data</title>
</head>
<body>
<table border="10" style="font-size:11px;font-family:'arial';text-align:center; border-radius: 20px;" border='1' width="80%" align='center' >
<caption><h1>Daftar Calon Mahasiswa Baru</h1></caption>
<tr><th>No</th><th>Tanggal</th><th>Nama</th><th>Jenis Kelamin</th><th>Status</th><th>Lulusan</th><th>Tahun</th>
<th>Pekerjaan</th><th>Alamat</th><th>Kelurahan</th><th>Kecamatan</th><th>Kota</th><th>Provinsi</th><th>Telepon</th>
<th>Pilihan</th></tr>
<?php
while($select_result = mysql_fetch_array($select_query))
{
$id = $select_result['id_daftar'] ;
$tanggaldaftar = $select_result['tanggal_daftar'] ;
$nama = $select_result['nama_pendaftar'] ;
$jeniskelamin = $select_result['jns_kelamin'] ;
$status = $select_result['status'] ;
$lulusan = $select_result['lulusan_sekolah'] ;
$tahunajaran = $select_result['tahun_ajaran'] ;
$pekerjaan = $select_result['pekerjaan'] ;
$alamat = $select_result['alamat'] ;
$kelurahan = $select_result['kelurahan'] ;
$kecamatan = $select_result['kecamatan'] ;
$kota = $select_result['kota'] ;
$provinsi = $select_result['provinsi'] ;
$telepon = $select_result['telp'] ;
echo "<tr><td>$id</td><td>$tanggaldaftar</td><td>$nama</td><td>$jeniskelamin</td><td>$status</td><td>$lulusan</td>
<td>$tahunajaran</td><td>$pekerjaan</td><td>$alamat</td><td>$kelurahan</td><td>$kecamatan</td><td>$kota</td>
<td>$provinsi</td><td>$telepon</td>
<td>
<form method=\"POST\" action=\"action.php?id=$id\"><input type=\"hidden\" value=\"$id\" name=\"id\">
<input type=\"submit\" name=\"action\" value=\"Update\"><br />
<input type=\"submit\" name=\"action\" value=\"Delete\">
</form>
</td>
</tr>";
}
?>
</table>
<center>
<p>
<input type="button" value="Input Data" onClick="window.location.href='index.html'">
</p>
<form name="form1" method="POST" action="cari.php">
<p>Masukan berdasarkan Nama siswa :
<input name="nama" type="text" id="nama">
<input type="submit" name="Submit" value="Cari">
</p>
</form></p>
</center></p>
</body>
</html>
6. Kita buat update.php
<?php
include "koneksi.php";
$id = $_POST['id'];
$tanggal_daftar = date("Y-n-d");
$nama = $_POST['nama'];
$jenis_kelamin = $_POST['jenis_kelamin'];
$status = $_POST['status'];
$sekolah = $_POST['sekolah'];
$tahun_ajaran = $_POST['tahun_ajaran'];
$pekerjaan = $_POST['pekerjaan'];
$alamat = $_POST['alamat'];
$kelurahan = $_POST['kelurahan'];
$kecamatan = $_POST['kecamatan'];
$kota = $_POST['kota'];
$provinsi = $_POST['provinsi'];
$telepon = $_POST['telepon'];
$query_update = "update tbl_daftar_mahasiswa set nama_pendaftar = '$nama', jns_kelamin = '$jenis_kelamin',
status = '$status', lulusan_sekolah = '$sekolah', tahun_ajaran = '$tahun_ajaran',
pekerjaan = '$pekerjaan', alamat = '$alamat', kelurahan = '$kelurahan', kecamatan = '$kecamatan',
kota = '$kota', provinsi = '$provinsi', telp = '$telepon'";
$update = mysql_query($query_update);
if($update)
{
include("redirectview.php");
}
else
{
echo "Gagal update ... ";
echo "<META HTTP-EQUIV=Refresh CONTENT='2; URL=lihatdata.php'>";
}
7. Kita buat action.php guna untuk mendelete atau update yang ada di lihatdata.php
<?php
include "koneksi.php";
$action = strtolower($_POST['action']);
$id = $_REQUEST['id'];
if ($action == "delete")
{
echo "Anda memilih aksi delete pada record $id... <br/>";
$delete = "delete from tbl_daftar_mahasiswa where id_daftar = '$id'";
$delete_query = mysql_query($delete);
if ($delete_query) echo "Record $id berhasil dihapus!<br><META HTTP-EQUIV=Refresh CONTENT='2; URL=lihatdata.php'>";
else echo "Gagal menghapus record<br><META HTTP-EQUIV=Refresh CONTENT='2; URL=lihatdata.php'>";
}
else
{
$select = "select * from tbl_daftar_mahasiswa where id_daftar = '$id'";
$select_query = mysql_query($select);
while($select_result = mysql_fetch_array($select_query))
{
$id = $select_result['id_daftar'] ;
$nama = $select_result['nama_pendaftar'] ;
$jeniskelamin = $select_result['jns_kelamin'] ;
$status = $select_result['status'] ;
$lulusan = $select_result['lulusan_sekolah'] ;
$tahunajaran = $select_result['tahun_ajaran'] ;
$pekerjaan = $select_result['pekerjaan'] ;
$alamat = $select_result['alamat'] ;
$kelurahan = $select_result['kelurahan'] ;
$kecamatan = $select_result['kecamatan'] ;
$kota = $select_result['kota'] ;
$provinsi = $select_result['provinsi'] ;
$telepon = $select_result['telp'] ;
?>
<form action="update.php" method="POST">
<table border='1' width='35%' cellpadding='2' cellspacing='2' align='center' bgcolor="#FFFFF">
<caption>
<h2>Edit Formulir Pendaftaran Mahasiswa Baru</h2>
</caption>
<input type="hidden" name="id" size="30" value="<?php echo $id ; ?>" maxlength="50"/>
<tr><td>Nama</td><td><input type="text" name="nama" value="<?php echo $nama ; ?>" size="30" maxlength="50"/></td></tr>
<tr><td>Jenis Kelamin</td><td><input type="radio" name="jenis_kelamin" value="pria"/><label for="jenis_kelamin">Pria</label>
<input type="radio" name="jenis_kelamin" value="wanita"/><label for="jenis_kelamin">Wanita</label>
</td></tr>
<tr><td>Status</td><td>
<select name="status">
<option value="Pilih Status Anda">Pilih Status Anda</option>
<option value="menikah">Menikah</option>
<option value="single">Single</option>
</select>
</td></tr>
<tr><td>Lulusan Sekolah</td><td><input type="text" name="sekolah" value="<?php echo $lulusan ; ?>" size="30" maxlength="50"/></td></tr>
<tr><td>Tahun Ajaran</td><td><select name="tahun_ajaran">
<option>Pilih Tahun Ajaran</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
<option value="2016">2016</option>
<option value="2017">2017</option>
<option value="2018">2018</option>
<option value="2019">2019</option>
<option value="2020">2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
</select></td></tr>
<tr><td>Pekerjaan</td><td><input type="text" name="pekerjaan" value="<?php echo $pekerjaan ; ?>" size="30" maxlength="50"/></td></tr>
<tr><td>Alamat</td><td><textarea name="alamat" cols="30" rows="4"><?php echo $alamat ; ?></textarea></td></tr>
<tr><td>Kelurahan</td><td><input type="text" name="kelurahan" value="<?php echo $kelurahan ; ?>" size="30" maxlength="50"/></td></tr>
<tr><td>Kecamatan</td><td><input type="text" name="kecamatan" value="<?php echo $kecamatan; ?>" size="30" maxlength="50"/></td></tr>
<tr><td>Kota</td><td><input type="text" name="kota" size="30" value="<?php echo $kota ; ?>" maxlength="50"/></td></tr>
<tr><td>Provinsi</td><td>
<select name="provinsi">
<option value="Pilih Provinsi Anda">Pilih Provinsi Anda</option>
<option value="Bali">Bali</option>
<option value="Bangka Belitung">Bangka Belitung</option>
<option value="Banten">Banten</option>
<option value="Bengkulu">Bengkulu</option>
<option value="Gorontalo">Gorontalo</option>
<option value="Irian Jaya Barat">Irian Jaya Barat</option>
<option value="Jabotabekdecipsawcib">Jabotabekdecipsawcib</option>
<option value="Jambi">Jambi</option>
<option value="Jawa Barat">Jawa Barat</option>
<option value="Jawa Tengah">Jawa Tengah</option>
<option value="Jawa Timur">Jawa Timur</option>
<option value="Kalimantan Barat">Kalimantan Barat</option>
<option value="Kalimantan Selatan">Kalimantan Selatan</option>
<option value="Kalimantan Tengah">Kalimantan Tengah</option>
<option value="Kalimantan Timur">Kalimantan Timur</option>
<option value="Kepulauan Riau">Kepulauan Riau</option>
<option value="Lampung">Lampung</option>
<option value="Lokasi Lain-lain">Lokasi Lain-lain</option>
<option value="Maluku">Maluku</option>
<option value="Maluku Utara">Maluku Utara</option>
<option value="Nangroe Aceh Darussalam">Nangroe Aceh Darussalam</option>
<option value="Nusa Tenggara Barat">Nusa Tenggara Barat</option>
<option value="Nusa Tenggara Timur">Nusa Tenggara Timur</option>
<option value="Papua">Papua</option>
<option value="Riau">Riau</option>
<option value="Sulawesi Barat">Sulawesi Barat</option>
<option value="Sulawesi Selatan">Sulawesi Selatan</option>
<option value="Sulawesi Tengah">Sulawesi Tengah</option>
<option value="Sulawesi Tenggara">Sulawesi Tenggara</option>
<option value="Sulawesi Utara">Sulawesi Utara</option>
<option value="Sumatera Barat">Sumatera Barat</option>
<option value="Sumatera Selatan">Sumatera Selatan</option>
<option value="Sumatera Utara">Sumatera Utara</option>
<option value="Yogyakarta">Yogyakarta</option>
</select></td></tr>
<tr><td>No Telepon</td><td><input type="text" name="telepon" size="30" value="<?php echo $telepon ; ?>" maxlength="50"/></td></tr>
<tr><td></td><td><input type="submit" name="kirim" value="Update!"/></td></tr>
</table>
</form>
<?php
}
}
?>
8. Kita buat cari.php
<title>Hasil Pencarian</title>
<?php
include "koneksi.php";
$nama=$_POST["nama"];
include("koneksi.php");
$select = "select * from tbl_daftar_mahasiswa order by id_daftar desc";
$select_query = mysql_query($select);
?>
<?php
while($select_result = mysql_fetch_array($select_query))
{
$id = $select_result['id_daftar'] ;
$tanggaldaftar = $select_result['tanggal_daftar'] ;
$nama = $select_result['nama_pendaftar'] ;
$jeniskelamin = $select_result['jns_kelamin'] ;
$status = $select_result['status'] ;
$lulusan = $select_result['lulusan_sekolah'] ;
$tahunajaran = $select_result['tahun_ajaran'] ;
$pekerjaan = $select_result['pekerjaan'] ;
$alamat = $select_result['alamat'] ;
$kelurahan = $select_result['kelurahan'] ;
$kecamatan = $select_result['kecamatan'] ;
$kota = $select_result['kota'] ;
$provinsi = $select_result['provinsi'] ;
$telepon = $select_result['telp'] ;
}
echo"
<form method=\"POST\" action=\"action.php?id=$id\">
<table border=\"1\" width=\"35%\" cellpadding=\"2\" cellspacing=\"2\" align=\"center\" bgcolor=\"#FFFFF\">
<caption>
<h2>Pencarian Data</h2>
</caption>
<tr>
<td>Nomor ID</td>
<td><input type=\"text\" name=\"nama2\" size=\"30\" disabled=\"disabled\" maxlength=\"50\" value=$id></td>
</tr>
<tr><td>Nama</td>
<td><input type=\"text\" name=\"nama\" size=\"30\" disabled=\"disabled\" maxlength=\"50\" value=$nama></td>
</tr>
<tr><td>Jenis Kelamin</td><td><input type=\"text\" disabled=\"disabled\" name=\"jns_kelamin\" size=\"30\" maxlength=\"50\" id=\"jns_kelamin\" value=$jeniskelamin></td></tr>
<tr><td>Status</td><td><input type=\"text\" name=\"status\" disabled=\"disabled\" size=\"30\" maxlength=\"50\" id=\"status\" value=$status></td></tr>
<tr><td>Lulusan Sekolah</td><td><input type=\"text\" disabled=\"disabled\" name=\"sekolah\" size=\"30\" maxlength=\"50\" value=$lulusan/</td></tr>
<tr><td>Tahun Ajaran</td><td><input type=\"text\" disabled=\"disabled\" name=\"tahun_ajaran\" size=\"30\" maxlength=\"50\" id=\"tahun_ajaran\" value=$tahunajaran></td></tr>
<tr><td>Pekerjaan</td><td><input type=\"text\" disabled=\"disabled\" name=\"pekerjaan\" size=\"30\" maxlength=\"50\" value=$pekerjaan></td></tr>
<tr><td>Alamat</td><td><textarea name=\"alamat\" disabled=\"disabled\" cols=\"30\" rows=\"4\">$alamat</textarea></td></tr>
<tr><td>Kelurahan</td>
<td><input type=\"text\" name=\"kelurahan\" disabled=\"disabled\" size=\"30\" maxlength=\"50\" value=$kelurahan></td>
</tr>
<tr><td>Kecamatan</td><td><input type=\"text\" disabled=\"disabled\" name=\"kecamatan\" size=\"30\" maxlength=\"50\" value=$kecamatan></td></tr>
<tr><td>Kota</td><td><input type=\"text\" disabled=\"disabled\" name=\"kota\" size=\"30\" maxlength=\"50\" value=$kota></td></tr>
<tr><td>Provinsi</td><td><input type=\"text\" disabled=\"disabled\" name=\"provinsi\" size=\"30\" maxlength=\"50\" value=$provinsi></td></tr>
<tr>
<td>No Telepon</td>
<td><input type=\"text\" disabled=\"disabled\" name=\"telepon2\" size=\"30\" maxlength=\"50\" value=$telp></td>
</tr>
<tr><td colspan=\"2\">
<div align=\"center\">
<input type=\"hidden\" value=\"$id\" name=\"id\">
<input type=\"submit\" name=\"action\" value=\"Update\">
<input type=\"submit\" name=\"action\" value=\"Delete\">
</div></td></tr>
</table>
</form>"
?>
<p><center><input type="button" value="Lihat Data" onClick="window.location.href='lihatdata.php'"> <input type="button" value="Input Data" onClick="window.location.href='index.html'">
</center></p>
9. Yang terakhir kita buat file redirectview.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml" lang="id"><head>
<title>Redirect Page</title>
<META HTTP-EQUIV=Refresh CONTENT='2; URL=lihatdata.php'>
<style type="text/css">
<!--
.style4 {font-size: 10px}
-->
* { margin: 0; padding: 0; }
body {
border-top-width: 30px;
border-top-style: solid;
font: 11px "Lucida Grande", Verdana, Arial, "Bitstream Vera Sans", sans-serif;
}
form {
margin-left: 8px;
padding: 16px 16px 40px 16px;
font-weight: normal;
-moz-border-radius: 11px;
-khtml-border-radius: 11px;
-webkit-border-radius: 11px;
border-radius: 5px;
background: #fff;
border: 1px solid #e5e5e5;
-moz-box-shadow: rgba(200,200,200,1) 0 4px 18px;
-webkit-box-shadow: rgba(200,200,200,1) 0 4px 18px;
-khtml-box-shadow: rgba(200,200,200,1) 0 4px 18px;
box-shadow: rgba(200,200,200,1) 0 4px 18px;
}
form .forgetmenot { font-weight: normal; float: left; margin-bottom: 0; }
#redirect form p {
margin-bottom: 0;
}
label {
color: #777;
font-size: 13px;
}
form .forgetmenot label {
font-size: 11px;
line-height: 19px;
}
form p { margin-bottom: 24px; }
#nav {
text-shadow: rgba(255,255,255,1) 0 1px 0;
}
#redirect { width: 320px; margin: 7em auto; }
#nav { margin: 0 0 0 8px; padding: 16px; }
</style>
</head>
<body class="login">
<div id="redirect" align="center">
<p class="message"><h2>UPDATE DATA BERHASIL!</h2></p>
<form name="loading" id="loading">
<p> </p>
<p><img src="loading.gif" alt="Loading" width="150" height="13" /></p>
<p> </p>
<p> <span class="style4">Loading...</span></p>
<p><span class="style4"><a href="lihatdata.php">Skip Preload</a></span></p>
<p><span class="style4">Tri Endar | 21107140</span></p>
<p>
<label></label>
</form>
</div>
</body>
</html>
0 komentar:
Posting Komentar