Simple login and account management module using PHP & MySQL. Using this module we have to perform login with session management, adding new user, edit & delete user.

click here to download source code

1. Creating Database & Table

Create a database in MySQL. For example, I’ve create database “account” for more details for creating database click here

CREATE Database account

Create a table “account_tb”

CREATE TABLE account_tb(
acc_id INT(20) NOT NULL AUTO_INCREMENT, 
acc_name VARCHAR(155) NOT NULL, 
acc_email  VARCHAR(155) NOT NULL, 
acc_password   VARCHAR(155) NOT NULL,  
created_dt DATETIME NOT NULL, 
status INT(1) NOT NULL DEFAULT "1", 
primary key ( acc_id )) 

Insert default data for login the application

INSERT INTO account_tb (
acc_id, acc_name, acc_email, acc_password, status) VALUES
(1, 'Admin', 'admin@admin.com', '21232f297a57a5a743894a0e4a801fc3', 1)

2. Config and Run

Extract the downloaded zip file in “html directory in wamp” (or) “htdocs directory in Xampp”.

Open app/config.php, change hostname, database name, username and password. run the application.

Click here to download source code

3. Output Screen