Question

I seem to have a problem with a login script, it works on a local php dev box, but not on my live environment, i m assuming i m missing something can anyone advise further?

<?php
$user = $_POST["swtorun"];
$pass = $_POST["swtorpw"];

// Generate hash
$enc_pwd = hash( sha256 , $pass);

// Connect to DataBase
include( ../../settings.php );

$conn = mysql_connect($host,$username,$password);
$db = mysql_select_db($database, $conn);

// mySql Query users
$sql = "SELECT * FROM `users` WHERE username= $user  and password= $enc_pwd ";
$result = mysql_query($sql, $conn);

$count = mysql_num_rows($result); // number of results (should be 1)

if($count==1){
// initiate session
session_start();
$_SESSION[ logged ] = "1";
echo "you are now logged in, return to the <a href="../../index.php">index</a>";
} else {
echo "Wrong Username or Password";
}
?>

Answer 1

The issue turned out to be that I had the table name capitalised on one script, but lower case on this script, hence the query failed and so did the code relying on it, I have since fixed the other script to create the table in lower case.

由于在帮助解决麻烦问题上留下的所有压力。

Answer 2

增加<代码>session_start();至贵系统编码的顶端。

友情链接