PHP: Session not working

[drummer392]

OKay. So I am using the same server and coding that I always use to connect to the database and start a session when a user logs into a CMS I have. Now, all I have done is copy all of the files onto another domain like I usually do, but this time it's not working. I am pretty sure that the session is not holding for some reason because I told it to send me to a certain spot if there is not a session currently started on the index page.

Maybe something is wrong with my code?

This is the submit page from the login that should make the session start and usually holds is across multiple pages:

PHP Code:

<?php
$username = "user";
$password = "pass";
$database = "db0";
$hostname = "host"; 

//connection to the database
$handle = mysql_connect($hostname, $username, $password, $database)
 or die("");
echo "";

//select a database to work with
$selected = mysql_select_db("db0",$handle)
  or die("Could not select db0");

session_start();
$usernamelog = $_POST['username'];
$passwordlog = sha1($_POST['password']);
$query="SELECT username,password FROM users WHERE username='".$usernamelog."' and password='".$passwordlog."'";
$result = mysql_query($query) or die(mysql_error() . " ------ " . $query);


if(!$result) {
$err=mysql_error();
print $err;
exit();
}
if(mysql_affected_rows()==0){
header('Location: login2.php');

exit();
}
else{
$_SESSION['username2009'] = $usernamelog;
$variable = $_SESSION['username2009'];
$result = mysql_query("SELECT is_admin FROM users WHERE username = '$variable'")
or die(mysql_error());  
$data = mysql_fetch_array($result, MYSQL_BOTH);

if ( $data['is_admin'] == 0 ) {
header('Location:  URL');
echo $data['is_admin'];
}
else if ( $data['is_admin'] == 1) {
header('Location: URL');
} 
else if ( $data['is_admin'] == 2) {
header('Location: URL');
}
}
?>

And here is the index.php page that sees if there is a session:

PHP Code:

if(!$_SESSION['username2009']){
    include ("URL");
    exit();
} 


Thanks so much. I am really stressing on this because it always works!

[simplistik]

hrmm ... i think your if else statement is wrong. i could be mistaken but i think

mysql_affected_rows()==0

is the problem. i THINK mysql_affected_rows() only works if you did some sort of manipulation to the database, e.g. delete,insert or update. at least that's the only i've ever used it, or even seen it used. what you want if you're doing a regular select query is

mysql_num_rows() == 0

----------------

this won't affect the session but i'd also suggest not using MYSQL_BOTH in your fetch. chances are you will never use something like

$data[0]

over

$data['is_admin']

just stick w/ MYSQL_ASSOC

[drummer392]

hmm. You were right about being mistaken, but it's cool. That just made it not find the information in the database and tell so. lol.

The problem is, I have just copied the same login code that always works on the same 1and1.com hosting service. Then when I login, the index page sees if there was a session started. But it always redirects me now. All my other CMS's are still working fine.

To make matters more interesting, I tried doing a cookie, and that didn't even work. I have read something about the php.ini file maybe not functioning properly?

Anyhow, thanks for reading simplistik, I know I am just a mediocre PHP programmer, but I am learning!

[simplistik]

then i guess you should start small and make a tiny script that just tries to set a session

PHP Code:

<?php
session_start();
$_SESSION['foo'] = 'bar';
?>

and then check to see if it set

[drummer392]

weirdest thing just happened...it started working. I didn't change anything...hmm

[simplistik]

Originally Posted by drummer392

hmm. You were right about being mistaken, but it's cool. That just made it not find the information in the database and tell so

cause you didn't use the function right then ... it should be mysql_num_rows($result) if you're doing that

[drummer392]

haha...okay man. I will fix that too! I really appreciate your help!