Multiple User
Tutor
Kali ini akan membahas tentang membuat multiple user menggunakan php tentunya
silahkan lhat tutornya untuk lebih lanjut.
1.
Langkah pertama buatlah data base di XAMPP
dengan nama Multiple_User, lalu buat tabelnya:
CREATE TABLE IF NOT EXISTS `user`
(
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(30) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`user_akses` enum('gratis','premium','admin') NOT NULL DEFAULT 'gratis',
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
2.
Lalu insert data tabel :
INSERT INTO `user` (`user_id`,
`email`, `username`, `password`, `user_akses`) VALUES
(1, 'photato91@gmail.com', 'Ari
Nugroho', '1234', 'admin'),
(2, 'enstein123@gmail.com',
'Albert Enstein', '1234', 'premium'),
(3, 'vitautami95@gmail.com',
'Vhieta Utami', '1234', 'gratis');
3.
Lalu buat css nya untuk style, beri nama style.css :
body{
font-family:sans-serif;
}
#kotak{
width:600px;
height:300px;
margin:50px auto;
padding:50px;
}
h1,h2{
text-align:center;
}
table tr td{
width:150px;
}
table tr td input , select{
width:420px;
height:30px;
font-size:12pt;
padding-left:10px;
}
4.
Setelah Mengurus Style buatfile dengan nama,
config.php.
<?php
mysql_connect("localhost","root","");
mysql_select_db('login');
?>
5.
Buat file lagi dengan nama, proses.php.
<?php
include 'config.php';
$uname=$_POST['uname'];
$pass=$_POST['pass'];
$sebagai=$_POST['sebagai'];
if($sebagai=='admin'){
$query=mysql_query("select *
from admin where uname_admin='$uname' and pass_admin='$pass'");
$cek=mysql_num_rows($query);
if($cek==1){
echo "berhasil login
admin";
}else{
echo "gagal login";
}
}else if($sebagai=='guru'){
$query=mysql_query("select *
from guru where uname_guru='$uname' and pass_guru='$pass'");
$cek=mysql_num_rows($query);
if($cek==1){
echo "berhasil login
guru";
}else{
echo "gagal login";
}
}else if($sebagai=='siswa'){
$query=mysql_query("select *
from siswa where uname_siswa='$uname' and pass_siswa='$pass'");
$cek=mysql_num_rows($query);
if($cek==1){
echo "berhasil login
siswa";
}else{
echo "gagal login";
}
}
?>
6.
Lalu buat index login beri nama, index.php.
<html>
<title>multi
user</title>
<head>
<link
rel="stylesheet" type="text/css"
href="css/style.css">
</head>
<body>
<h1>Halaman
Login</h1>
<div id="kotak">
<form
action="proses.php" method="post">
<table>
<tr>
<td>Username</td>
<td><input
type="text" name="uname"></td>
</tr>
<tr>
<td>Password</td>
<td><input
type="password" name="pass"></td>
</tr>
<tr>
<td>Login Sebagai</td>
<td>
<select
name="sebagai">
<option
value="admin">Admin</option>
<option
value="guru">Guru</option>
<option
value="siswa">Siswa</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input
type="submit" value="Login"></td>
</tr>
</table>
</form>
</div>
</body>
</html>
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.