<?php
session_start();
$host = "localhost";
$username = "root";
$password = "";
$database = "testdb";
$message = "";
try {
$conn = new PDO("mysql:host=$host;dbname=$database", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if(isset($_POST["login"]))
{
if(empty($_POST["username"]) || empty($_POST["password"]))
{
$message = '<label> All fields are required</label>';
}
else
{
$query = "SELECT * FROM users WHERE username = :username AND password=:password";
$statement = $conn->prepare($query);
$statement-> execute(
array(
'username' => $_POST["username"],
'password'=> $_POST["password"]
)
);
$count = $statement->rowCount();
if($count>0)
{
$_SESSION["username"] = $_POST["username"];
header("location:login_success.php");
}
else
{
$message = 'worng data';
}
}}
}
catch(PDOException $error)
{
$message= $error->getMessage();
}
$conn = null;
?>
session_start();
$host = "localhost";
$username = "root";
$password = "";
$database = "testdb";
$message = "";
try {
$conn = new PDO("mysql:host=$host;dbname=$database", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if(isset($_POST["login"]))
{
if(empty($_POST["username"]) || empty($_POST["password"]))
{
$message = '<label> All fields are required</label>';
}
else
{
$query = "SELECT * FROM users WHERE username = :username AND password=:password";
$statement = $conn->prepare($query);
$statement-> execute(
array(
'username' => $_POST["username"],
'password'=> $_POST["password"]
)
);
$count = $statement->rowCount();
if($count>0)
{
$_SESSION["username"] = $_POST["username"];
header("location:login_success.php");
}
else
{
$message = 'worng data';
}
}}
}
catch(PDOException $error)
{
$message= $error->getMessage();
}
$conn = null;
?>
Comments
Post a Comment