Proper PHP session garbage collection syntax?

Question

I have a custom GC Session method set that should delete any old sessions out of my database. Here is the func:

    public function gc($max){
      // Calculate what is to be deemed old
      date_default_timezone_set('America/Chicago');
      $old = time() - $max;

      // Set query
      $this->db->query('DELETE * FROM session WHERE access < :old');

      // Bind data
      $this->db->bind(':old', $old);

      // Attempt execution
      if($this->db->execute()){
        // Return True
        return true;
      }

      // Return False
      return false;
    }

The $max var represents the session.gc_maxlifetime value in my php.ini. Here are the garbage collection settings in my .ini:

session.gc_probability = 1
session.gc_divisor     = 100
session.gc_maxlifetime = 1440

However whenever this function runs, I always get the following Fatal Error:

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM Sessions WHERE access < 1482965344' at line 1' in /Applications/MAMP/htdocs/demo/DB.php:66

Can't help but feel like I am missing something trivial...Any suggestions?

`right syntax to use near '*` it told you where the error starts; your query is invalid. — Funk Forty Niner, Dec 29 '16 at 00:13
You were using the correct syntax in your other question http://stackoverflow.com/q/39928440/1415724 `DELETE FROM session` so why are you doing `DELETE *` now? — Funk Forty Niner, Dec 29 '16 at 00:43

score 1 · Answer 1 · answered Dec 29 '16 at 00:12

1

You should use:

'DELETE FROM session WHERE access < :old' as your DML string.

Remove the *.

answered Dec 29 '16 at 00:12

Hicaro

687
2
8
21

score 0 · Accepted Answer · answered Dec 29 '16 at 00:20

0

Your SQL Query is wrong. There is no * between DELETE and FROM. Just use this line:

$this->db->query('DELETE FROM session WHERE access < :old');

answered Dec 29 '16 at 00:20

gseidel

321
2
9

Proper PHP session garbage collection syntax?

2 Answers2