Home >>
PHP MySql >> How to Create Login Form with Remember in PHP MySql
How to Create Login Form with Remember in PHP MySql
1)-Create Database
http://localhost/phpmyadmin
Database Name: education
MySQL Query
CREATE DATABASE education;
2)-Create Table
Table Name: users
MySQL Query
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int (11) NOT NULL,
`username` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3)-Default folder is c:/xampp/htdocs.
4)-Create login.php in folder c:/xampp/htdocs.
<?php
//database connection
$conn=mysqli_connect("localhost","root","","education");
if(isset($_POST["submit"])){
if(!empty($_POST['user']) && !empty($_POST['pass'])) {
$user=$_POST['user'];
$pass=$_POST['pass'];
$query=mysqli_query($conn,"SELECT * FROM users WHERE username='".$user."' AND password='".$pass."'");
$numrows=mysqli_num_rows($query);
if($numrows>0) {
$row=mysqli_fetch_array($query);
$dbusername=$row['username'];
$dbpassword=$row['password'];
session_start();
$_SESSION['session_user']=$user;
/* Redirect browser */
header("Location: myprofile.php");
} else {
echo "Invalid username or password!";
}
} else {
echo "All fields are required!";
}
}
?>
<!doctype html>
<html>
<head>
<title>Login Form</title>
</head>
<body>
<h3>Login Form</h3>
<form action="" method="POST">
Username: <input type="text" name="user"><br />
Password: <input type="password" name="pass"><br />
<input type="submit" value="Login" name="submit" />
</form>
</body>
</html>
Post Your Comment