hvorfor kan jeg ikke logge ind?

Thu, 28 Jul 2011 01:48:05 GMT

Mit problem ligger i at n�r jeg pr�ver at logge ind, s� springer mit script direkte til else delen af mit loop.

Jeg har lagt nogle printf statements ind for at h�lpe mig med debugging.

Bla. har jeg fundet ud af at $password efter hashing med hash(sha512) stemmer over ens med den hash v�rdi som er gemt i databasen.

PHP kode

 <?php
 
 //include_once './bin/configDb.php';
 //MySQL connection variables
 
 $dbhost = 'localhost';
 $dbname = 'ideabank';
 $dbuser = 'xxx';
 $dbpass = 'xxx';
 $table = 'members';
 
 
 // Connect to server and select databse.
 //include_once './bin/connectDb.php';
 $conn = mysql_connect($dbhost, $dbuser, $dbpass);
 mysql_select_db($dbname, $conn);
 
 
 // username and password sent from form, cleanout, esacpe string against sqlinj.
 $username = mysql_real_escape_string($_POST['username']);
 $password = hash('sha512', $_POST['password']);
 printf("$username \n");
 printf("$password \n");
 
 $sql = "SELECT * FROM $table WHERE username = '$username' AND password = '$password'
 ";
 
 $result=mysql_query($sql);
 
 //$result = mysql_query("SELECT * FROM $table WHERE username = '$username' AND password = '$password'
 //");
 
 // Replace counting function based on database you are using.
 $count=mysql_num_rows($result);
 // If result matched $username and $password, table row must be 1 row
 
 
 
 if($count==1){
   // Register $username, $password and redirect to file "login_success.php"
   session_register("username");
   session_register("password");
   header("location:login_success.php");
 }
 
 else {
   echo "Wrong Username or Password";
 }
 
 exit ()
 
 ?>

Udvikleren.dk - Seneste [sha512] forum tr�de

hvorfor kan jeg ikke logge ind?