Login and Registration Using OOP with MySQLi

First of all create a database & create a table with the name ‘users’.

CREATE TABLE users
(
uid INT PRIMARY KEY AUTO_INCREMENT,
uname VARCHAR(30) UNIQUE,
upass VARCHAR(50),
fullname VARCHAR(100),
uemail VARCHAR(70) UNIQUE
);

Now as we’ve created our database it’s time for some coding. First we need to get our database in php coding. Create a file named db_config and put the below code in there.

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'oop');

As we can see in the above code we’ve created a class called db_con & in there we’ve defined our db name, user & password.

Now it’s time for the database to get to work. Create a file named class.user.php & put the below listed code:

include "db_config.php";

	class User{

		public $db;

		public function __construct(){
			$this->db = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

			if(mysqli_connect_errno()) {
				echo "Error: Could not connect to database.";
			        exit;
			}
		}

		/*** for registration process ***/
		public function reg_user($name,$username,$password,$email){

			$password = md5($password);
			$sql="SELECT * FROM users WHERE uname='$username' OR uemail='$email'";

			//checking if the username or email is available in db
			$check =  $this->db->query($sql) ;
			$count_row = $check->num_rows;

			//if the username is not in db then insert to the table
			if ($count_row == 0){
				$sql1="INSERT INTO users SET uname='$username', upass='$password', fullname='$name', uemail='$email'";
				$result = mysqli_query($this->db,$sql1) or die(mysqli_connect_errno()."Data cannot inserted");
        		return $result;
			}
			else { return false;}
		}

		/*** for login process ***/
		public function check_login($emailusername, $password){

        	$password = md5($password);
			$sql2="SELECT uid from users WHERE uemail='$emailusername' or uname='$emailusername' and upass='$password'";

			//checking if the username is available in the table
        	$result = mysqli_query($this->db,$sql2);
        	$user_data = mysqli_fetch_array($result);
        	$count_row = $result->num_rows;

	        if ($count_row == 1) {
	            // this login var will use for the session thing
	            $_SESSION['login'] = true;
	            $_SESSION['uid'] = $user_data['uid'];
	            return true;
	        }
	        else{
			    return false;
			}
    	}

    	/*** for showing the username or fullname ***/
    	public function get_fullname($uid){
    		$sql3="SELECT fullname FROM users WHERE uid = $uid";
	        $result = mysqli_query($this->db,$sql3);
	        $user_data = mysqli_fetch_array($result);
	        echo $user_data['fullname'];
    	}

    	/*** starting the session ***/
	    public function get_session(){
	        return $_SESSION['login'];
	    }

	    public function user_logout() {
	        $_SESSION['login'] = FALSE;
	        session_destroy();
	    }

	}

I’ve quoted every single line with commenting that which line doing what & which function is using for what. As we can see first of all we’ve included the db connection so that we can have the connection while calling the db connection through a object in constructor.

For the registration process we are first encrypting the password with “md5 hashing” & then searching that if there is any username there in the db already by querying it & if the row is empty then we’re heading to insert the data in database.

For the login process we’re searching for the username & password given by the user & then if it returns true than we’re giving a flag with $_SESSION[‘login’] = true so that when anyone tries to visit the other pages without login we can use this flag stop them.

Then there is a function to get the fullname of the user & after that we’re starting the session & checking that if the user is logged in or not by the get_session() function.

Now the main part are closed it’s time for to generate forms to user. Create a file named login.php & in the very first section put these php code into the file from below:

session_start();
	include_once 'include/class.user.php';
	$user = new User();

	if (isset($_REQUEST['submit'])) {
		extract($_REQUEST);
	    $login = $user->check_login($emailusername, $password);
	    if ($login) {
	        // Registration Success
	       header("location:home.php");
	    } else {
	        // Registration Failed
	        echo 'Wrong username or password';
	    }
	}

Now put the html work just after the php content you’ve putted in the file.

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
OOP Login Module
<style><!--
            #container{width:400px; margin: 0 auto;}

--></style>

<script type="text/javascript" language="javascript">

            function submitlogin() {
                var form = document.login;
				if(form.emailusername.value == ""){
					alert( "Enter email or username." );
					return false;
				}
				else if(form.password.value == ""){
					alert( "Enter password." );
					return false;
				}
			}

</script>

<span style="font-family: 'Courier 10 Pitch', Courier, monospace; font-size: 13px; font-style: normal; line-height: 1.5;"><div id="container"></span>
<h1>Login Here</h1>
<form action="" method="post" name="login">
<table>
<tbody>
<tr>
<th>UserName or Email:</th>
<td><input type="text" name="emailusername" required="" /></td>
</tr>
<tr>
<th>Password:</th>
<td><input type="password" name="password" required="" /></td>
</tr>
<tr>
<td></td>
<td><input onclick="return(submitlogin());" type="submit" name="submit" value="Login" /></td>
</tr>
<tr>
<td></td>
<td><a href="registration.php">Register new user</a></td>
</tr>
</tbody>
</table>
</form></div>

In this form we’re having some validation for the form. Now above the code we’ve included the user class file so that we can have access to that user  class. We’ve created a object for the user class & checking that if the submit button pressed than calling the check_login() function to log the user.

Now it’s time for the registration page. Create a file named registration.php & paste the code below in the very first section:

include_once 'include/class.user.php';  $user = new User(); // Checking for user logged in or not

 if (isset($_REQUEST['submit'])){
 extract($_REQUEST);
 $register = $user->reg_user($fullname, $uname,$upass, $uemail);
 if ($register) {
 // Registration Success
 echo 'Registration successful <a href="login.php">Click here</a> to login';
 } else {
 // Registration Failed
 echo 'Registration failed. Email or Username already exits please try again';
 }
 }

Then go & post the code below right after your php code.

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />

Register
<style><!--
 #container{width:400px; margin: 0 auto;}
--></style>

<script type="text/javascript" language="javascript">
 function submitreg() {
 var form = document.reg;
 if(form.name.value == ""){
 alert( "Enter name." );
 return false;
 }
 else if(form.uname.value == ""){
 alert( "Enter username." );
 return false;
 }
 else if(form.upass.value == ""){
 alert( "Enter password." );
 return false;
 }
 else if(form.uemail.value == ""){
 alert( "Enter email." );
 return false;
 }
 }
</script>
<div id="container">
<h1>Registration Here</h1>
<form action="" method="post" name="reg">
<table>
<tbody>
<tr>
<th>Full Name:</th>
<td><input type="text" name="fullname" required="" /></td>
</tr>
<tr>
<th>User Name:</th>
<td><input type="text" name="uname" required="" /></td>
</tr>
<tr>
<th>Email:</th>
<td><input type="text" name="uemail" required="" /></td>
</tr>
<tr>
<th>Password:</th>
<td><input type="password" name="upass" required="" /></td>
</tr>
<tr>
<td></td>
<td><input onclick="return(submitreg());" type="submit" name="submit" value="Register" /></td>
</tr>
<tr>
<td></td>
<td><a href="login.php">Already registered! Click Here!</a></td>
</tr>
</tbody>
</table>
</form></div>

Same as we do in login page we’re passing the form to php by post method it’s capturing them & then passing the values of the form into reg_user() function as parameter.

Now the last part of the tutorial is how to log out. It’s so easy just create a file named home.php the paste the code below in the first section:

session_start();
include_once 'include/class.user.php';
$user = new User(); $uid = $_SESSION['uid'];
if (!$user->get_session()){
 header("location:login.php");
}

if (isset($_GET['q'])){
 $user->user_logout();
 header("location:login.php");
 }

Now to show our user just use html code below after your php code.

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
Home
<style><!--
 body{
 font-family:Arial, Helvetica, sans-serif;
 }
 h1{
 font-family:'Georgia', Times New Roman, Times, serif;
 }
--></style>
<div id="container">
<div id="header"><a href="home.php?q=logout">LOGOUT</a></div>
<div id="main-body">
<h1>Hello <?php $user->get_fullname($uid); ?></h1>
</div>
<div id="footer"></div>
</div>

Here we’re first checking that if the user is logged in or not if yes then we’re showing the user full name. For the logout button I don’t know but for the procedural php user it’s kind of new maybe we’re using a link like this “<a href=”home.php?q=logout”>LOGOUT</a>” and above the code in php tag we’re getting the “q” variable with $_GET function & running the function user_logout() to logout.

You can download the source code frome here by simply clicking on the button. Download Source Code.

You can Fork me on Github also for the updated version of this one.

I don’t know this is my first tutorial in php maybe not clear as i know. But if you understand this tuts a little than please leave a comment if you want anything else or what am i mistaking in here.

Adnan Shawkat

An enthusiastic of work with over 8+ years of experience. I’m extensively experienced in WordPress, Codeigniter, Laravel.

##Visit my GitHub page (https://github.com/ashawkat)
##Visit my blogging page where I spread out my knowledge around all other people (http://w3programmers.com/author/tanim)

If you want to hire me, you can contact me via email or skype.

Skype: ashawkat89
Email: contact@adnanshawkat.me