[TUTORIAL ]- How to Make a multi-user Form-Login (Admin & User) with Php-Mysql

wen-ikhsan (43)in #utopian-io • 7 years ago (edited)

What Will I Learn?

You will learn how to create login form
You will be able to create a MySql database
You will be able to create the login permissions level of your website

Requirements

You have basic about PHP
You have basic about MySql
You have basic about HTML
You have basic about Javascript
To practice this tutorial you should have a XAMPP for webserver,text editor,and browser.

Difficulty

Intermediate

Tutorial Contents

Multi-user login is usually used in creating a web that can be accessed by many users. but not all users can access to the web system, therefore created multi-user for web users divided, such as an admin and a user, they have different access levels, then in this time I give a simple example of Tutorial How to Make a multi-user Form-Login (Admin & User) with Php-Mysql

Open phpmyadmin if use XAMPP to create database.

CREATE DATABASE level ;

Then create a table with the name login

CREATE TABLE login (
user varchar(20) NOT NULL,
nama varchar(40) NOT NULL,
password varchar(20) NOT NULL,
level varchar(15) NOT NULL
) ENGINE=MyISAM;

And Insert in the data. Example:

INSERT INTO login (user, nama, password, level)
VALUES('admin', '@Wen-Ikhsan', 'admin', 'Admin'),
('user1', 'jhoni', '12345', 'user');

Creating PHP FILE

Open a text editor, and create 6 file php;
File index.php
This file is used for login form page

<html>
<head>
<style type="text/css">
div#content-inner-login {
float:center;
padding:0px 0 15px 0;
margin:70px 50px 0 50px;
background-color:#FFF;
}
</style>
</head>
<body>
<center><div id="content-inner-login">
<form action="login.php?op=in" method="POST">
<table cellpadding="0" cellspacing="5" bgcolor="#456">
<tr height="36" bgcolor="#F8F8FF">
<th colspan="5">Cek Login</th>
</tr>
<tr>
<td>
<table>
<tr><br />
<td></td>
<td style="vertical-align: top">
Username : <input type="text" name="user" size="17"/><br />
Password &nbsp;: <input type="password" name="password" size="17"/><br /><br />
<input style="float:right" type="submit" value="LOGIN" /><br /></td>
</tr>
<tr height="10">
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</div>
</center>
</body>
</html

save program, and run index.html

Create file koneksi.php

This file serves to connect PHP files with MySQL database

    $Open = mysql_connect("localhost","root","");
        if (!$Open){
        die ("Koneksi ke Engine MySQL Gagal !<br>");
        }else{
        print ("Engine Connected<br>");
        }
    $Koneksi = mysql_select_db("login");
        if (!$Koneksi){
        die ("Koneksi ke Database Gagal !");
        }
        else{
        print ("Database Connected<br><br><br>");
        }
?>

Save Program

Create file login.php

This file serves to check login access by user level

<?php
session_start();
include "koneksi.php";
$user = $_POST['user'];
$password = $_POST['password'];
$op = $_GET['op'];

if($op=="in"){
    $sql = mysql_query("SELECT * FROM login WHERE user='$user' AND password='$password'");
    if(mysql_num_rows($sql)==1){//jika berhasil akan bernilai 1
        $qry = mysql_fetch_array($sql);
        $_SESSION['user'] = $qry['user'];
        $_SESSION['nama'] = $qry['nama'];
        $_SESSION['level'] = $qry['level'];
        if($qry['level']=="Admin"){
            header("location:home_admin.php");
        }else if($qry['level']=="user"){
            header("location:home_user.php");
        }
    }else{
        ?>
        <script language="JavaScript">
            alert('Username atau Password tidak sesuai. Silahkan diulang kembali!');
            document.location='index.php';
        </script>
        <?php
    }
}else if($op=="out"){
    unset($_SESSION['user']);
    unset($_SESSION['level']);
    header("location:index.php");
}
?>

Save program

File logout.php

This file is used to end a session or logout from page and go to page index.php

<?php
 session_start();
unset($_SESSION['user']);
unset($_SESSION['level']);
session_destroy();
header("Location:index.php");
?>

File home_admin.php
This file usually contains pages that are required admin website. Because this tutorial then I just make a simple page only

<?php
session_start();
//cek apakah user sudah login
if(!isset($_SESSION['user'])){
    die("Anda belum login");//jika belum login jangan lanjut
}
//cek level user
if($_SESSION['level']!="Admin"){
    die("Anda bukan admin");//jika bukan admin jangan lanjut
}
?>
<html>
<head>
<title>Cek_Login</title>
</head>
<body>
<br>
<h2>Welcome...!</h2> &nbsp;<br><font color="#456"><strong> <?=$_SESSION['nama']?></strong></font>&nbsp;||&nbsp;<a href="logout.php">Log Out&nbsp;&nbsp;</a></td>
    <td>&nbsp;</td>
</tr>
</body>
</html>

Save program

File home_user.php
It contains the user page

<?php
session_start();
//cek apakah user sudah login
if(!isset($_SESSION['user'])){
    die("Anda belum login");//jika belum login jangan lanjut
}
//cek level user
if($_SESSION['level']!="user"){
    die("You Not User..!");//jika bukan admin jangan lanjut
}
?>
<html>
<head>
<title>Cek_Login</title>
</head>
<body>
<br>
<h2>Hi...!</h2> &nbsp;<br><font color="#456"><strong> <?=$_SESSION['nama']?></strong></font>&nbsp;||&nbsp;<a href="logout.php">Log Out&nbsp;&nbsp;</a></td>
    <td>&nbsp;</td>
</tr>
</body>
</html>

Save Program

Test Program

Firstly, Run file index.php
And input user and admin password on the login form that has been made before in the database

If successful, then the page to home_admin.php

Logout from page.

Next, input username and password user in form login

It will go to the page home_user.php

If the file failed to login it will display a warning message, this hall because the username and password is not in the database

This message appears because the login file is given a javascript script that is:

<script language="JavaScript">
            alert('Username atau Password tidak sesuai. Silahkan diulang kembali!');
            document.location='index.php';
        </script>

--Thank you--

Curriculum

-How To Make Website: A Note of Goods using Php and Mysql

Posted on Utopian.io - Rewarding Open Source Contributors

#open-source #php #tutorial

7 years ago in #utopian-io by wen-ikhsan (43)

$25.26

Sort:

Trending

[-]

creon (56) 7 years ago

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

$1.71

2 votes

[-]

wen-ikhsan (43) 7 years ago

Thank you @creon

$0.00

[-]

utopian-io (71) 7 years ago

Hey @wen-ikhsan I am @utopian-io. I have just upvoted you!

Achievements

You have less than 500 followers. Just gave you a gift to help you succeed!
Seems like you contribute quite often. AMAZING!

Suggestions

Contribute more often to get higher and higher rewards. I wish to see you often!
Work on your followers to increase the votes/rewards. I follow what humans do and my vote is mainly based on that. Good luck!

Get Noticed!

Did you know project owners can manually vote with their own voting power or by voting power delegated to their projects? Ask the project owner to review your contributions!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

Vote for my Witness With SteemConnect
Proxy vote to Utopian Witness with SteemConnect
Or vote/proxy on Steemit Witnesses

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

$0.00