<?php
define('DB_HOST','localhost');
define('DB_USER','root');
define('DB_PASS','');
define('DB_NAME','student_record');
// Establish database connection.
try
{
$dbconnection = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
}
catch (PDOException $e)
{
exit("Error: " . $e->getMessage());
}
?>
<?php
session_start();
//Database Configuration File
include 'dbconnection.php';
error_reporting(0);
if(isset($_POST['submit']))
{
$uname=$_POST['email'];
$password=md5($_POST['password']);
$sql ="SELECT email,contactno,password FROM tblregistration WHERE (email=:usname || contactno=:usname) and (password=:usrpassword)";
$query= $dbconnection -> prepare($sql);
$query-> bindParam(':usname', $uname, PDO::PARAM_STR);
$query-> bindParam(':usrpassword', $password, PDO::PARAM_STR);
$query-> execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
if($query->rowCount() > 0)
{
$_SESSION['email']=$_POST['email'];
echo "<script >document.location = 'welcome.php'; </script>";
} else{
$error="Invalid Details";
}
}
?>
<link href="https://netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<div class="container">
<div class="row centered-form">
<div class="col-sm-4 ">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Registration and Login</h3>
<p style="color: red"><?php echo $error;?></p>
</div>
<div class="panel-body">
<form method="POST">
<div class="form-group">
<label for="email">Email</label>
<input type="email" name="email" id="email" class="form-control input-sm" placeholder="Email Address" required="">
</div>
<div class="form-group">
<label for="Password">Password</label>
<input type="password" name="password" id="password" class="form-control input-sm" placeholder="Password">
</div>
<div class="col-sm-6 ">
<input type="submit" name="submit" value="Login" class="btn btn-info btn-block">
</div>
<div class="col-sm-6 ">
<a href="registration.php"><p class="btn btn-info btn-block">Registration</p></a>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<style type="text/css">
body{
background-color: #fff;
}
.centered-form{
margin-top: 60px;
}
.centered-form .panel{
background: rgba(255, 255, 255, 0.8);
box-shadow: rgba(0, 0, 0, 0.3) 20px 20px 20px;
}
</style>
<?php
include 'dbconnection.php';
$error= $succmsg=NULL;
if(isset($_POST['submit'])){
$name = $_POST['name'];
$email = $_POST['email'];
$contactno = $_POST['contactno'];
$gender = $_POST['gender'];
$password=$_POST['password'];
$pass=md5($password);
$confrmpss = $_POST['confirmpassword'];
$usermatch=$dbconnection->prepare("SELECT email,contactno FROM tblregistration WHERE (email=:usreml || contactno=:mblenmbr)");
$usermatch->execute(array(':usreml'=>$email,':mblenmbr'=>$contactno));
while($row=$usermatch->fetch(PDO::FETCH_ASSOC))
{
$usrdbeml= $row['email'];
$usrdbmble=$row['contactno'];
}
if(empty($name))
{
$error="Please Enter Name";
}
else if(empty($email))
{
$error="Please Enter valid email id!";
}
else if(!preg_match("/^[_\.0-9a-zA-Z-]+@([0-9a-zA-Z][0-9a-zA-Z-]+\.)+[a-zA-Z]{2,6}$/i", $email))
{
$error="'Email not valid!!', {timeOut: 5000})</script>";
}
else if(!is_numeric($contactno))
{
$error="Contact number contain numbers only!";
}
else if(strlen($contactno)!=10)
{
$error="Enter 10 digit valid contact no !";
}
else if($email==$usrdbeml || $contactno==$usrdbmble)
{
$error="Email Id or Contact Number Already Exists!";
}
else if (empty($gender))
{
$error = "Please select gender";
}
else if($password="" || $confrmpss=="")
{
$error="Password And Confirm Password Not Empty!";
}
else if($_POST['password'] != $_POST['confirmpassword'])
{
$error="Password And Confirm Password Not Matched";
}
else if (preg_match('/(?=^.{6,}$)((?=.*\d)|(?=.*\W+))(?![.\n])(?=.*[A-Z])(?=.*[a-z]).*$/',$password))
{
$error="You did not enter valid password";
}
else{
$sql="INSERT INTO tblregistration (name,email,contactno,gender,password)
values(:names,:emailid,:mobileno,:gendr,:passwords)";
$query = $dbconnection -> prepare($sql);
$query->bindParam(':names',$name,PDO::PARAM_STR);
$query->bindParam(':emailid',$email,PDO::PARAM_STR);
$query->bindParam(':mobileno',$contactno,PDO::PARAM_STR);
$query->bindParam(':gendr',$gender,PDO::PARAM_STR);
$query->bindParam(':passwords',$pass,PDO::PARAM_STR);
$query -> execute();
$lastInsertId = $dbconnection->lastInsertId();
if($lastInsertId>0)
{
$succmsg= "Data insert Successfully";
}
else {
$succmsg= "Data not insert successfully";
}
}
}
?>
<link href="https://netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<div class="container">
<div class="row centered-form">
<div class="col-sm-4 ">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Registration and Login</h3>
</div>
<div class="panel-body">
<p style="color: red;"><?php echo $error;?></p>
<p style="color: green;"><?php echo $succmsg;?></p>
<form method="POST">
<div class="form-group">
<label for="name">Name</label>
<input type="text" name="name" id="name" class="form-control input-sm" placeholder="Name">
</div>
<div class="form-group">
<label for="email">Email</label>
<input type="email" name="email" id="email" class="form-control input-sm" placeholder="Email Address">
</div>
<div class="form-group">
<label for="contactno">Contact No</label>
<input type="text" name="contactno" id="contactno" class="form-control input-sm" placeholder="Contact No" maxlength="10">
</div>
<div class="form-group">
<label for="name">Gender</label>
<input type="radio" name="gender" value="Male">Male<input type="radio" name="gender" value="Female">Female
</div>
<div class="form-group">
<label for="password">Password</label>
<input type="Password" name="password" id="password" class="form-control input-sm" placeholder="Password">
</div>
<div class="form-group">
<label for="name">Confirm Password</label>
<input type="password" name="confirmpassword" id="confirmpassword" class="form-control input-sm" placeholder="Confirm Password">
</div>
<div class="col-sm-6 ">
<input type="submit" name="submit" value="Registration" class="btn btn-info btn-block">
</div>
<div class="col-sm-6 ">
<a href="index.php"><p class="btn btn-info btn-block">Login</p></a>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<style type="text/css">
body{
background-color: #fff;
}
.centered-form{
margin-top: 60px;
}
.centered-form .panel{
background: rgba(255, 255, 255, 0.8);
box-shadow: rgba(0, 0, 0, 0.3) 20px 20px 20px;
}
</style>
<?php
session_start();
?>
<link href="https://netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<div class="container">
<div class="row centered-form">
<div class="col-sm-12 ">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title">Registration and Login</h3>
<?php echo $_SESSION['email']; ?>
<a href="logout.php"><h3 class="panel-title" style="float: right;margin-top: -18px;">Logout</h3></a>
</div>
<div class="panel-body">
time. I really like to find out and share my knowledge with others.I founded ThePhpConcept in March 2020. I started this blog in order that I can interact with some like-minded people and also help people learning PHP, Mysql, jQuery, Html, and PHP Projects and related technologies.
Support-thephpconcept@gmail.comtime. I really like to find out and share my knowledge with others.I founded ThePhpConcept in March 2020. I started this blog in order that I can interact with some like-minded people and also help people learning PHP, Mysql, jQuery, Html, and PHP Projects and related technologies.
Support-thephpconcept@gmail.com
</div>
</div>
</div>
</div>
</div>
<style type="text/css">
body{
background-color: #fff;
}
.centered-form{
margin-top: 60px;
}
.centered-form .panel{
background: rgba(255, 255, 255, 0.8);
box-shadow: rgba(0, 0, 0, 0.3) 20px 20px 20px;
}
</style>
<?php
session_start();
include 'dbconnection.php';
session_destroy();
header("location: index.php");
exit();
?>
Login And Registration Using PHP PDO MySQL
Size: 3kb
Version: 3.0
553 Downloads
Leave a Comment