Login Help

Nathan__02

Ok...i have a page where people can sign up and they get entered into the database and i have a login script which logs them in.

<?php 

include("style.css");
include("config.php");

$query= mysql_query("SELECT * FROM users WHERE username='$user' AND password='$pass'");

echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");

if (!$query) {
echo("Wrong Username or Password.<BR>
      Try again <a href='/game/login.php'>here</a>.");
} else {
if ($validate == 1){
$_SESSION['username']=$user;
echo("Game still in progress.");
} else {
echo("Sorry, we could not log into your account!");
}
}

?>

and it always comes up either wrong username/password or 'we could not log u in'

any help is appreciated 😃

stolzyboy

try this instead, there may be parse errors or whatever, but it should work after that


<?php 

include("style.css");
include("config.php");

$query = "SELECT * FROM users WHERE username='$user' AND password='$pass';";
$result = mysql_query($query) or die(mysql_error());
echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");

$isAuth = false;

while($row = mysql_fetch_array($result))
{
if($row['username'] == $user)
{
$isAuth = true;
$fname = $row['fname'];
}
else
{
$isAuth = false;
}
}

if (!$isAuth) 
{
echo("Wrong Username or Password.<BR>
      Try again <a href='/game/login.php'>here</a>.");
} 
else {

if ($validate == 1){
$_SESSION['username']=$user;
echo("Game still in progress.");
} else {
echo("Sorry, we could not log into your account!");
}
}

?>


</body>
</html>

Nathan__02

it still comes up with the 'sorry we could not log u in' response.

i have no clue why its doing that.
heres my pages.

signup
login
members

stolzyboy

can you attach those three files so i can check them out closer, just xxxx out the username and passwords for the database and such

Nathan__02

so u want the codes for them?
when i connect to my database it works fine for inputing usernames and passwords

Nathan__02

this is my config.php

<?php
$dbuser = 'root'; //  

$dbhost = 'localhost'; // 
$dbname = 'l0tt0'; // database's name where the tables are found


$db = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname,$db);
?>

Nathan__02

this is where they signup

<?php 
include("style.css");

echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");
echo("<form action='signup.php' method='post'>
      <table><tr><td>Please fill out the information below.
                 <BR> If you have already created an account,
                 <BR> please login <a href='/game/login.php'>here</a>.</td></tr>
      <Tr><TD>Username:<input type='text' name=user class='field'></td></tr>
      <tr><td>Password:<input type='password' name=pass class='field'></td></tr>
      <tr><td><input type='submit' name='submit' value='Submit' class='formbutton'></td></tr>
      </table>
      </form>");
echo("</font></center></body>")

?>

Nathan__02

where there signup values are entered into database

<?php 
include("style.css");
include("config.php");

$query= mysql_query("INSERT INTO users VALUES ('$user','$pass')");

echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");

if ($query) {
echo("User added to the database!<BR>
      You can now login <a href='login.php'>here</a>.");
} else {
echo("User was not added to the database!<BR>
      Please try again <a href='signup1.php'>here</a>.");
}
echo("</font></center></body>")

?>

Nathan__02

<?php 

include("style.css");
include("config.php");

echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");
echo("<form action='members.php' method='post'>
      <table><tr><td>Login here.
                 <BR> If you haven't signed up already,
                 <BR> do so <a href='/game/signup1.php'>here</a>.</td></tr>
      <Tr><TD>Username:<input type='text' name=user class='field'></td></tr>
      <tr><td>Password:<input type='password' name=pass class='field'></td></tr>
      <tr><td><input type='submit' name='submit' value='Submit' class='formbutton'></td></tr>
      </table>
      </form>");
echo("</font></center></body>")

Nathan__02

and the problem members.php

<?php 

include("style.css");
include("config.php");

$query = "SELECT * FROM users WHERE username='$user' AND password='$pass';";
$result = mysql_query($query) or die(mysql_error());
echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");

$isAuth = false;

while($row = mysql_fetch_array($result))
{
if($row['username'] == $user)
{
$isAuth = true;
$fname = $row['fname'];
}
else
{
$isAuth = false;
}
}

if (!$isAuth) 
{
echo("Wrong Username or Password.<BR>
      Try again <a href='/game/login.php'>here</a>.");
} 
else {

if ($validate == 1){
$_SESSION['username']=$user;
echo("Game still in progress.");
} else {
echo("Sorry, we could not log into your account!");
}
}

echo("</center></body>");

?>

Nathan__02

not sure if thats wat ya mean but theres the codes...everything works except members.php

sizemik

<?php 

include("style.css");
include("config.php");

$query = "SELECT * FROM users WHERE username='$user' AND password='$pass';";
$result = mysql_query($query) or die(mysql_error());
echo("<body background='background3.JPG'>");
echo("<center><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>");

$isAuth = false;

while($row = mysql_fetch_array($result))
{
if($row['username'] == $user)
{
$isAuth = true;
$fname = $row['fname'];
}
else
{
$isAuth = false;
}
}

if (!$isAuth) 
{
echo("Wrong Username or Password.<BR>
      Try again <a href='/game/login.php'>here</a>.");
} 
else {

if ($isAuth == true){
$_SESSION['username']=$user;
echo("Game still in progress.");
} else {
echo("Sorry, we could not log into your account!");
}
}

?>


</body>
</html>

Nathan__02

thanks that works fine. but just a question since im still learning. whered u get fname from? cuz i dont have fname in my database.
Thanks for your help everyone.

sizemik

it just stands for first name
replace it with whatever the firstname field is in your db

Strabbler

Hi i dont understand what you are all saying here, so what i was thinking of doing, is , will one you people who has the login and register thing working can maby send me the files and all the files you need to make it work to me through this email addy

strabbler@hotmail.com

it will be greatly appreciated