Member 11456402 Ответов: 0

Системы входят в систему на моем сервере xammp, но когда я загружаю веб-сайт на сервер cpanel, он не входит в систему и отображает неверные данные ?


$myusername=$_POST["myusername"]; 
$mypassword=$_POST["mypassword"]; 

// To protect MySQL injection (more detail about MySQL injection )
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);


$statues = "active";

// from system table
if ($sql="SELECT * FROM $tb2_name WHERE User_id='$myusername' and password='$mypassword' and statues='$statues'");
{
    $wql="SELECT Company FROM $tb2_name WHERE User_id='$myusername' and password='$mypassword'";
    $result2 = mysqli_query($link, $wql);
    $details = mysqli_fetch_array($result2, MYSQLI_BOTH);
    $Name = $details["Company"];

    $result=mysqli_query($link, $sql);

    // Mysql_num_row is counting table row
    $count=mysqli_num_rows($result);

    // If result matched $myusername and $mypassword, table row must be 1 row
    if($count==1){

        // Register $myusername, $mypassword and redirect to file "login_success.php"

        setcookie("user", $myusername, time()+3600); 
        setcookie("company", $Name, time()+3600); 
        header("location:login_success.php");
    }
}

// 

// from Manager table
if ($sql="SELECT * FROM $tb3_name WHERE Employee_Number='$myusername' and password='$mypassword' and statues='$statues'");
{
    $wql="SELECT Company_Name FROM $tb3_name WHERE Employee_Number='$myusername' and password='$mypassword'";
    $result2 = mysqli_query($link, $wql);
    $details = mysqli_fetch_array($result2, MYSQLI_BOTH);
    $Name = $details["Company_Name"];

    $result=mysqli_query($link, $sql);

    // Mysql_num_row is counting table row
    $count=mysqli_num_rows($result);

    // If result matched $myusername and $mypassword, table row must be 1 row
    if($count==1){

        // Register $myusername, $mypassword and redirect to file "login_success.php"

        setcookie("user", $myusername, time()+3600); 
        setcookie("company", $Name, time()+3600); 
        header("location:Manlogin.php");
    }
}
// employee login
if ($sql="SELECT * FROM $tbll_name WHERE Employee_Number='$myusername' and password='$mypassword' and statues='$statues'");
{
    $wql="SELECT Company_Name FROM $tbll_name WHERE Employee_Number='$myusername' and password='$mypassword'";
    $result2 = mysqli_query($link, $wql);
    $details = mysqli_fetch_array($result2, MYSQLI_BOTH);
    $Name = $details["Company_Name"];

    $result=mysqli_query($link, $sql);

    // Mysql_num_row is counting table row
    $count=mysqli_num_rows($result);

    // If result matched $myusername and $mypassword, table row must be 1 row
    if($count==1){

        // Register $myusername, $mypassword and redirect to file "login_success.php"

        setcookie("user", $myusername, time()+3600); 
        setcookie("company", $Name, time()+3600); 
        header("location:employee_login.php");
    }
    else {
	$answer = " Incorrect user name or password";
echo '<h1>' . $answer . '</h1>';
    }
}


Что я уже пробовал:

Я пробовал разные сценарии входа в систему, но он просто показывает один и тот же результат . это все, что я пробовал.

0 Ответов