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/