CODEWITHSUNDEEP
phpsession
allan paculan
allan paculan

Reputation: 11

session variable not updating

please check my code below.when I logout does not save in my logout column in mysql.

$query = $DBcon->query("UPDATE logs SET logout = now() WHERE id={$_SESSION['userSession']}");

but when I changed to 

$query = $DBcon->query("UPDATE logs SET logout = now() WHERE id='12'");

it works.

Thank you guys.

Upvotes: 0

Views: 2314

Answers (1)

kourouma_coder
kourouma_coder

Reputation: 1098

You need a session_start(); (at the top of script) before using $_SESSION related stuff; Try this :

    if(session_status() == PHP_SESSION_NONE){
        session_start();
    }
    require_once 'dbconnect.php';


    if (!isset($_SESSION['userSession'])) {
        header("Location: login.php");

    }else if(isset($_SESSION['userSession'])!=""){
        header("Location: index.php");
    }

   if(isset($_GET['logout'])) {
      $query = $DBcon->query("UPDATE logs SET logout = now() WHERE id=  {$_SESSION['userSession']}");

    mysqli_query($query);

    unset($_SESSION['userSession']);
    session_destroy();
    header("Location: login.php");
}

Upvotes: 1

Related Questions