PHP Login, Logout and Registration System with Sample Code

Login, Logout and Registration system is an essential features for any web application. This is simple PHP based application that I will describe with sample PHP code. You can add this common application in your PHP project. This tutorial is for beginners, and also it is very easy to understand. So first of all take a look at the contents that you should learn throughout this brief tutorial. 

PHP Login, Logout and Registration Tutorial:

  • Introduction
  • Basic Requirements
  • Creating MySQL Database
  • MySQL Database Connection using PHP
  • Database Selection and Closing
  • Some Fundamental SQL Query
  • Creating HTML Layout using Twitter Bootstrap
  • Creating Registration Form and Login Form
  • Handling Registration Form using PHP
  • PHP Login and Logout Handling 
  • Consolidating All Parts 
  • Conclusion 
That's are the thing I will describe throughout the whole tutorial. So let's start

Introduction: 

Using this application a user can be a registered member through a registration form. Only each registered member can enter into the application. After Login a member can be logged out into the system then if he or she wants to enter the system, he or she must be login the system by writing username and password in the login form. So we have to create registration form and login form for our users. We will create these by using Twitter Bootstrap form tutorial. 
Want to know more on Twitter Bootstrap just go to this link: Twitter Bootstrap  
So to develop this PHP Login, Logout and Registration application we need some basic requirements.

Basic Requirements: 

It is PHP and MySQL based web application so before making this cool application you have to meet some basic requirements. Lets see these...
  1. A PHP and MySQL enable server like XAMPP or WAMP or Vertrigo. We use Vertrigo. To install Vertrigo in your PC, you can see this tutorial. How to install Vertrigo in your PC 
  2. Basic Knowledge on HTML and JavaScript
  3. An editor like Dreamweaver or Notepad++ but we will use Dreamweaver editor.
If these requirements are meet then you are ready to make this awesome PHP Login and Logout application.

Creating MySQL Database: 

We will store the users information in MySQL database. Before that we have to create a MySQL database for our application. Suppose our database name is LoginSystem.  This is our database name and we will use this for our application. Information's are stored in MySQL database as a Table. So for our each user we need to create a table. We can name this table user. What are the users information?? It is:
firstName,
lastName,
emailAddress,
userName and
password
The users table will be like this user(firstName, lastName, emailAddress, userName, password). We have defined the user table attributes but we have to create this table in MySQL database by writing hand made sql query or through PHPMyAdmin panel. In this portion we will create user table through PHPMyAdmin panel. Here's the steps you can follow:
Step 1: In your browser type http://localhost/phpmyadmin/ and then write username, password, and then click login(To do this at first you have to start your Vertrigo database otherwise you will not be able to enter this URL). It will show a screen and from this screen click on Databases. It will be look like this:
Important: We use Vertrigo server so the username is root and password is vertrigo. 
Step 2:
Then click create like the following picture.

Now you have completed your primary tasks and it's time to go forward.
Step 3:
Our database is created but we have to create a table for storing the users information. Our user has five attributes so make sure the table column is five and then click on create table. A new window will be open. In this window fill up the users information like this.
We put each attributes type is verchar to make this application database simple. If you want to know more on Database you can read tutorial from the internet. 
Select the username as a primary key and then click save button.
So we have created our fully functional database. Watch this portion in Youtube. Here is the link: PHP Login, Logout and Registration database Creation. 
MySQL Database Connection using PHP: I will write this portion in next week.

Comments

Post a Comment

Popular posts from this blog

How to show only month and year fields in android Date-picker?

Image
Android default DatePicker show day/month/year fields but you have to customize this DatePicker as your requirements. Suppose that you want to show only month and year fields in android datepicker . To do this, you have to customize the Dialog DatePicker source code but it is not an easy task. In this tutorial I will show you a tricky way to solve this problem. Lets see how to show only month and year field in android DatePicker as a dialog.   Step to show only month and year fields in android date-picker: Some days ago I got this same problem and here I am trying to explain this in a sequential manner. I want to show a dialog datepicker when user click on an EditText. So if user click on EditText, A dialog datepicker will be invocked and it will show only month and year fields. To do this, at first we have to create a xml layout to hold the EditText fields. So create an android project and name it DatePickerExample. In the main.xml file just try to write this simple code....
Read more

How to construct a B+ tree with example

Image
A B+ tree contains n-1 search key values K1K2…….Kn-1 and have n pointers.   In a B+ tree the data are ordered  sequentially.  The leaf node may hold up to n pointers and must hold at least N/2 pointers. The root node must hold at least two pointers, unless the tree consists of only one node.  Now we construct a B+ tree. Construct a B+ tree for the following set of key values: (2,3,5,7,11,17,19,23,29,31) Assume that the tree is initially empty and values are added in ascending order. Construct a B+ tree where the pointer number is Four. Solution: When a node exceeds n-1 search key value then we split it into two nodes. First node contains (ceiling(n-1)/2) values.  2 nd node contains remaining node. Copy the smallest search key value of the second node to the parent node. Let's start, we know each node has N pointer and has N-1 search key values. In our example pointer number is 4, so the search key value is 4-1=3. So each node has 4 pointers and 3 search key val...
Read more

Conflict Serializability in database

Image
To maintains database state consistency we introduce serializability. Using serializability we can understand which schedule will ensure consistency, and which schedule will not. When we are capable of converting a concurrent schedule into a serial schedule then we cal it serializable schedule. A schedule is serializable if it is equivalent to a serial schedule. We divided this concepts into two parts 1. Conflict serializability  & 2. View serializability In this discussion I just clarify you the conflict serializability. Consider two instruction read, write and the data item A and B. When two instruction execute different data item such as read(A) and read(B), then we can swap the instruction without affecting the result of the schedule. But when the data item is equivalent to one another we need to consider following four condition.    a.   read (A ),    read ( A ).   they   don’t conflict.    b.   read ( Q),  ...
Read more