درج نام کاربری در پیج اصلی سایت بعد از لاگین کردن.

session.php

<?php
if (!isset($_SESSION)) {
    session_start();
}
if($_SESSION['valid_user']!=true){
header('Location: login.php');
die();
}
?>

connection.php

<?php
$db_host = 'local';
$db_user = 'root';
$db_pwd = 'pwd';
$database = 'MyDB';

$connectionInfo = array("UID" => $db_user, "PWD" => $db_pwd, "Database"=>$database); 
$conn = sqlsrv_connect( $db_host, $connectionInfo);
if( !$conn )
{
     echo "Connection could not be established.\n";
     die( print_r( sqlsrv_get_last_message(), true));
}
?>

login_action.php

<?php
session_start();

require_once 'connection.php';

$EmployeeId = $_POST['EmployeeId'];
$Password  = $_POST['Password'];
$UserType = $_POST['UserType'];

$tsql = "SELECT * FROM [MyDB].[dbo].[LOGIN] WHERE EmployeeId='$EmployeeId' AND Password='$Password' AND UserType='$UserType'";
$result = sqlsrv_query( $conn, $tsql,$params , array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));

$num = sqlsrv_num_rows($result);
if($num==1){
    $_SESSION['valid_user'] = true;
    $_SESSION['EmployeeId'] = $EmployeeId;
    $_SESSION['UserType'] = $UserType;
    if($UserType == "USER")
    {
        header("Location: user.php");
        exit();
    }
    else if ($UserType == "SUPERIOR")
    {
        header("Location: superior.php");
        exit();
    }
    else if ($UserType == "ADMIN")
    {
        header("Location: admin.php");
        exit();
    }
    else 
    die("Not a Valid User Type.");

    }
    else
    //die(sqlsrv_errors());
    header('Location: login_error.php');
    exit();

?>

index.php

<?php
    $EpId = $_SESSION['EmployeeId'];

    $tsql = 
    "SELECT * 
    FROM [MyDB].[dbo].[USER]
    WHERE EmployeeId = '$EpId'";
    $result = sqlsrv_query($conn, $tsql, array(), array ("Scrollable" => SQLSRV_CURSOR_KEYSET));

    while($row=sqlsrv_fetch_array($result))
    {
        $EId = $row['EmployeeId'];
        $uName = $row['UserName'];
    }

    echo 'Welcome $uName | $EpId';

    ?>