1. Create MySQL Users / Users Table
To create a database and table for example database name is "cms" and table name is "user",then run this code in your MySQL software, you can use phpMyAdmin.
fieldname: user_id
type: int (4) auto increment set as primary key
fieldname: username
type: varchar (20)
fieldname: password
type: varchar (50)
if successful then your table will be like in the picture below.
2. Create Script Code Login FormThen insert to user table with data like below (make sure when enter password select dropdown function select MD5)
username: dodo
password: passwordnyadod0
username: tri
password: password1
Now display your data in user table like picture below.
For php files we need some files :
1. index.php
2. login.php
3. logout.php
4. database.php
Index.php will act as the dashboard page, while the database.php page is the page that contains the connect function to the database we created earlier
index.php
<? php
session_start ();
$ username = $ _SESSION ['username'];
$ isLoggedIn = $ _SESSION ['isLoggedIn'];
if ($ isLoggedIn! = '1') {
session_destroy ();
header ('Location: login.php');
}
?>
Welcome <? Php echo $ username; ;?>
<a href="logout.php"> Logout </a>;
?>
login.php
<? php
session_start ();
include 'database.php';
if (! empty ($ _ POST)) {
$ username = $ _POST ['username'];
$ password = md5 ($ _ POST ['password']);
$ sql = "select * from user where username = '". $ username. "' and password = '". $ password. "'";
#echo $ sql. "<br />";
$ query = mysql_query ($ sql) or die (mysql_error ());
// check for valid query
if ($ query) {
$ row = mysql_num_rows ($ query);
// if $ row> 0 or username and password are found
if ($ row> 0) {
$ _SESSION ['isLoggedIn'] = 1;
$ _SESSION ['username'] = $ username;
header ('Location: index.php');
} else {
echo "wrong username or password";
}
}
}
?>
<form action = "" method = "post">
<input type = "text" name = "username">
<input type = "password" name = "password">
<input type = "submit" value = "login">
</ form>
logout.php
<?php
session_start();
session_destroy();
header('Location: login.php');
?>
database.php
3. Save this files in a folder called "login-form" and place the folder in htdocs folder.?php
$host = "localhost";
$user = "root";
$pass = "root";
$db_name = "cms";
mysql_connect($host, $user, $pass) or die (mysql_error());
mysql_select_db($db_name) or die (mysql_error());
?>
The htdocs folder is located in the XAMPP folder, in this tutorial we use XAMPP as the web server.
After doing all the steps how to make login form above, now it's time we to try login form with PHP and MySQL which completed session by typing address "http: //localhost/login-form/index.php" on browser page.
Similarly tutorial how to create login form, if there is step less understood, please send question through comment field below. Thanks.