[PHP] Logout problems

[Kaz]

Basically once a user has logged in im using

$db->query("UPDATE users SET online = '1' WHERE username = '".$db->escape($row['username'])."'");

to update the users online status (this works)

However when i come to log out i have:

include('includes/core.php');

unset($_SESSION['user_id']);
unset($_SESSION['user_login_session']);
unset($_SESSION['user_ip']);

$db->query("UPDATE users SET online = '0' WHERE username = '".$db->escape($row['username'])."'");

header('Location: '.$site.'');

When i come to log out, it does not change my online status to '0' in the db field

Any ideas why this is happening?
I have looked around on google and 90% of most common answers are using the same as what i have

 

[Kryptos]

Change it to

include('includes/core.php');
die($row['username']);
unset($_SESSION['user_id']);
unset($_SESSION['user_login_session']);
unset($_SESSION['user_ip']);

$db->query("UPDATE users SET online = '0' WHERE username = '".$db->escape($row['username'])."'");

header('Location: '.$site.'');

What does it output?

 

[Kaz]

Originally it logged me out but didnt change the online field to 0

Using what you just give me, returns a white (blank) page with 127.0.0.1/logout as the url and hasnt logged me out

 

[Kryptos]

Ooops, fail.

Use the code in the above post of mine again(I edited), and tell me what it returns. Sorry for the mistake.

 

[Kaz]

exactly the same as before, i did replace 'name' with 'username' myself

 

[Kryptos]

Then $row['username'] is null, thus making the SQL query fail. Since it doesn't know the where to change 'online' from 1 to 0.

That's the problem.

 

[Kaz]

Right i have now added this in

include('includes/core.php');

unset($_SESSION['user_id']);
unset($_SESSION['user_login_session']);
unset($_SESSION['user_ip']);

$get_user = $db->query("SELECT username FROM users WHERE username = '.'username'.'");
if($db->num_rows($get_user)) {
$row = $db->fetch_array($get_user);
$db->query("UPDATE users SET online = '0' WHERE username = '".$db->escape($row['username'])."'");
}

header('Location: '.$site.'');

Yet its still not working, have i gone wrong somewhere?