Free Programming Source Codes and Computer Programming Tutorials: Multi Level User Login And Registration System in PHP and MySQL

Here is a sample program that I wrote using PHP and MySQL that allows the user to login in different user levels or rules in the system. The code is very compatible with PHP 7 database connections and queries. I hope you will find my work useful. Thank you very much.

My email address are the following jakerpomperada@gmail.com and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

Sample Program Output

Program Listing

/* Written By: Mr. Jake Rodriguez Pomperada, MAED-IT */

/* Tools : PHP / MySQL */

/* May 4, 2017 Thursday */

/* jakerpomperada@yahoo.com and jakerpomperada@gmail.com */

connect.php

<?php

$username="root";

$password="";

$hostname = "localhost";

//connection string with database

$dbhandle = mysqli_connect($hostname, $username, $password)

or die("Unable to connect to MySQL");

echo "";

// connect with database

$selected = mysqli_select_db($dbhandle, "levels")

or die("Could not select examples");

index.php

<?php include("header.php"); ?>

<body>

<div class="panel-title">Login Security Page</div>

</div>

</div>

</div>

<input type="button" class="btn btn-success pull-right" style='margin-left:25px'

value="Register" title="Click here to register to the system." onclick="location.href = 'register.php';">

<span class="glyphicon glyphicon-check"></span> Login</button>

</div>

</form>

</div>

</div>

</body>

</html>

login_action.php

<?php

include("connect.php");

$tbl_name="user_levels";

$username=$_POST['username'];

$password=$_POST['password'];

$username = stripslashes($username);

$password = stripslashes($password);

$username = mysqli_real_escape_string($dbhandle,$username);

$password = mysqli_real_escape_string($dbhandle,$password);

$result = mysqli_query($dbhandle, "SELECT * FROM $tbl_name WHERE username='$username' AND password='$password'");

if(mysqli_num_rows($result) != 1){

echo "<script>alert(' Wrong Username or Password Access Denied !!! Try Again');

window.location='index.php';

</script>";

}else{

$row = mysqli_fetch_assoc($result);

if($row['userlevel'] == 1){

header('location: admin.php');

}else if($row['userlevel'] == 2 ){

header("Location: faculty.php");

}else if($row['userlevel'] == 3 ){

header("Location: student.php");

}

else if($row['userlevel'] == 4 ){

header("Location: staff.php");

}

else{

echo "<script>alert('Wrong Username or Password Access Denied !!! Try Again');

window.location='index.php';

</script>";

}

insert.php

<?php

include("connect.php");

$tbl_name="user_levels";

$username=$_POST['username'];

$password=$_POST['password'];

$user_level = $_POST['user_level'];

$result = mysqli_query($dbhandle, "INSERT INTO $tbl_name (username,password,userlevel) VALUES ('$username','$password','$user_level')");

if($result===TRUE)

{

echo "<script>alert('User Account has been saved in the database.');

window.location='index.php';

</script>";

}

else

{

echo"The query did not run";

}

mysqli_close($result);

<html>

<?php include("header.php"); ?>

<body>

<div class="panel-title">Registration Page</div>

</div>

</div>

</div>

</div>

<input type="button" class="btn btn-success pull-right" style='margin-left:25px' value="Cancel"

title="Click to return to main page." onclick="location.href = 'index.php';">

</div>

</form>

</div>

</div>

</html>

header.php

<?php include("connect.php"); ?>

<!DOCTYPE html>

<head>

<title>User - Levels</title>

</head>

admin.php

<html>

<head>

<title> Administrator Page </title>

<head>

<style>

body {

font-family:arial;

background-color : lightblue;

color:red;

};

</style>

Welcome To Administrator Page

</h1>

</body>

</html>

faculty.php

<html>

<head>

<title> Administrator Page </title>

<head>

<style>

body {

font-family:arial;

background-color : lightblue;

color:red;

};

</style>

Welcome To Administrator Page

</h1>

</body>

</html>

student.php

<html>

<head>

<title> Student Page </title>

<head>

<style>

body {

font-family:arial;

background-color : yellow;

color:blue;

};

</style>

Welcome To Student Page

</h1>

</body>

</html>

staff.php

<html>

<head>

<title> Staff Page </title>

<head>

<style>

body {

font-family:arial;

background-color : pink;

color:yellow;

};

</style>

Welcome To Staff Page

</h1>

</body>

</html>

user_levels.sql

-- phpMyAdmin SQL Dump

-- version 4.6.5.2

-- https://www.phpmyadmin.net/

-- Host: 127.0.0.1

-- Generation Time: May 03, 2017 at 01:52 PM

-- Server version: 10.1.21-MariaDB

-- PHP Version: 7.0.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `levels`

-- --------------------------------------------------------

-- Table structure for table `user_levels`

CREATE TABLE `user_levels` (

`id` int(11) NOT NULL,

`username` varchar(20) NOT NULL,

`password` varchar(20) NOT NULL,

`userlevel` varchar(20) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping data for table `user_levels`

INSERT INTO `user_levels` (`id`, `username`, `password`, `userlevel`) VALUES

(1, 'user1', 'user1', '1'),

(2, 'user2', 'user2', '2'),

(3, 'user3', 'user3', '3'),

(4, 'user4', 'user4', '4'),

(5, 'admin', 'admin', '1'),

(6, 'a', 'a', '1'),

(8, 'adam', 'adam', '2'),

(9, 'jake', 'jake', '3'),

(10, 'jacob', 'jacob', '2'),

(11, 'mark', 'mark', '4'),

(12, 'jose', 'jose', '2'),

(13, 'mario', 'mario', '2');

-- Indexes for dumped tables

-- Indexes for table `user_levels`

ALTER TABLE `user_levels`

ADD PRIMARY KEY (`id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `user_levels`

ALTER TABLE `user_levels`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

DOWNLOAD SOURCE CODE HERE

Free Programming Source Codes and Computer Programming Tutorials

Thursday, May 4, 2017

Multi Level User Login And Registration System in PHP and MySQL

22 comments: