Example #1
0
 /**
  * Garbage Collector
  * @param int life time (sec.)
  * @return bool
  * @see session.gc_divisor      100
  * @see session.gc_maxlifetime 1440
  * @see session.gc_probability    1
  * @usage execution rate 1/100
  *        (session.gc_probability/session.gc_divisor)
  */
 public static function gc($max)
 {
     dbcommit("delete from sys_sessions where unix_timestamp(lastupdate) + " . $max . " < unix_timestamp(now())");
     return true;
     $sql = sprintf("DELETE FROM `sessions` WHERE `session_expires` < '%s'", mysql_real_escape_string(time() - $max));
     return mysql_query($sql, self::$_sess_db);
 }
Example #2
0
function dbdelete($table, $where = [1 => 0])
{
    $whparts = [];
    foreach ($where as $k => $v) {
        $whparts[] = $k . ' = "' . mysqli_real_escape_string($msq, $v) . '"';
    }
    $q = "delete from " . $table . " where " . implode(" and ", $whparts);
    return dbcommit($q);
}