Studi Kasus : Membuat Sistem Login Multi-User dengan PHP dan Mysql.
Kebutuhan : Paket Webserver (AppServ, XAMPP, EasyPHP, dll)
Step 1 : Menyiapkan Database
- Siapkan database dengan nama db_multiuser.
- Buat tabel dengan nama tb_user, buat dengan field – field seperti gambar berikut,
Struktur Tabel
- Insertkan beberapa sample data untuk tb_user.
INSERT INTO `db_multiuser`.`tb_user` (`id`, `username`, `password`, `tipe`) VALUES (NULL, 'ani', 'ani','admin'), (NULL, 'budi', 'budi', 'operator');
Step 2 :Membuat file konfigurasi
- Ketikkan script berikut,
<?php
$host = "localhost";
$user = "root"; //sesuaikan dengan user mysql anda
$pass = ""; //sesuaikan dengan password mysql anda
$dbName = "db_multiuser";
mysql_connect($host, $user, $pass);
mysql_select_db($dbName)
or die ("Koneksi Gagal : ".mysql_error());
?> - Simpan dengan nama connect.php
- Penjelasan : connect.php merupakan file konfigurasi yang akan menghubungkan sistem login yang kita buat dengan mysql database.
Step 3 :Membuat form login
- Ketikkan script berikut,
<center> <h2> <b> Login Page </b> <h2><form method="post" action="proses.php"><table border="0" align="center" cellpadding="5" cellspacing="8"><tr bgcolor="orange"> <td> UserName Anda ! </td> <td> <input name="username" type="text"> </td> </tr> <tr bgcolor="orange"> <td> Password ! </td> <td> <input name="password" type="password"> </td> </tr> <tr> <td> &nbsp; </td> <td> <input name="submit" type="submit" value="login"> </td> </tr> </table> </form> </center>
- Simpan dengan nama formlogin.php
- Script ini akan menampilkan form login untuk isian username dan password. Perhatikan bagian
action="proses.php". Ini menunjukkan bahwa isian dari username dan password akan diproses (diberi action) oleh file proses.php. File ini akan kita buat pada step berikutnya.
Step 4 :Membuat pemrosesan login
- Ketikkan script berikut,
<?php
session_start(); //memulai session
include "connect.php";//mengambil isian username dan password dari form
$username = $_POST['username'];
$password = $_POST['password'];
//query untuk mengambil data user dari database sesuai dengan username inputan form
$q = "SELECT * FROM tb_user WHERE username = '$username' ";
$result = mysql_query($q);
$data = mysql_fetch_array($result);
//cek kesesuaian password masukan dengan database
if ($password == $data['password']) {
//menyimpan tipe user dan username dalam session
$_SESSION['tipe'] = $data['tipe'];
$_SESSION['username'] = $data['username'];
include "menu.php";
}
//jika password tidak sesuai
else {
$warning = "Username / Password Salah";
echo $warning;
}
?> - Simpan dengan nama proses.php
Step 5 : Membuat tampilan khusus user
- Ketikkan script berikut,
<?php
session_start();
include "connect.php";
echo "<center>";
echo "<h3> Menu </h3>";
if ($_SESSION['tipe'] == "admin") {
echo " Anda Login sebagai Admin";
}
else if ($_SESSION['tipe'] == "user") {
echo " Anda Login sebagai User";
}
?> - Simpan dengan nama menu.php
- Penjelasan : Script ini akan menampilkan informasi sesuai dengan siapa user yang login.
Step 6 : Menjalankan Sistem Login
- Pergi ke http://localhost/
- Pilih file formlogin.php untuk mulai menjalankan aplikasi. Anda akan melihat tampilan seperti berikut,
Login Page
- Masukkan username = ani; password = ani
- Maka sistem akan menampilkan keterangan seperti berikut,
Admin Login
- Jika anda login sebagai operator (username : budi; password : budi), maka akan muncul informasi seperti gambar dibawah,
Operator Login
NB. Simpan semua file php dari step 2 – step 5 ke dalam SATU folder yang SAMA.
Okay, happy coding (:
Hal yang juga menarik:
Hak Cipta
Semua skrip dan teknik dalam artikel di itx.web.id boleh digunakan sebagaimana kehendakmu tanpa perlu mencantumkan sumber. Kamu tidak boleh mengkopi seluruh artikel, dalam Bahasa Indonesia ataupun diterjemahkan ke dalam bahasa lain.
This post is also available in: English
English 
Indonesia
Bermanfaat sekali…trims banyak
suksess teruss
Ameen. Makasih
sukses pak… kalo mau bikin form registernya gimana pak?
form register… maksudnya register user?
gini,
1. kamu bikin form buat inputan register user (field nya bisa username + password aja, atau ditambahin jg bisa,, tapi yang di database ditambahin juga brarti)
2. kamu bikin action untuk form tersebut, yang isi utama nya adalah query sql untuk insert data user baru tersebut ke dalam tb_user
btw the author is a girl
(lol) makanya dikasih gravatar biar yg nulis kliatan
ngasihnya gravatar gimana e mas? ngga nemu bagian yang ngubah gravatar di edit profile ku (tears)
weh. ya nggantinya gak di sini (eyeroll) . masuk gravatar dot com deh.
bozzz artikel multi login usersnya kok g kluar ya????
Wah, sayang sangat..
artikelnya gak keluar… ~,~
punya ku, begitu di klik login berhenti ke proses.php kenapa ya, tolong dong kirim ke sini jawabannya kiagusm@gmail.com
slamat mlm.. bisa minta bantuannya..? (wave)
klu log in buat 3 typical user (useer,admin,approver)..apa sama kayak contoh di atas..?
saya sangat butuh bantuannya..
sebelumnya makasih..
bisa dikirim ke email saya.? valentine.ivana@gmail.com
maaf mau nanya,adakah cara agar setelah user login,halaman login tidak bisa diakses kembali
agar user tidak login lagi karena sudah login (wave)
pak tolong diajarin mengenai function php untuk manipulasi data CRUD (Create, Read, Update, dan Delete data base terima kasih.)
(headspin) (headspin) Thanks yah gan..
(applause) thanks yah gan…. lam kenal
ko ga bisa gan
pak minta di postingin cara bikin script untuk admin donk.. makasih..:) (eyeroll) (eyeroll)
Gan, gmna kalo punya 2 user tapi cara editnya berbeda.. jadi user A cuma bisa edit yg dia posting , pas user B input, user A cuma bisa view. (bigeyes)
tolong ya gan secepatnya ? lagi butuh nih.. ane udah 2 minggu gak nemu” (angry)
gimana pak,kalau verifikasi usernya lebih dari dua tabel, misal adminya ceknya di tabel user, untuk user yang lain ambil dari tabel siswa atau dan guru
websitenya sangat membantu buat saya….
kalau boleh kak….
share dunk cara buat php and mysql tentang tiket kapal….
send ke email saya ya kak…..
ko’ ditinggalkan,,, gimn ini jdnya,, heee,
(banana_rock)
Thanx’s a lot bro…
very helping….
gan , gimana cara buat login dari dua tabel : admin & user , jika admin maka yang dieksekusi home admin, jika user maka yang dieksekusi home user dan pemanggilan lewat combo box
lapar…..
Mas mau tanya. sebelum sy membuat website ada beberapa hal yg ingin sy tanyakan.
1. bagaimana cara membuat tampilan awal di web sy nanti hanya ada menu
Log in
Pasword
Registrasi
Resend pasword
2. Ketika nanti ada orang log in mereka langsung masuk url http://xxxx.com/user.php?
3. Bagaimana cara membuat agar setelah mereka log in mereka hanya mengakses tampilan menu2 saja. Tidak masuk ke dasbord.
Maaf mas klo bisa lampirkan dengan gambar nya agar sy bisa lihat contoh nya juga. Dan tinggal ngikutin. Dan semoga pertanyaan sy ini bermanfaat juga buat teman2 lainnya. Trims
Mohon di balas lewat email juga ya mas. Biar bisa di print dan buat baca2 di rumah. Trims
bagaimana cara menu login yang menggunakan menu user dan admin
dear bos,..
sorry mw tanya,..bagaimana kalau misalkan nih,..ada user mw akses,.
dia kan pasti minta admin untuk dibuatkan akses dengan user name dan password.nah qt sebagai admin pasti mendaftarkan user tsb,.
tetapi saya maunya misalkan sudah saya daftarkan, ketika dia baru
pertama login,saya ingin dia dapat merubah passwordnya sendiri.
thanks mohon bantuannya
upstring
php script :
hy…….
cara membuat login yg menggunakan mysql
thx infonya
mau nanya donk…
saya udah buat aplikasinya
yang saya mau tanyakan
gimana dia ngelink sesuai aksesnya
kaya masuk ke index admin
THANK YOU SOOOO MUCH!!!
itu sangat membantu
Tuhan memberkati Anda
It’s the best time to make a few plans for the future and it is time to be happy. I’ve learn this post and if I could I wish to suggest you few interesting things or tips. Maybe you can write next articles relating to this article. I wish to learn more things about it!
Cool blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your design. With thanks
My brother suggested I may like this website. He was once totally right. This post actually made my day. You cann’t believe simply how much time I had spent for this info! Thank you!
It is perfect time to make some plans for the future and it’s time to be happy. I have learn this publish and if I may I want to recommend you some fascinating issues or advice. Maybe you could write next articles regarding this article. I desire to learn even more things about it!
Wow! At last I got a webpage from where I be able to genuinely take useful facts regarding my study and knowledge.
I enjoy, cause I discovered exactly what I used to be taking a look for. You have ended my 4 day long hunt! God Bless you man. Have a great day. Bye
Aw, this was an incredibly nice post. Finding the time and actual effort
to create a good article… but what can I say… I procrastinate a lot
and never seem to get anything done.
I do not know whether it’s just me or if perhaps everyone else experiencing issues with your site. It looks like some of the written text within your posts are running off the screen. Can somebody else please comment and let me know if this is happening to them too? This may be a issue with my browser because I’ve had this happen before. Kudos
Magnificent beat ! I wish to apprentice while you amend your web site, how could i subscribe for a blog web site? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept
Its such as you read my mind! You seem to understand so much approximately this, such as you wrote the e-book in it or something. I feel that you just can do with some p.c. to force the message house a little bit, however other than that, this is great blog. A fantastic read. I’ll certainly be back.
Simply want to say your article is as amazing. The clarity in your post is just great and i could assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep updated with forthcoming post. Thanks a million and please continue the gratifying work.
Whoa, superb blog site data format! Exactly how prolonged are you currently blogging and site-building intended for? you make posting look quick. The entire glimpse of this website is great, plus the information!
If when you fulfill these requirements then you might be worth availing short term loans in stress free way blue host a thorough research in the stiff online loan market helps you to obtain best loan deal in a best possible rate, without having done much struggle.
Attractive component of content. I just stumbled upon your weblog and in accession capital to assert that I get in fact loved account your weblog posts. Anyway I will be subscribing in your feeds and even I success you get right of entry to constantly fast.
Hello, its good post regarding media print, we all be familiar with media is a impressive source of facts.
Having read this I thought it was extremely informative. I appreciate you finding the time and energy to put this informative article together. I once again find myself spending way too much time both reading and commenting. But so what, it was still worthwhile!
Its not my first time to pay a quick visit this web page, i am browsing this site dailly and obtain fastidious information from here daily.
I was suggested this website by my cousin. I am no longer positive whether this submit is written by means of him as no one else recognise such specified about my problem. You’re incredible! Thank you!
It’s going to be finish of mine day, but before ending I am reading this great post to improve my knowledge.
I’m gone to convey my little brother, that he should also pay a quick visit this website on regular basis to obtain updated from newest information.
Every weekend i used to pay a quick visit this website, for the reason that i wish for enjoyment, for the reason that this this website conations in fact fastidious funny information too.
I rarely drop remarks, but after browsing a few of the comments here Login Multi-User dengan PHP dan Mysql. I actually do have some questions for you if you do not mind. Could it be only me or do a few of the responses look as if they are coming from brain dead folks?
And, if you are posting on other sites, I would like to keep up with you. Could you make a list of every one of your social sites like your Facebook page, twitter feed, or linkedin profile?
Hey would you mind letting me know which web host you’re utilizing? I’ve loaded your blog in 3 completely different browsers and I must say this blog loads a lot quicker then most. Can you suggest a good internet hosting provider at a reasonable price? Many thanks, I appreciate it!
It’s amazing for me to have a web site, which is good designed for my knowledge. thanks admin
Wszystko ty musi wiedziec o PLPD ubezpieczenie samochodu PLPD ubezpieczenie auta opisuje osoba odpowiedzialnosc (PL) i do domu uszkodzenie (PD) ubezpieczenie . PLPD plan ubezpieczenia wypelnia ich stan minimalna ilosc wymagania pracowac pojazd na drodze . To jest wazne do zapamietac , niemniej jednak , to robi nie zlozyc sie z wszechstronny albo nawet uderzenie pokrycie . PLPD ubezpieczenie samochodu jest zwykle doskonaly pasowac poniewaz osoby generowanie stary pojazd , ludzie z skrajnosc punkty pozwolenie , albo r
dzieki faktowi prowincjal / federalny opieka medyczna programy i duzo z pracodawca podania nigdy zapas pokrycie dla kazdego uprzejmy z opieka medyczna program , nabywajac uzupelniajacy pokrycie moze upewnic sie kompletny ochrona . na przyklad , wzrok plus dentystyczna troska ochrona sa typ formy z ubezpieczenie to moze nie musiec dostac sie zaoferowany . Osobisty medyczne ubezpieczenie zdrowia biznesy oferta taki plany od bardzo sensowny ceny . Mozesz wlasciwie przystosowac tw
Tak , chociaz mozesz dostac sie gl
Gdzie jestes zdolny do nabyc PLPD ubezpieczenie Auta ? Poniewaz z technologie i powiekszyc sie od internet zakupy dla taniego PLPD polityka ubezpieczenia nie jest nigdy mniej skomplikowany . Oceniajac tempa plus byl raz problem . To objety robiac duzo rozmowy telefoniczne i m
Co ty musi wiedziec dotyczac PLPD ubezpieczenie auta PLPD ubezpieczenie samochodu odniesie do szeregowiec odpowiedzialnosc (PL) i wlasnosc uszkodzenie (PD) pokrycie . PLPD polityka ubezpieczenia zaspokaja ich stan minimum specyfikacje dzialac samoch
powody, dlaczego Telefony komorkowe sluchawki telefonu komorkowego sklonic sie, by byc doskonaly przedsiebiorstwo alternatywa
Przedsiebiorstwo Bankowy rachunek Bardzo zly kredyt
Bedac pomyslny poniewaz korzystny ostatnie skutki, poniewaz przystosowany do srodowiska przemysl zony
My brother recommended I would possibly like this website. He was once entirely right. This publish actually made my day. You can not consider simply how much time I had spent for this info! Thank you!
No matter if some one searches for his necessary thing, therefore he/she wants to be available that in detail, therefore that thing is maintained over here.
What i don’t understood is actually how you’re not really much more smartly-favored than you might be now. You are so intelligent. You realize therefore significantly with regards to this subject, made me individually consider it from a lot of various angles. Its like women and men don’t seem to be fascinated except it is one thing to do with Girl gaga! Your personal stuffs outstanding. Always handle it up!
Hurrah! After all I got a website from where I be capable of really obtain helpful information concerning my study and knowledge.
viagra opis viagra sprawdza sie viagra efekty uboczne
These are in fact enormous ideas in on the topic of blogging. You have touched some pleasant factors here. Any way keep up wrinting.
What’s up to every body, it’s my first pay a quick visit of this webpage; this weblog carries amazing and really good material in support of readers.
I think what you wrote made a lot of sense. But, what about this? suppose you wrote a catchier title? I ain’t suggesting your content isn’t solid., however suppose you added a title to maybe get a person’s attention? I mean Login Multi-User dengan PHP dan Mysql is a little plain. You ought to look at Yahoo’s home page and see how they create news headlines to get viewers to click. You might add a video or a related pic or two to get readers excited about everything’ve got to say. Just my opinion, it could bring your posts a little bit more interesting.