login example Archives

PHP Session Example

May 26, 2021July 8, 2018 by manish

Previous post was about PHP Session There explained about session its purpose and syntax in detail. Lets see one good example of session. User login system 1. connection.php This page is used to establish database connection from application.

<!--?php
    $con = new mysqli("localhost","root","","session");
?-->

<!--?php

$con = new mysqli("localhost","root","","session");

?-->

2. index.php This page retrives the user detail from database

<!--?php
    include "header.php";
    include "connection.php";
	if($_POST[em])
	{
		$sql = "select * from `user` where `email`='$_POST[em]' and `password`='$_POST[pw]'";
		$res = $con--->query($sql);
		$num = $res-&gt;num_rows;
		if($num!=0)
		{
			$row = $res-&gt;fetch_array();
            			$_SESSION[userid] = $row[id];
			$_SESSION[chk]    = true;
            			header("location:profile.php");  //redirect one PHP file to another PHP file
		}
		else
		{
			echo "Login Fail";
		}

	}
?&gt;

<!--?php

include "header.php";

include "connection.php";

if($_POST[em])

{

$sql = "select * from `user` where `email`='$_POST[em]' and `password`='$_POST[pw]'";

$res = $con--->query($sql);

$num = $res->num_rows;

if($num!=0)

{

$row = $res->fetch_array();

$_SESSION[userid] = $row[id];

$_SESSION[chk] = true;

header("location:profile.php"); //redirect one PHP file to another PHP file

}

else

{

echo "Login Fail";

}

Email- Password New User