[SOLVED] PLEASE HELP

[Letterbomb05]

Hello,

I really need this Login Script completed, and I haven't got it working in the past 5 days, and I'm getting very frustrated!!!

My problems are:

A) As far as I'm aware, the SESSION doesn't get set

B) When I login with the correct details, all that really happens is the page gets refreshed, I don't get take to info.php or anything!

 

PLEASE HELP!

 

Code:

 

<?php
// start of login script

// database information
$dbhost = "localhost";
$dbname = "";
$dbuser = "";
$dbpass = "";

// connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

// start session
session_start();

// retrieve form input
$username = htmlentities(mysql_real_escape_string($_POST['username']));
$password = (md5($_POST['password']));

// query the database
$query = "SELECT * from users WHERE username='$username' and password='$password'";
$result = mysql_query($query);

$aAssoc = mysql_fetch_assoc($result);
$rank = $qAssoc['rank'];

if(mysql_num_rows($result) === 0 || $aAssoc['rank'] == 0){
include('incorrect.php');
}else{
if($rank = 1){
	$SESSION['registered'] = true;
}
if($rank = 2){
	$SESSION['member'] = true;
}
if($rank = 3){
	$SESSION['moderator'] = true;
}
if($rank = 4){
	$SESSION['admin'] = true;
}
header("Location: info.php");
}

// end of script
?>

[DeanWhitehouse]

session_start();

need that at the begging of the code. on the first line

[Letterbomb05]

Is that all thats wrong..? I mean i have session_start() on all other pages

[DeanWhitehouse]

should be ,and change the header to a complete address like

header("Location:http://".$_SERVER['HTTP_HOST']."/info.php")

[phpzone]

$rank = $qAssoc['rank'];

 

This line should be:

 

$rank = $aAssoc['rank']

 

and all lines like

 

if($rank = 1){

 

should be :

 

if ( $rank == 1 ) {

[Letterbomb05]

lol @ that first one, I'm sorry I'm tired and I always miss small little things like that. I'll edit this post in a sec and see if there is any progress.

[Letterbomb05]

still does the same as before:

 

<?php
session_start();

// database information
$dbhost = "";
$dbname = "";
$dbuser = "";
$dbpass = "";

// connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

// retrieve form input
$username = htmlentities(mysql_real_escape_string($_POST['username']));
$password = (md5($_POST['password']));

// query the database
$query = "SELECT * from users WHERE username='$username' and password='$password'";
$result = mysql_query($query);

$aAssoc = mysql_fetch_assoc($result);
$rank = $qAssoc['rank'];

if(mysql_num_rows($result) === 0 || $qAssoc['rank'] == 0){
include('incorrect.php');
}else{
if ( $rank == 1 ) {
	$SESSION['registered'] = true;
}
if ( $rank == 2 ) {
	$SESSION['member'] = true;
}
if ( $rank == 3 ) {
	$SESSION['moderator'] = true;
}
if ( $rank == 4 ) {
	$SESSION['admin'] = true;
}
header("Location:http://www.team-recoil.com/newtemplate/info.php");
}

// end of script
?>

[BlueSkyIS]

for the record: session_start() doesn't necessarily have to be at the beginning of the code.

[Letterbomb05]

really need help, PLEASE someone help me sort this out >_>

[BlueSkyIS]

update to this and see what you get in query:

 

$result = mysql_query($query) or die(mysql_error());
echo "query: $query";

[peranha]

This line

 

$rank = $qAssoc['rank'];

 

needs to be

 

$rank = $aAssoc['rank'];

[BlueSkyIS]

already noted by phpzone, above.

[Letterbomb05]

BlueSkyIS, I did what you said but nothing happened.

[peranha]

already noted by phpzone, above.

 

yes, but the code posted after does not have it changed in it.  So just making sure it is changed.

[BlueSkyIS]

thanks, peranha!

 

BlueSkyIS, I did what you said but nothing happened.

 

you don't see query: or anything?

???

 

can you post the latest code?

 

 

[Letterbomb05]

1 second just noticed something

[phpzone]

It would have died before printing the query because of the die(mysql_error())

 

No message from mysql_error() ?

 

the echo would need to be before the statement is executed, but there should be an error dumped

 

try adding the following to the top of your script:

 

       error_reporting( E_ALL );
       set_ini('display_errors','On');

[Letterbomb05]

Nope everything is pretty much in the same state it was earlier

 

latest code:

 

<?php
session_start();

// database information
$dbhost = "";
$dbname = "";
$dbuser = "";
$dbpass = "";

// connect to database
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

// retrieve form input
$username = htmlentities(mysql_real_escape_string($_POST['username']));
$password = (md5($_POST['password']));

// query the database
$query = "SELECT * from users WHERE username='$username' and password='$password'";
$result = mysql_query($query) or die(mysql_error());
echo "query: $query";

$qAssoc = mysql_fetch_assoc($result);
$rank = $qAssoc['rank'];

if(mysql_num_rows($result) === 0 || $qAssoc['rank'] == 0){
include('incorrect.php');
}else{
if ( $rank == 1 ) {
	$SESSION['registered'] = true;
}
if ( $rank == 2 ) {
	$SESSION['member'] = true;
}
if ( $rank == 3 ) {
	$SESSION['moderator'] = true;
}
if ( $rank == 4 ) {
	$SESSION['admin'] = true;
}
header("Location:http://www.team-recoil.com/newtemplate/info.php");
}

// end of script
?>

[Letterbomb05]

It would have died before printing the query because of the die(mysql_error())

 

No message from mysql_error() ?

 

the echo would need to be before the statement is executed, but there should be an error dumped

 

try adding the following to the top of your script:

 

       error_reporting( E_ALL );
       set_ini('display_errors','On');

 

Where should I put that snippet?

[phpzone]

You might need a space after "Location: "

 

Perhaps.

[Letterbomb05]

PHPzone, where abouts should I put the snippet you gave me?

[phpzone]

 

 

Where should I put that snippet?

 

"try adding the following to the top of your script:"

 

       error_reporting( E_ALL );
       set_ini('display_errors','On');

 

 

[Letterbomb05]

ugh, sorry, tiredness lol, I'll try that, one second.

[phpzone]

 

 

Yeah, a good sleep and some Zen meditation usually helps

[Letterbomb05]

Still have absolutely nothing.