 |
Hello guys I have the following table in MySQL:
ID UID Username Full Name Password Rank
0
131037146
DSaidov
Денис Саидов
f6577c70c93b6d6284b3533c179ce840
Администратор
0
1970687978
LKatzarov
Любомир Кацаров
e872b576e46cd469bfef9dd858058a15
Администратор
0
58367315
Admin
Георги Гергинов
6e73d972e8f51e4e5025fc8936c20ec5
Собственик
----END ----
And I want to save the logged in user's Full Name in a $_SESSION that I wanna echo in the CMS panel.
Thank you in advance
<?php
session_start();
include ('connect.php');
$fname=$_REQUEST['fname'];
$password=$_REQUEST['password'];
$sql=mysql_query("SELECT * FROM user WHERE fname='$fname' AND password='$password'");
if (mysql_num_rows($sql)==0)
{
$_SESSION['logmsg']="Invalid Password/Name Did Not Exist";
header('location:index.php');
}
else
{
while($data=mysql_fetch_array($sql))
{
$_SESSION['id']=$data['user_id'];
$_SESSION['fname']=$data['fname'];
$_SESSION['position']=$data['p_code'];
if ($_SESSION['position']==1)
{
header('location:home2.php');
}
else {
header('location:home1.php');
}
}
} ?>
