kita buat dulu databasenya, buka browser kesayangan teman dan ketik http://localhost/phpmyadmin
Jika sudah tekan tombol Simpan untuk meyimpan field yg telah kita isikan.
disini kita perlu beberapa file yg harus dibuat.
- koneksi.php
- index.php
- daftar.php
- prosesdaftar.php
- login.php
- proseslogin.php
- logut.php
<?php
$host = "localhost";
$user = "root";
$pass = "";
$db = "latihan";
$konek = mysql_connect($host, $user, $pass) or die ('Koneksi Gagal! ');
mysql_select_db($db);
?>
Setelah itu kita buat index.php file ini berfungsi untuk menampilkan ketika login berhasil, lihat kode berikut :
<?php
session_start();
if(!isset($_SESSION['username'])) {
header('location:login.php'); }
else { $username = $_SESSION['username']; }
require_once("koneksi.php");
$query = mysql_query("SELECT * FROM user WHERE username = '$username'");
$hasil = mysql_fetch_array($query);
?>
<html>
<head>
<title>Halaman Sukses Login</title>
</head>
<body>
<center>
<?php
echo "<h2>Selamat Datang, $username </h2>";
?>
<a href="logout.php"><b>Logout</a>
</center>
</body>
</html>
setelah itu kita buat halaman pendaftaran yaitu daftar.php, lihat kode berikut :
<?php
session_start();
if(isset($_SESSION['username'])) {
header('location:index.php'); }
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Form Pendaftaran</title>
<link rel="stylesheet" type="text/css" href="form_style.css" />
</head>
<body>
<div id="form-login">
<form action="prosesdaftar.php" method="post">
<tr>
<td colspan="2" align="center"><h1>Buat Akun</h1></td>
</tr>
<label>Username </label> <input name="username" type="text" id="username" size="30" maxlength="20" class="txt" /><br />
<label>Password </label> <input name="password" type="password" id="password" size="30" maxlength="20" class="txt" /><br />
<label>Tanggal Lahir </label>
<select name=tgl id=tgl>
<option value=0>Tanggal:</option>
<option value=1>1</option>
<option value=2>2</option>
<option value=3>3</option>
<option value=4>4</option>
<option value=5>5</option>
<option value=6>6</option>
<option value=7>7</option>
<option value=8>8</option>
<option value=9>9</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>
<select name=bulan id=bulan>
<option value=0>Bulan:</option>
<option value=1>Jan</option>
<option value=2>Feb</option>
<option value=3>Mar</option>
<option value=4>Apr</option>
<option value=5>Mei</option>
<option value=6>Jun</option>
<option value=7>Jul</option>
<option value=8>Agt</option>
<option value=9>Sep</option>
<option value=10>Okt</option>
<option value=11>Nov</option>
<option value=12>Des</option>
</select>
<select name=tahun id=tahun>
<option value=0>Tahun:</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>2013</option>
<option value=2014>2013</option>
</select>
<label>Jenis Kelamin </label>
<select name="gender" id="gender">
<option value="0">Pilih Jenis Kelamin : </option>
<option value="1">Laki-Laki</option>
<option value="2">Perempuan</option>
<option value="3">Belum Jelas</option>
</select>
<br/>
<div id="tombol"><td colspan="2" align="center"><input name="Submit" type="submit" value="Daftar" class="button" /></td></div>
<br/>
<tr>
<td colspan="2" align="center">Sudah Punya Akun? <a rel="nofollow" href="login.php">Masuk Sekarang</a></td>
</tr>
</form>
</div>
</body>
</html>
namun agar kita bisa terdaftar kita perlu membuat prosesdaftar.php, lihat kode berikut :
<?php
require_once("koneksi.php");
$username = $_POST['username'];
$pass = $_POST['password'];
$cekuser = mysql_query("SELECT * FROM user WHERE username = '$username'");
if(mysql_num_rows($cekuser) <> 0) {
echo "Username Sudah Terdaftar!<br/>";
echo "<a href='daftar.php'>&amp;laquo; Back</a>";
} else {
if(!$username || !$pass) {
echo "Masih ada data yang kosong!<br/>";
echo "<a href='daftar.php'>&amp;laquo; Back</a>";
} else {
$simpan = mysql_query("INSERT INTO user(username, password) VALUES('$username','$pass')");
if($simpan) {
echo "Pendaftaran Sukses, Silahkan <a href='login.php'>Login</a>";
} else {
echo "Proses Gagal!";
}
}
}
?>
setelah itu kita membuat halaman loginya yaitu login.php, lihat kode berikut :
<?php
session_start();
if(isset($_SESSION['username'])) {
header('location:index.php'); }
require_once("koneksi.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Form Login</title>
<link rel="stylesheet" type="text/css" href="form_style.css" />
</head>
<body>
<center>
<div id="form-login">
<form action="proseslogin.php" method="post">
<tr><td colspan="2" align="center"><h1>Login Member</h1></td></tr>
<label>Username </label> : <input name="username" type="text" id="username" size="20" maxlength="20" class="txt" /><br />
<label>Password </label> : <input name="password" type="password" id="password" size="20" maxlength="20" class="txt" />
<div id="tombol">
<input name="btnLogin" type="submit" value="Login" class="button" />
<input name="btnLogin" type="reset" value="Reset" class="button" />
</div>
<tr><td colspan="2" align="left">Belum Punya akun ? <a href="daftar.php"><b>Daftar</b></a></td></tr>
</form>
</div>
</center>
</body>
</html>
namun agar kita bisa login kita harus membuat proseslogin.php, lihat kode berikut :
<?php
session_start();
require_once("koneksi.php");
$username = $_POST['username'];
$pass = $_POST['password'];
$cekuser = mysql_query("SELECT * FROM user WHERE username = '$username'");
$jumlah = mysql_num_rows($cekuser);
$hasil = mysql_fetch_array($cekuser);
if($jumlah == 0) {
echo "Username Belum Terdaftar!<br/>";
echo "<a href='login.php'>&amp;laquo; Back</a>";
} else {
if($pass <> $hasil['password']) {
echo "Password Salah!<br/>";
echo "<a href='login.php'>&amp;laquo; Back</a>";
} else {
$_SESSION['username'] = $hasil['username'];
header('location:index.php');
}
}
?>
terakhir kita tinggal membuat logout.php, lihat kode berikut :
<?php
session_start();
unset($_SESSION['username']);
?>
<center>
<h2>Anda telah berhasil logout..</h2>
Silahkan klik <b>disini</b> untuk login kembali
</center>
Semoga Bermanfaat

