Langkah2 membuat Form Pendaftaran dengan PHP dan MySql
1.
Tahap 1 membuat form pendaftaran dengan koding
PHP berikut langkah-langkahnya :
Save dengan nama daftar.php
<?php
include "koneksi.php";
?>
<html>
<head>
</head>
<body>
<form action="proses_daftar.php" method="post"
enctype="multipart/form-data" name="form1"
id="form1">
<table width="100%" border="0"
align="center" cellpadding="3"
cellspacing="0">
<tr>
<td height="30"
colspan="3" align="left" valign="bottom"
scope="col"><table width="100%" height="30"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr></tr>
</tbody>
</table> </td>
</tr>
<tr>
<td height="25"
colspan="3" align="left" valign="bottom"
class="artiketl" scope="col"><span
class="hohohohoho"><strong>Contoh Form
Daftar</strong></span> </td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl"
scope="col">Nomor KTP</td>
<td align="left"
valign="top"
scope="col"><strong>:</strong></td>
<td align="left"
valign="top" scope="col"><input name="ktp"
required class="font_formulir" type="text"
id="username7" size="30"
maxlength="30"></td>
</tr>
<tr>
<td width="13%"
align="left" valign="top" class="artiketl"
scope="col">Nama Lengkap </td>
<td width="1%"
align="left" valign="top"
scope="col"><strong>:</strong></td>
<td width="86%"
align="left" valign="top"
scope="col"><input name="nama" required
class="font_formulir" type="text" id="username2"
size="55" maxlength="55"></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Alamat</td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><textarea name="alamat" required
class="font_formulir"alamat"
cols="35"></textarea></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Tempat Lahir </td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><input name="tempat"
type="text" required class="font_formulir"
id="username3" size="30"
maxlength="30"></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Tanggal Lahir</td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><span class="font_formulir">
<select
name="tgl"
id="tgl">
<option value="-
Pilih Tanggal -">- Pilih Tanggal -</option>
<option
value="01">01</option>
<option
value="02">02</option>
<option
value="03">03</option>
<option
value="04">04</option>
<option
value="05">05</option>
<option
value="06">06</option>
<option
value="07">07</option>
<option
value="08">08</option>
<option
value="09">09</option>
<option
value="10">10</option>
<option
value="11">11</option>
<option
value="12">12</option>
<option
value="13">13</option>
<option
value="14">14</option>
<option
value="15">15</option>
<option
value="16">16</option>
<option value="17">17</option>
<option
value="18">18</option>
<option
value="19">19</option>
<option
value="20">20</option>
<option
value="21">21</option>
<option
value="22">22</option>
<option
value="23">23</option>
<option
value="24">24</option>
<option
value="25">25</option>
<option
value="26">26</option>
<option
value="27">27</option>
<option
value="28">28</option>
<option
value="29">29</option>
<option
value="30">30</option>
<option
value="31">31</option>
</select>
</span> - <span class="font_formulir">
<select name="bln"
id="bln">
<option value="-
Pilih Bulan -">- Pilih Bulan -</option>
<option
value="Januari">Januari</option>
<option
value="Februari">Februari</option>
<option
value="Maret">Maret</option>
<option
value="April">April</option>
<option
value="Mei">Mei</option>
<option
value="Juni">Juni</option>
<option value="Juli">Juli</option>
<option
value="Agustus">Agustus</option>
<option
value="September">September</option>
<option
value="Oktober">Oktober</option>
<option
value="November">November</option>
<option
value="Desember">Desember</option>
</select>
</span> - <span
class="font_formulir">
<select name="thn"
id="thn">
<option value="-
Pilih Tahun -">- Pilih Tahun -</option>
<option
value="1901">1901</option>
<option
value="1902">1902</option>
<option
value="1903">1903</option>
<option
value="1904">1904</option>
<option value="1905">1905</option>
<option
value="1906">1906</option>
<option
value="1907">1907</option>
<option
value="1908">1908</option>
<option
value="1909">1909</option>
<option
value="1910">1910</option>
<option
value="1911">1911</option>
<option
value="1912">1912</option>
<option
value="1913">1913</option>
<option
value="1914">1914</option>
<option
value="1915">1915</option>
<option
value="1916">1916</option>
<option
value="1917">1917</option>
<option
value="1918">1918</option>
<option value="1919">1919</option>
<option
value="1920">1920</option>
<option
value="1921">1921</option>
<option
value="1922">1922</option>
<option
value="1923">1923</option>
<option value="1924">1924</option>
<option
value="1925">1925</option>
<option
value="1926">1926</option>
<option
value="1927">1927</option>
<option
value="1928">1928</option>
<option
value="1929">1929</option>
<option
value="1930">1930</option>
<option
value="1931">1931</option>
<option
value="1932">1932</option>
<option
value="1933">1933</option>
<option
value="1934">1934</option>
<option
value="1935">1935</option>
<option
value="1936">1936</option>
<option
value="1937">1937</option>
<option
value="1938">1938</option>
<option
value="1939">1939</option>
<option
value="1940">1940</option>
<option
value="1941">1941</option>
<option
value="1942">1942</option>
<option
value="1943">1943</option>
<option
value="1944">1944</option>
<option
value="1945">1945</option>
<option
value="1946">1946</option>
<option value="1947">1947</option>
<option
value="1948">1948</option>
<option
value="1949">1949</option>
<option
value="1950">1950</option>
<option
value="1951">1951</option>
<option value="1952">1952</option>
<option
value="1953">1953</option>
<option
value="1954">1954</option>
<option
value="1955">1955</option>
<option
value="1956">1956</option>
<option
value="1957">1957</option>
<option
value="1958">1958</option>
<option
value="1959">1959</option>
<option
value="1960">1960</option>
<option
value="1961">1961</option>
<option
value="1962">1962</option>
<option
value="1963">1963</option>
<option
value="1964">1964</option>
<option
value="1965">1965</option>
<option
value="1966">1966</option>
<option
value="1967">1967</option>
<option
value="1968">1968</option>
<option
value="1969">1969</option>
<option
value="1970">1970</option>
<option
value="1971">1971</option>
<option
value="1972">1972</option>
<option
value="1973">1973</option>
<option
value="1974">1974</option>
<option value="1975">1975</option>
<option
value="1976">1976</option>
<option
value="1977">1977</option>
<option
value="1978">1978</option>
<option
value="1979">1979</option>
<option value="1980">1980</option>
<option
value="1981">1981</option>
<option
value="1982">1982</option>
<option
value="1983">1983</option>
<option
value="1984">1984</option>
<option
value="1985">1985</option>
<option
value="1986">1986</option>
<option
value="1987">1987</option>
<option
value="1988">1988</option>
<option
value="1989">1989</option>
<option
value="1990">1990</option>
<option
value="1991">1991</option>
<option
value="1992">1992</option>
<option
value="1993">1993</option>
<option
value="1994">1994</option>
<option
value="1995">1995</option>
<option
value="1996">1996</option>
<option
value="1997">1997</option>
<option
value="1998">1998</option>
<option
value="1999">1999</option>
<option
value="2000">2000</option>
<option
value="2001">2001</option>
<option
value="2002">2002</option>
<option value="2003">2003</option>
<option
value="2004">2004</option>
<option
value="2005">2005</option>
<option
value="2006">2006</option>
<option
value="2007">2007</option>
<option value="2008">2008</option>
<option
value="2009">2009</option>
<option
value="2010">2010</option>
<option
value="2011">2011</option>
<option
value="2012">2012</option>
<option
value="2013">2012</option>
</select>
</span></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Warga Negara </td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><input name="wn" required
class="font_formulir" type="text" id="username4"
size="30" maxlength="30"></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Jenis Kelamin </td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top">
<input name="jk"
type="radio" class="font_formulir"
value="Laki-Laki" />
<span
class="artiketl"> Laki-laki</span>
<input name="jk"
type="radio" class="font_formulir"
value="Perempuan" />
<span
class="artiketl">
Perempuan </span></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Agama</td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><span class="sdsd">
<select name="agama"
class="font_formulir" id="agama">
<option value="-
Pilih Salah Satu -" selected="selected">- Pilih Salah Satu
-</option>
<option
value="Islam">Islam</option>
<option
value="Hindu">Hindu</option>
<option
value="Budha">Budha</option>
<option
value="Katholik">Katholik</option>
<option
value="Protestan">Protestan</option>
<option value="Kong
Khu Chu">Kong Khu Chu</option>
</select>
</span></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Telepon</td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left" valign="top"><input
name="telp" required class="font_formulir"
type="text" id="username9" size="30"
maxlength="30"></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Handphone</td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><input name="hp" required
class="font_formulir" type="text" id="username8"
size="30" maxlength="30"></td>
</tr>
<tr>
<td align="left"
valign="top" class="artiketl">Email</td>
<td align="left"
valign="top"><strong>:</strong></td>
<td align="left"
valign="top"><input name="email" required
class="font_formulir" type="text" id="username6"
size="30" maxlength="30"></td>
</tr>
<tr>
<td colspan="3"
align="left" valign="top"
class="artiketl"><hr /></td>
</tr>
<tr>
<td align="left"
valign="top"> </td>
<td align="left"
valign="top"> </td>
<td align="left"
valign="top"><input name="daftar"
type="submit" id="daftar" value="Daftar" />
<input name="batal"
type="reset" id="batal" value="Batal"
/></td>
</tr>
</table>
</form>
</body>
</html></td>
</tr>
</table></center>
Tampilannya sebagai berikut :
2.
Langkah selanjutnya buat koneksi. Save dengan
koneksi.php
<?php
mysql_connect('localhost','root','');
mysql_select_db('db_daftar') or die
(mysql_error());
?>
3.
Kemudian Buat database di MySql dengan nama database
“db_DAFTAR”
Kemudian buat nama tabel dengan “tbl_daftar”
4.
Setelah itu untuk menampilkan proses daftar
diweb bisa dilakukan dengan membuat proses_daftar.php
<?php include "koneksi.php";
$ktp=$_POST['ktp'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$telepon=$_POST['telp'];
$hp=$_POST['hp'];
$ttl=$_POST['tempat'].",
".$_POST['tgl']."-".$_POST['bln']."-".$_POST['thn'];
$wn=$_POST['wn'];
$jk=$_POST['jk'];
$agama=$_POST['agama'];
$email=$_POST['email'];
$daftar=$_POST['daftar'];
if($daftar){
$sql=mysql_query("INSERT INTO
tbl_daftar(pembeli_no_ktp ,pembeli_nama, pembeli_alamat, pembeli_telepon,
pembeli_hp, ttl, warga_negara, jenis_kelamin, agama, email) VALUES ('$ktp',
'$nama', '$alamat', '$telepon', '$hp', '$ttl', '$wn', '$jk', '$agama', '$email')");
if(!$sql){
echo mysql_error();
}
}else{
echo
"Gagal Mendaftarkan.";
}
?>
<html>
<head>
<title>FormDaftar</title>
<body>
<table width="100%"
border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="3%"> </td>
<td width="100%" align="center" class="menu"><span
class="style1"><a
href="index.php"></a>Info</span></td>
<td width="0"> </td>
</tr>
<tr>
<td height="206"> </td>
<td><table width="100%" border="0"
cellpadding="0" cellspacing="2" >
<tr>
<td height="18" colspan="3"
valign="top" class="ababababab"><hr />
<hr /></td>
</tr>
<tr>
<td width="4" height="18" valign="top"
class="ababababab"><a
href="index.php"></a>Nomor KTP</td>
<td valign="top"
class="ababababab"><strong>:</strong></td>
<td valign="top" class="ababababab"><?=$ktp
?></td>
</tr>
<tr>
<td height="18" valign="top"
class="ababababab"><a
href="index.php"></a>Nama</td>
<td width="0" valign="top"
class="ababababab"><strong>:</strong></td>
<td width="89%" valign="top"
class="ababababab"><?=$nama ?></td>
</tr>
<tr>
<td height="18" valign="top"
class="ababababab">Telepon</td>
<td valign="top" class="ababababab"><strong>:</strong></td>
<td valign="top"
class="ababababab"><?=$telepon ?></td>
</tr>
<tr>
<td height="18" valign="top"
class="ababababab">HP</td>
<td valign="top"
class="ababababab"><strong>:</strong></td>
<td valign="top" class="ababababab"><?=$hp
?></td>
</tr>
<tr>
<td height="18" valign="top"
class="ababababab">TTL</td>
<td width="0%" valign="top"
class="ababababab"><strong>:</strong></td>
<td width="89%" valign="top"
class="ababababab"><?=$ttl ?> </td>
</tr>
<tr>
<td height="18" valign="top"
class="ababababab">Jenis Kelamin </td>
<td width="0%" valign="top"
class="ababababab"><strong>:</strong></td>
<td width="89%" valign="top"
class="ababababab"><?=$jk ?></td>
</tr>
<tr>
<td height="18" valign="top"
class="ababababab">Alamat</td>
<td valign="top"
class="ababababab"><strong>:</strong></td>
<td valign="top" class="ababababab"><?=$alamat
?></td>
</tr>
<tr>
<td colspan="4" align="center"><hr
/></td>
</tr>
<tr>
<td height="57" colspan="4"
align="center"><p align="center">Data telah
terkirim. <br>
Terima kasih karena anda telah mendaftar by Deny Pratama 11111867.<br
/>
<a
href="index.php?hal=login_user.php"><blink></blink></a></p> </td>
</tr>
</table></td>
<td> </td>
</tr>
</table>
</body>
REFRENSI :
http://www.bangpahmi.com/2014/07/cara-membuat-form-pendaftaran-anggota.html
http://carideny.blogspot.com/
Tidak ada komentar:
Posting Komentar