1. Siapkan satu tabel. Disini tabel saya beri nama `login` dengan struktur `id` , `username` , `password` , `nama` , `keterangan` , 'level'.
2. Isi tabel `login` dengan beberapa row untuk proses pengecekan nanti.
3. Buat 1 halaman php baru dan pastekan kode di bawah ini
2. Isi tabel `login` dengan beberapa row untuk proses pengecekan nanti.
3. Buat 1 halaman php baru dan pastekan kode di bawah ini
exelogin.php
<?php
session_start();
include "koneksi.php";
// username dan password diambil dari form yang sudah di submit
$myusername=$_POST['username'];
$mypassword=$_POST['password'];
// MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
include "class.php";
$main= new ASKA();
$result= $main->select('login','username',"'$myusername' and password='$mypassword'",'no');
//menghitung data yang sudah diselect
$count=mysql_num_rows($result);
// jika username dan password ditemukan, maka $count harus bernilai 1
if($count==1){
// daftarkan data-data yang diperlukan
$id=mysql_fetch_row($result);
$getid=$id[0];
$getusername=$id[1];
$getpassword=$id[2];
$getnama=$id[3];
$getketerangan=$id[4];
$getlevel=$id[5];
session_register("getid");
session_register("getusername");
session_register("getpassword");
session_register("getnama");
session_register("getketerangan");
session_register("getlevel");
echo "<script>alert ('Login Berhasil');window.location='index.php';</script>";
}
else {
echo "<script>alert ('Login Anda Belum Terdaftar');history.go(-1);</script>";
}
?>
koneksi.php
koneksi.php
<?php
mysql_connect("localserver","username","password");mysql_select_db("database");
?>
class.php
<?php
class ASKA {<?php
function select($tabel, $field='', $value='', $orderby=''){
if($field !== ''){
$where = "where ".$field."=".$value." order by ".$orderby;
}
$query = "select * from ".$tabel." ".$where;
$sql= mysql_query($query) or die(mysql_error().'<br/>'.$query);
return $sql;
}
function selcount($tabel, $field='', $value='', $orderby=''){
$sql="select count(*) from `".$tabel."` where ".$field."=".$value;
$query=mysql_query($sql) or die(mysql_error().'<br/>'.$sql);
return $query;
}
function update($tabel, $field, $value='', $fwhere, $vwhere=''){
$sql="update ".$tabel." set ".$field."=".$value." where ".$fwhere."=".$vwhere;
$query=mysql_query($sql) or die(mysql_error().'<br/>'.$sql);
return $query;
}
function delete($tabel, $field, $vwhere=''){
$sql="delete from ".$tabel." where ".$field."=".$vwhere;
$query=mysql_query($sql) or die(mysql_error().'<br/>'.$sql);
return $query;
}
function insert($tabel, $field, $value){
$sql="insert into ".$tabel." (".$field.") value (".$value.")";
$query=mysql_query($sql) or die(mysql_error().'<br/>'.$sql);
return $query;
}
}
?>
formlogin.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">formlogin.php
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div align="center"><br />
<br />
</div>
<form id="demo" name="demo" method="post" action="exelogin.php">
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" class="borderall" >
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3" class="font"><strong>Login Member</strong></td>
</tr>
<tr>
<td width="78" class="font">Username</td>
<td width="6" class="font">:</td>
<td width="294" class="font"><input onfocus="this.className='yo';" onblur="this.className='yo1';" name="username" class="required" title="Harus Diisi" type="text" id="username" /></td>
</tr>
<tr>
<td class="font">Password</td>
<td class="font">:</td>
<td class="font"><input onfocus="this.className='yo';" onblur="this.className='yo1';" name="password" class="required" type="password" id="password" title="Harus Diisi" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login" /></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
class.css
.garismarquee { border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #F66D43; border-top-width: 1px; border-top-style: solid; border-top-color: #F66D43; }
.garisbatas { border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: #F66D43; }
.borderall { border: 1px solid #F66D43; }
.font { font-family: Arial; font-size: 13px; color:#000000; }
.fontmarquee { font-family: Arial; color:#000000; font-size: 11px; font-weight: bold; }
.font3 { font:normal 13px sans-serif; color:#FFFFFF; }
.fontsto { -moz-text-shadow: 3px 3px 3px #FFF; font:normal 13px "Courier New", Courier, monospace; font-weight:bolder; }
.fontdata { -moz-text-shadow: 3px 3px 3px #FFF; font:normal 13px sans-serif; }
.fontbest { font-family: Arial; font-size: 11px; color: #333333; }
.fontbest2 { font-family: Arial; font-size: 12px; color: #333333; }
.textfield2 { -moz-text-shadow: 3px 3px 3px #FFF; font:normal 12px sans-serif; text-align:center; }
.textfield3 { -moz-text-shadow: 3px 3px 3px #FFF; text-align:center; }
.textfield { -moz-text-shadow: 3px 3px 3px #FFF; font:normal 12px Arial; color:#FF0000; text-align:center; }
.warna { -moz-text-shadow: 3px 3px 3px #FFF; font:normal 13px sans-serif; color:#FFFFFF; background-color:#0099FF; }
.warna2 { -moz-text-shadow: 3px 3px 3px #FFF; font:normal 13px sans-serif; color:#FFFFFF; background-color:#FFFF00; }
.yo { -moz-border-radius: 5px; border: solid 2px #F66D43; background-color:#FFD8AE; }
.yo1 { -moz-border-radius: 5px; }
Kalau uda nyoba pasti gampang kan?! Copy dan paste semua file yang ada dan beri nama sesuai yang tertulis di atasnya. Oke, selamat mencoba dan semoga tambah pinter deh. Terima kasih.
0 komentar:
Posting Komentar