Yes, start by making sure that you have 2 columns in your 'loginform' table named username and password NOT user and pass as you currently have. (I personally hate abbreviated variable names and then other obscure variable names being used to match those. It just make everything so much more difficult, so lets keep it real and you'll get along much better in my opinion.)
Copy the code below and insert it in a new Dreamweaver document and save it as login.php
<?php
session_start();
$host="localhost";
$user="root";
$password="";
$db="loginsystem";
mysql_connect($host, $user, $password);
mysql_select_db($db);
if(isset($_POST['username'])){
$username=$_POST['username'];
$password=$_POST['password'];
$sql="select * from loginform where username='".$username."'AND password='".$password."'limit 1";
$result=mysql_query($sql);
if(mysql_num_rows($result)==1){
// SET 2 SESSION VARIABLES FOR SECURITY
$_SESSION['username'] = true;
$_SESSION['password'] = true;
echo "<h2>You Have Successfully Logged in</h2>";
echo "<h3><a href='secure_page.php'>Enter Here</a></h3>";
}
else{
echo "<h2>You Have Gone Wrong Somewhere?!</h2>";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>Login</title>
</head>
<body>
<form method="post" action="login.php" >
<input class="input-group usrpwd" type="text" name="username" placeholder="Username/Email">
<br>
<input class="input-group usrpwd" type="password" name="password" placeholder="Password">
<button class="btn" type="submit" name="submit">Login</button>
</form>
</body>
</html>
Thats just about it. If you follow the instructions above you'll have a simple working login page.
Next create a page named secure_page.php in your project folder as that is where the link in the login script above is pointed if someone successfully logs in:
echo "<h3><a href='secure_page.php'>Enter Here</a></h3>";
Now what you dont want to happen is if someone happens upon secure_page.php is for the information to be shown unless someone is logged in.
At the very start of the sercure_page.php document insert the below code OR on any other page with sensitive information on it. If you browse to any page which has this information it will instantly take you back to the login.php page
<?php
session_start();
if(!isset($_SESSION['username']) && !isset($_SESSION['password'])) {
header('Location: login.php');
}
?>
The above is a simple login approach and you can style it how you like. Please be aware you are using the old deprecated method mysql to perform this task which will still work on any servers which have php version less than 7 installed. Ideally you would want to use the new improved mysqli method and encrypt your passwords but for now I don't want to confuse you.
1 Correct answer
8
Replies
AdChoices