Complete User Login & Registration System using PHP MySQL With Image Upload

Complete PHP User Login and Registration System with Image upload are very useful for PHP beginners, after learning this process any PHP newbie can create their own PHP Crud system and also, with overview PHP Developer can start their small project.

Table of Contents

Steps to create a PHP User Login and Registration System with Image upload

Here are steps to create a PHP User Login and Registration System with Image upload,

Create a Database
Create a Database Table with Following Fields: name, username, password, city, image, gender.
Create a Registration Form with MySQL insertion query
Create a Login Form with MySQL fetch query
Connect to the Database by using PHP
Authenticate Logged in User
Create a Home Page with all User data

1. Create a Database

To creating a database, go to PHPMyAdmin and click on SQL tab. On SQL tab write below given query for

CREATE TABLE reg

2. Creating a Database Tables

To create DB tables execute below query,

CREATE TABLE reg (
name varchar(20) NOT NULL,
username varchar(20) NOT NULL,
password varchar(50) NOT NULL,
city varchar(15) NOT NULL,
image varchar(100) NOT NULL,
gender varchar(10) NOT NULL,
id int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

3. Connect to the Database

For making a connection to the DB we use below source,

connect.php

<?php

session_start();
$con= mysqli_connect("localhost","DBUSERNAME","DBPASSWORD","DBNAME")

?>

<?php

session_start();

$con= mysqli_connect("localhost","DBUSERNAME","DBPASSWORD","DBNAME")

4. Creating a Registration Form

On this part, we create a user registration form with MySQL insertion query. Where any user inputs are given data and we post that data to the database using $_POST method.

reg.php

<?php
include 'connect.php';
if(isset($_POST['sub'])){
$t=$_POST['text'];
$u=$_POST['user'];
$p=$_POST['pass'];
$c=$_POST['city'];
$g=$_POST['gen'];

//code for image uploading
if($_FILES['f1']['name']){
move_uploaded_file($_FILES['f1']['tmp_name'], "image/".$_FILES['f1']['name']);
$img="image/".$_FILES['f1']['name'];
}

$i="insert into reg(name,username,password,city,image,gender)values('$t','$u','$p','$c','$img','$g')";
if(mysqli_query($con, $i)){
echo "inserted successfully..!";
}
}
?>

<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<form method="POST" enctype="multipart/form-data">
<table>
<tr>
<td>
Name
<input type="text" name="text">
</td>
</tr>
<tr>
<td>
Username
<input type="text" name="user">
</td>
</tr>
<tr>
<td>
password
<input type="password" name="pass">
</td>
</tr>
<tr>
<td>
city
<select name="city">
<option value="">-select-</option>
<option value="knp">kanpur</option>
<option value="lko">lucknow</option>
</td>
</tr>
<tr>
<td>
Gender
<input type="radio"name="gen" id="gen" value="male">male
<input type="radio" name="gen" id="gen" value="female">female
</td>
</tr>
<tr>
<td>
Image
<input type="file" name="f1">
</td>
</tr>
<tr>
<td>
<input type="submit" value="submit" name="sub">

</td>
</tr>
</table>
</body>
</html>

<?php

include 'connect.php';

if(isset($_POST['sub'])){

$t=$_POST['text'];

$u=$_POST['user'];

$p=$_POST['pass'];

$c=$_POST['city'];

$g=$_POST['gen'];

//code for image uploading

if($_FILES['f1']['name']){

move_uploaded_file($_FILES['f1']['tmp_name'], "image/".$_FILES['f1']['name']);

$img="image/".$_FILES['f1']['name'];

}

$i="insert into reg(name,username,password,city,image,gender)values('$t','$u','$p','$c','$img','$g')";

if(mysqli_query($con, $i)){

echo "inserted successfully..!";

}

<html>

<head>

</head>

<body>

<table>

<tr>

<td>

Name

</td>

</tr>

<tr>

<td>

Username

</td>

</tr>

<tr>

<td>

password

</td>

</tr>

<tr>

<td>

city

<option value="">-select-</option>

<option value="knp">kanpur</option>

<option value="lko">lucknow</option>

</td>

</tr>

<tr>

<td>

Gender

<input type="radio"name="gen" id="gen" value="male">male

<input type="radio" name="gen" id="gen" value="female">female

</td>

</tr>

<tr>

<td>

Image

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</body>

</html>

5. Creating a Login Form

On the time of creating a login form, first, we create a query for fetching the user’s username and password using MySQL query. Below source for login page where login HTML and PHP MySQL code is available.

login.php

<?php
include'connect.php';
if(isset($_POST['sub'])){
$u=$_POST['user'];
$p=$_POST['pass'];
$s= "select * from reg where username='$u' and password= '$p'";
$qu= mysqli_query($con, $s);
if(mysqli_num_rows($qu)>0){
$f= mysqli_fetch_assoc($qu);

$_SESSION['id']=$f['id'];
header ('location:home.php');
}
else{
echo 'username or password does not exist';
}

}
?>
<html>

<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<form method="POST" enctype="multipart/form-data">
<table>

<tr>
<td>
Username
<input type="text" name="user">
</td>
</tr>
<tr>
<td>
password
<input type="password" name="pass">
</td>
</tr>
<tr>
<td>
<input type="submit" name="sub" value="submit">
</td>
</tr>
</table>
</body>
</html>

<?php

include'connect.php';

if(isset($_POST['sub'])){

$u=$_POST['user'];

$p=$_POST['pass'];

$s= "select * from reg where username='$u' and password= '$p'";

$qu= mysqli_query($con, $s);

if(mysqli_num_rows($qu)>0){

$f= mysqli_fetch_assoc($qu);

$_SESSION['id']=$f['id'];

header ('location:home.php');

}

else{

echo 'username or password does not exist';

}

<html>

<head>

</head>

<body>

<table>

<tr>

<td>

Username

</td>

</tr>

<tr>

<td>

password

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</body>

</html>

6. Authenticate Logged in User

This is the main thing for the security of your website, on this we check the session variable using PHP if the session variable is available then the user can go to the home page otherwise not.

<?php
session_start();
if(!isset($_SESSION["id"])){
header("Location: login.php");
exit();
}?>

<?php

session_start();

if(!isset($_SESSION["id"])){

header("Location: login.php");

exit();

}?>

7. Creating Home Page

After successful login user enters to the home page and also see their data with image and also log out from there.

home.php


<?php
session_start();
if(!isset($_SESSION["id"])){
header("Location: login.php");
exit();
}
include'connect.php';
$s="select*from reg where id='$_SESSION[id]'";
$qu= mysqli_query($con, $s);
$f=mysqli_fetch_assoc($qu);
?>
<html>
<head>

</head>
<body>
<table>
<tr>
<td>
Name
</td><td>

<?php echo $f['name'];?>
</td>
</tr>
<tr>
<td> Username</td>

<td>

<?php
echo $f['username'];?>
</td></tr>
<tr><td> Password</td>
<td>
<?php
echo $f['password']."<br>";?>
</td></tr>
<tr><td> City </td> <td>
<?php
echo $f['city']."<br>";?></td></tr>
<tr>
<td>Gender</td>
<td><?php
echo $f['gender']."<br>";?></td>
</tr>
<tr><td> Image</td><td>

<img src="<?php
echo $f['image'];?>" width="100px" height="100px">
</td>

</tr>
</table>
<a href="logout.php">Logout</a>

</body>
</html>

<?php

session_start();

if(!isset($_SESSION["id"])){

header("Location: login.php");

exit();

}

include'connect.php';

$s="select*from reg where id='$_SESSION[id]'";

$qu= mysqli_query($con, $s);

$f=mysqli_fetch_assoc($qu);

<html>

<head>

</head>

<body>

<table>

<tr>

<td>

Name

</td><td>

<?php echo $f['name'];?>

</td>

</tr>

<tr>

<td> Username</td>

<td>

<?php

echo $f['username'];?>

</td></tr>

<tr><td> Password</td>

<td>

<?php

echo $f['password']."<br>";?>

</td></tr>

<?php

echo $f['city']."<br>";?></td></tr>

<tr>

<td>Gender</td>

<td><?php

echo $f['gender']."<br>";?></td>

</tr>

<tr><td> Image</td><td>

<img src="<?php

echo $f['image'];?>" width="100px" height="100px">

</td>

</tr>

</table>

<a href="logout.php">Logout</a>

</body>

</html>

8. Creating a Logout page

For creating logout operation we have to destroy session using PHP session_destroy() function.

logout.php

<?php
session_start();
// Destroying All Sessions
if(session_destroy())
{
// Redirecting To Home Page
header("Location: login.php");
}
?>

<?php

session_start();

// Destroying All Sessions

if(session_destroy())

{

// Redirecting To Home Page

header("Location: login.php");

}

Image Upload using PHP MySQL Snippet

For uploading the image we make sure using enctype=”multipart/form-data” on form tag, like given below.

<form method=”POST” enctype=”multipart/form-data”>

For image uploading the PHP MySQL code snippet is given below,

//code for image uploading

if($_FILES[‘f1’][‘name’]){
move_uploaded_file($_FILES[‘f1’][‘tmp_name’], “image/”.$_FILES[‘f1’][‘name’]);
$img=”image/”.$_FILES[‘f1’][‘name’];
}

Also, check:

jQuery autocomplete ajax with Text and Image

Complete tutorial to PHP User Login and Registration System with Image upload which helps to develop a small PHP project.

Happy Coding..!

3 thoughts on “Complete PHP User Login and Registration System with image upload”

Chetan singh February 22, 2020

Its a very good example sir..
You are a great

Reply ↓
Ayesha M. Withana Arachchi May 2, 2020

dear Admin I need to View Sql Data(images) in horizontal same line.

my source code is as follows please help me:

runQuery(“SELECT * FROM `tbl_image` ORDER BY ‘id’ ASC “);
if (! empty($query)) {
foreach ($query as $key => $value) {
?>

<img src="”/>

<img src="width=”96px” height=”56px”/>

Reply ↓
1. Bikash Post authorMay 2, 2020
  
  Hi,
  Please check this. If anything else please let me know.
  
  <?php
  $qry = mysqli_query(“SELECT * FROM `tbl_image` ORDER BY ‘id’ ASC”);
  while($f=mysqli_fetch_assoc($qry)){ ?>
  <img src=”image_directory_loaction/<?php echo $f[‘image.png’];?>” width=”96px” height=”56px”>
  <?php } ?>
  
  Reply ↓

Steps to create a PHP User Login and Registration System with Image upload

1. Create a Database

2. Creating a Database Tables

3. Connect to the Database

4. Creating a Registration Form

5. Creating a Login Form

6. Authenticate Logged in User

7. Creating Home Page

8. Creating a Logout page

Image Upload using PHP MySQL Snippet

jQuery autocomplete ajax with Text and Image

Share and Enjoy !

Subscribe For Latest Updates

3 thoughts on “Complete PHP User Login and Registration System with image upload”

Leave a Reply Cancel reply

Subscribe For Latest Updates