MySQL - automatically update row after5 min of inactivity (set expirat

[soniyabis]

Hi All

Can anyone help me, if user inactivity and update my datbase row automaticlly ( I mean time set if user inactivity or browser close )

Before login
  $sql = "UPDATE register set logged_in='1' WHERE (matri_id='" . $username . "' OR email='" . $username . "')";
        $DatabaseCo->dbLink->query($sql);


After login
  $sql = "UPDATE register set logged_in='0',last_login = '" . $_SESSION['login_time'] . "' WHERE matri_id='" . $_SESSION['user_id'] . "'";

$DatabaseCo->dbLink->query($sql);

[soniyabis]

Above code is working but user closed the browser and never loged out user is showing always online .

[rproffitt]

Looks like you need a cron job with your choice how often to run to log out users.

Also, look at this example to run Javascript code on window or browser close:
https://www.geeksforgeeks.org/how-to-detect-browser-or-tab-closing-in-javascript/

[AndrisP]

Create event in database MySQL event create