Login From Database in PHP | Login From Email ID

index.php

 <?php
session_start();
$message="";
if(count($_POST)>0) {
include_once 'database.php';
$result = mysqli_query($conn,"SELECT * FROM emp  WHERE (userid='" . $_POST["userid_or_email"] . 
"' or email='" . $_POST["userid_or_email"] . "') 
and password = '". $_POST["password"]."'");
$row = mysqli_fetch_array($result);
if(is_array($row)) {
$_SESSION["userid"] = $row[userid];


} else {
$message = "Invalid Userid or email or Password!";
}

}
if(isset($_SESSION["userid"])) {
echo "Success";
}

?>
<html>
<head>
<title>User Login</title>
</head>
<body> 
<form method="post" action="" align="center">
<div class="message"><?php if($message!="") { echo $message; } ?></div>
<h3 align="center">Enter Login Details</h3>
Userid or mobile:<br>
<input type="text" name="userid_or_email">
<br>
Password:<br>
<input type="password" name="password">
<br><br>
<input type="submit" name="submit" value="Submit">
<input type="reset">
</form>
 </body>
</html> 

database.php

  <?php
$servername='localhost';
$username='root';
$password='';
$dbname = "portal";
$conn=mysqli_connect($servername,$username,$password,"$dbname");
if(!$conn){

 die('Could not Connect My Sql:' .mysql_error());
}
?>

Output:-

Download Source Code

Download

Next Topic

← prev next →

MYSQL Database

PHP Programs

PHP Projects

Login From Database in PHP | Login From Email ID

Download Source Code