Today, We want to share with you registration and login form in php and mysql with validation code free download.In this post we will show you student registration form in php code with validation, hear for php: complete login and registration system with php & mysql download we will give you demo and example for implement.In this post, we will learn about User Registration in PHP with Login: Form with MySQL and Code Download with an example.
Must Read : fake tweet generator
php code for registration form with database download
Login, Signup and Logout now common for any web application. Complete User Login and Registration Script using PHP and MySQL with live demo(Secure Login System with PHP and MySQL).
Login and Signup form using PHP and MySQL with validation
Sql file
CREATE TABLE `signup_account` ( `ID` int(10) NOT NULL, `Profile_nm` varchar(100) NOT NULL, `dp_nm` varchar(100) NOT NULL, `Email` varchar(100) NOT NULL, `Password` int(100) NOT NULL, `File` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
database.php
<?php
$url='localhost';
$username='root';
$password='Fgd7854#4578d';
$conn=mysqli_connect($url,$username,$password,"fsignup_account");
if(!$conn){
die('Sorry, Could not Connect My Sql:' .mysql_error());
}
?>
signup_account.php
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700"> <title>Welcome to www.pakainfo.com</title> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="assests/css/style.css"> <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script> </head> <body> <div class="signup-form"> <form action="signup_account_a.php" method="post" enctype="multipart/form-data"> <h2>Register</h2> <p class="hint-text">Create your account</p> <div class="form-group"> <div class="row"> <div class="col"><input type="text" class="form-control" name="nic_nm" placeholder="Enter Your Nic Name" required="required"></div> <div class="col"><input type="text" class="form-control" name="profile_nm" placeholder="Profile Name" required="required"></div> </div> </div> <div class="form-group"> <input type="email" class="form-control" name="email" placeholder="Enter Email Address" required="required"> </div> <div class="form-group"> <input type="password" class="form-control" name="pass" placeholder="Password" required="required"> </div> <div class="form-group"> <input type="password" class="form-control" name="cpass" placeholder="Confirm Password" required="required"> </div> <div class="form-group"> <input type="file" name="file" required> <!-- <input type="submit" name="upload" value="Upload" class="btn"> --> </div> <div class="form-group"> <label class="form-check-label"><input type="checkbox" required="required"> I accept the <a href="#">Terms of Use</a> & <a href="#">Privacy Policy</a></label> </div> <div class="form-group"> <button type="submit" name="save" class="btn btn-success btn-lg btn-block">Register Now</button> </div> <div class="text-center">Already have an account? <a href="signin.php">Sign in</a></div> </form> </div> </body> </html>
signup_account_a.php
<?php
extract($_POST);
include("database.php");
$sql=mysqli_query($conn,"SELECT * FROM signup_account where Email='$email'");
if(mysqli_num_rows($sql)>0)
{
echo "Email Id Already Exists";
exit;
}
else(isset($_POST['save']))
{
$file = rand(1000,100000)."-".$_FILES['file']['name'];
$file_loc = $_FILES['file']['tmp_name'];
$folder="upload/";
$new_file_name = strtolower($file);
$final_file=str_replace(' ','-',$new_file_name);
if(move_uploaded_file($file_loc,$folder.$final_file))
{
$query="INSERT INTO signup_account(Profile_nm, dp_nm, Email, Password, File ) VALUES ('$nic_nm', '$profile_nm', '$email', 'md5($pass)', '$final_file')";
$sql=mysqli_query($conn,$query)or die("Could Not Perform the Query");
header ("Location: signin.php?is_active=success");
}
else
{
echo "Error.Please try again";
}
}
?>
signin.php
<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700">
<title>Welcome to Finance Portal</title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" href="assests/css/style.css">
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
</head>
<body>
<div class="signup-form">
<form action="signinProcess.php" method="post" enctype="multipart/form-data">
<h2>Login</h2>
<p class="hint-text">Give Any Login Details</p>
<div class="form-group">
<input type="email" class="form-control" name="email" placeholder="Email" required="required">
</div>
<div class="form-group">
<input type="password" class="form-control" name="pass" placeholder="Password" required="required">
</div>
<div class="form-group">
<button type="submit" name="save" class="btn btn-success btn-lg btn-block">Login</button>
</div>
<div class="text-center">Don't have an account? <a href="signup_account.php">Register Here</a></div>
</form>
</div>
</body>
</html>
signinProcess.php
<?php
session_start();
if(isset($_POST['save']))
{
extract($_POST);
include 'database.php';
$sql=mysqli_query($conn,"SELECT * FROM signup_account where Email='$email' and Password='md5($pass)'");
$row = mysqli_fetch_array($sql);
if(is_array($row))
{
$_SESSION["ID"] = $row['ID'];
$_SESSION["Email"]=$row['Email'];
$_SESSION["Profile_nm"]=$row['Profile_nm'];
$_SESSION["dp_nm"]=$row['dp_nm'];
header("Location: home.php");
}
else
{
echo "Invalid Email ID/Password";
}
}
?>
home.php
<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:400,700"> <title>Welcome to Finance Portal</title> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="assests/css/style.css"> <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/umd/popper.min.js"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script> </head> <body> <div class="signup-form"> <form action="home.php" method="post" enctype="multipart/form-data"> <h2>Welcome</h2> <br> <?php session_start(); include 'database.php'; $ID= $_SESSION["ID"]; $sql=mysqli_query($conn,"SELECT * FROM signup_account where ID='$ID' "); $row = mysqli_fetch_array($sql); ?> <img src="upload/<?php echo $row['File'] ?>" height="150" width="150" style="border-radius:50%;display:block;margin-left:auto;margin-right:auto;" /> <p class="hint-text"><br><b>Welcome </b><?php echo $_SESSION["Profile_nm"] ?> <?php echo $_SESSION["dp_nm"] ?></p> <div class="text-center">Want to Leave the Web Pages? <br><a href="logout.php">Logout</a></div> </form> </div> </body> </html>
logout.php
<?php
session_start();
unset($_SESSION["id"]);
unset($_SESSION["name"]);
header("Location:signin.php");
?>
I hope you get an idea about registration and login form in php and mysqli with validation.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.
I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I’m a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.