LINUX, FOSS AND LIBRARY TECHNOLOGY ENTHUSIAST

Monday, November 18, 2019

User Registration & Login Management System using PHP, MySQL

0 comments
This Blogspot will help you to create a Login and Register Management System with an admin panel using PHP, MySQL. This system can be used to create a database of a group of people like students, patients, employees, etc. Once the Users register in the form will be able to log in and add their details. At the same time, the admin will have all administrative privileges.

Open Applications > System Tools > Terminal and execute the below commands OR connect your remote server via SSH and reach the terminal.

sudo su
sudo apt-get update && sudo apt-get upgrade -y
sudo apt-get install lamp-server^   

NB: 1. While installing the LAMP server you may be prompted to set MySQL root password, If you have already LAMP stack on your server, It won't. 
        2. Ensure your server has Listen 80 in apache2 port.conf, if not add a new one.

sudo gedit /etc/apache2/ports.conf

Listen 80 

Setup;

First, download the source code which contains  mainly two files and copy it into
Home directory.
1) loginsystem (directory)
2) loginsystem.sql (SQL/database file)

Download Link: ​ https://drive.google.com/file/d/1cRzKvLGZjKg-ptrXgBkME0LDt8ypTxOw/view 

Now we have to copy the loginsystem directory into webroot directory usually /var/www or /var/www/html. Open the terminal into Home directory and apply the following commands.

sudo su
sudo mv /home/mahesh/loginsystem /var/www/html
cd /var/www/html
chmod 777 -R loginsystem

Setup the database:

Open the terminal and apply the following commands.

sudo su
mysql -uroot -p

[Enter MySQL Root password]

create database loginsystem;
grant all privileges on loginsystem.* to 'root'@'localhost' identified by
'admin@123';
flush privileges;
quit;

Where ‘root’ is the username and ‘admin@123' is  the password. Now restore the sample database which is present in the ‘loginsystem’ directory by applying the following command in terminal.

sudo su
mysql -uroot -p loginsystem < loginsystem.sql

Set admin@123 as your password in both  dbconnection.php file located in ‘loginsystem’ and admin directory at line number 3 

sudo gedit /var/www/html/loginsystem/dbconnection.php

sudo gedit /var/www/html/loginsystem/admin/dbconnection.php

Restart apache2 and MySQL 

sudo service apache2 restart
sudo service mysql restart

The system is ready now.

You can access it at the address given below:

http://127.0.0.1/loginsystem              OR     https://your-server-ip/loginsystem
http://127.0.0.1/loginsystem/admin   OR     https://your-server-ip/loginsystem/admin

Credential for admin panel :

Username: admin
Password: Test @123

No comments:

Post a Comment