login problem
Posted: Wed Aug 13, 2008 8:25 pm
i want to ask bout my login script
sometimes i can login..but sometimes its appear error login
here is my script
o<?php
include('connection/decl.php');
include('connection/atr.php');
session_start();
{
//".md5($_POST['user_password'])."'
$usrname=$_POST['username'];
$passwrd=$_POST['password'];
$username=mysql_query("SELECT username FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$username_ar=mysql_fetch_array($username);
$password=mysql_query("SELECT password FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$password_ar=mysql_fetch_array($password);
$designation=mysql_query("SELECT designation FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$designation_ar=mysql_fetch_array($designation);
$level=mysql_query("SELECT level FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$level_ar=mysql_fetch_array($level);
//$name=mysql_query("SELECT name FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
//$name_ar=mysql_fetch_array($name);
$idStaffS=mysql_query("SELECT idStaff FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$idStaff_ar=mysql_fetch_array($idStaffS);
//$codeCompany=mysql_query("SELECT codecat FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
//$codeCompany_ar=mysql_fetch_array($codeCompany);
if($designation_ar['designation'] == "$designation1")
{
header('Location:spadmin/index.php');
//echo $mainSprAdmin;
}
if($designation_ar['designation'] == "$designation2")
{
header('Location:admin/index.php');
}
if($designation_ar['designation'] == "$designation3")
{
header('Location:staff/index.php');
}
if($designation_ar['designation'] == "$designation4")
{
header('Location:cust/index.php');
}
else {
echo "<meta http-equiv=\"refresh\" content=\"0; URL=mesej.php?msg=ralatLogin\">";
}
$username=$_POST['username'];
$username=$username_ar['username'];
$designation=$designation_ar['designation'];
//$codeCompany=$codeCompany_ar['codecat'];
$idStaffS=$idStaff_ar['idStaff'];
$name=$name_ar['name'];
$level=$level_ar['level'];
session_register('username');
session_register('designation');
//session_register('name');
session_register('level');
session_register('idStaffS');
//session_register('codeCompany');
//
}
?>
sometimes i can login..but sometimes its appear error login
here is my script
o<?php
include('connection/decl.php');
include('connection/atr.php');
session_start();
{
//".md5($_POST['user_password'])."'
$usrname=$_POST['username'];
$passwrd=$_POST['password'];
$username=mysql_query("SELECT username FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$username_ar=mysql_fetch_array($username);
$password=mysql_query("SELECT password FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$password_ar=mysql_fetch_array($password);
$designation=mysql_query("SELECT designation FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$designation_ar=mysql_fetch_array($designation);
$level=mysql_query("SELECT level FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$level_ar=mysql_fetch_array($level);
//$name=mysql_query("SELECT name FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
//$name_ar=mysql_fetch_array($name);
$idStaffS=mysql_query("SELECT idStaff FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
$idStaff_ar=mysql_fetch_array($idStaffS);
//$codeCompany=mysql_query("SELECT codecat FROM $tbl5 WHERE username='$usrname' AND password='$passwrd'");
//$codeCompany_ar=mysql_fetch_array($codeCompany);
if($designation_ar['designation'] == "$designation1")
{
header('Location:spadmin/index.php');
//echo $mainSprAdmin;
}
if($designation_ar['designation'] == "$designation2")
{
header('Location:admin/index.php');
}
if($designation_ar['designation'] == "$designation3")
{
header('Location:staff/index.php');
}
if($designation_ar['designation'] == "$designation4")
{
header('Location:cust/index.php');
}
else {
echo "<meta http-equiv=\"refresh\" content=\"0; URL=mesej.php?msg=ralatLogin\">";
}
$username=$_POST['username'];
$username=$username_ar['username'];
$designation=$designation_ar['designation'];
//$codeCompany=$codeCompany_ar['codecat'];
$idStaffS=$idStaff_ar['idStaff'];
$name=$name_ar['name'];
$level=$level_ar['level'];
session_register('username');
session_register('designation');
//session_register('name');
session_register('level');
session_register('idStaffS');
//session_register('codeCompany');
//
}
?>