Log-in

StoneJunkie

Hey,

I have made a little script to check if the username and password exist in the database, but it does not seems to work. Is there anyone who can tell me what I'm doing wrong? Please by gentle in you respons I'm a newbie 🙂

NB. The password in the databasen is also encrypted.

Log-in Script--------------------------------------------------------------

<?php

include '../db.php';

if (isset($log_in)){

$dbCheck = mysql_query("SELECT user_name, user_password FROM users") or die(mysql_error());
$row_users = mysql_fetch_array($dbCheck);
for ($i=0; $i<count($row_users); $i++){
if ($indtastet_user_name==$row_users[user_name][$i] AND md5($indtastet_user_password)==$row_users[user_password][$i]){
$info = "You have now access!";

}
}
echo $info;
}
?>

<?php if (!$log_in){?>
<html>
<body>
<form method=post action=<?php echo $PHP_SELF;?>>
<input type="text" name="indtastet_user_name">
<input type="password" name="indtastet_user_password">
<button type="submit" name="log_in">Log In</button>
</form>
</body>
</html>
<?php }?>

Nate

Hi,

The best way to debug is to print the variables directly to your page...

<?php
echo "Username: $indtastet_user_name";
?>

If, after submitting the form the page only prints "Username :" you should try:

<?php
echo "Username: " . $_POST['indtastet_user_name'];
?>

Also, not to be rude/mean but in the future it would be helpful if you did 2 things.

1) When you paste code here put the code in VB PHP tags {PHP} (change { to [ ). Just click the little PHP button in your post.

2) Tell us what the problem is. What isn't working?

laserlight

I could easily present a solution, but let's work through what you are doing.

Explain what you think should happen in the code that just follows "if (isset($log_in)){ ".
In other words, write out in (structured) English the algorithm.

StoneJunkie

The whole idea with the script is to check whether the user is a member or not. If he is a member a variable is set, and has now access to a member site.

My problem is that, the variable $info is not set, when I type the correct username and password.

I hope my english is making sense.

if (isset($log_in)){ 

//Make a call to the Database
   $dbCheck = mysql_query("SELECT user_name, user_password FROM users") or die(mysql_error()); 
	 $row_users = mysql_fetch_array($dbCheck);

//Is checking whether the username and password exist in the Database
for ($i=0; $i<count($row_users); $i++){
  if ($indtastet_user_name==$row_users[user_name][$i] AND md5($indtastet_user_password)==$row_users[user_password][$i]){

$info = "You have now access to the member site";  //If the username and password exist the variable is set.
  }
}
echo $info;  //This line is only to check whehter the variable is set or not.
}