How to do this with PDO?

[3raser]

I don't have too much experience with PDO, but I want to remove all inactive users from online_users WHERE time() - time (table) > 480

 

$this->database->processQuery("DELETE FROM `online_users` WHERE ". time() ." - `time` > 480", array(), false);

 

I receive this error statement:

 

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in C:\wamp\www\OSREMAKE\structure\database.php on line 55

 

So which part requires the token? 

[smoseley]

480 what?

[smoseley]

PS - try PDO::query()

[3raser]

Edit: Never mind, it was a simple mistake on my behalf.

[smoseley]

Just FYI - always a bad idea to "DELETE" in a web application.

 

A better design for your system would be to have a table called  `sessions` (instead of `online_users`).

 

In sessions, store the user id, (php session id if you want) and time created.

 

To get `online_users`, just do "SELECT * FROM `sessions` WHERE `created` > NOW() - INTERVAL 8 MINUTE;"

 

To make it speedier, make `created` a clustered index.

 

By storing sessions indefinitely, you can also generate reports of user activity, know when people logged in last, how often they log in, etc.

 

And you never have to delete anything.