Wednesday, May 6, 2015

Tutorial Membuat Form Daftar dengan PHP dan MYSQL



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">&nbsp;</td>
              <td align="left" valign="top">&nbsp;</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%">&nbsp;</td>
    <td width="100%" align="center"  class="menu"><span class="style1"><a href="index.php"></a>Info</span></td>
    <td width="0">&nbsp;</td>
  </tr>
  <tr>
    <td height="206">&nbsp;</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>&nbsp;</td>
  </tr>
</table>
</body>

Jika sudah jadi maka output pada proses_daftar.php sebagai berikut :
Referensi : 
http://www.bangpahmi.com/2014/07/cara-membuat-form-pendaftaran-anggota.html