How to update mysql table row every two minutes?

Question

I have a mysql members table. It have a column name of "lastonline". I want to update this column every two minutes in PHP. I think it would be possible through ajax time interval.Please advise me how to achieve this easily?

You are doing it *all* wrong. This is a horrendous idea. – Layke Nov 02 '11 at 12:34 — Layke, Nov 02 '11 at 12:34
is it ajax question or mysql question? – Your Common Sense Nov 02 '11 at 12:46 — Your Common Sense, Nov 02 '11 at 12:46

score 2 · Answer 1 · answered Nov 02 '11 at 12:49

If you're creating an AJAX application, you can simply log a "last_online" column that gets updated with a date every time the user request a page (either via AJAX or HTTP).

If you must do this with AJAX, Prototype offers a PeriodicalExecutor that you can use to send requests at a predefined interval:

score 0 · Answer 2 · answered Nov 02 '11 at 12:36

0

I do not recommend to do it via ajax, but to write a scritp ad hoc and run a cron every 10 minutes and you are upgrading.

answered Nov 02 '11 at 12:36

JellyBelly

2,451
2
21
41

1

sorry i want every 2 mins not every 2 secs. Please refer this link http://stackoverflow.com/questions/7964903/how-to-get-currently-logged-users-in-mysql. I want to know who are currently online – w3father Nov 02 '11 at 12:46

score 0 · Answer 3 · answered Nov 02 '11 at 12:40

0

Why don't you you update the "lastonly" column with every request a user makes? Do you really need the two-second resolution?.

answered Nov 02 '11 at 12:40

chiborg

26,978
14
97
115

How to update mysql table row every two minutes?

3 Answers3