Executing SQL via PHP after a certain time

Question

Thanks for at least looking at this question.

I run a small website which allows people to sign up for a premium account. I control this via a group in an SQL database. So if group_id is 5 is premium. Currently I update this all manually but I'd like to have a php script that connects to SQL where a date is stored for when the account expires which'll just change the group_id back to 4.

If anyone can help I'd really appreciate it, or if you need any more information please ask :).

AndrewR · Accepted Answer · 2012-03-08 19:32:57Z

1

This is the kind of thing a cron job is perfect for. Write a php script that does the changing of the group_id based on the date, and set up a cron job to run the script at regular intervals.

answered Mar 8, 2012 at 19:32

AndrewR

6,7781 gold badge26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

StiveKnx · Accepted Answer · 2012-03-08 19:32:54Z

0

Using cronjobs, check this tutorial: http://net.tutsplus.com/tutorials/php/managing-cron-jobs-with-php-2/

Just check if the account is expired, run the cron 2 times a day ...

answered Mar 8, 2012 at 19:32

StiveKnx

3204 silver badges14 bronze badges

Comments

Churk · Accepted Answer · 2012-03-08 19:32:55Z

0

Update table set group_id = 4 where date('xxxxxxxx') < [what ever date you enter];

answered Mar 8, 2012 at 19:32

Churk

4,6475 gold badges26 silver badges40 bronze badges

Comments

Peter Kiss · Accepted Answer · 2012-03-08 19:33:09Z

0

CRON? Or if that isn't available then you can create some logic based on the logins to your page (check the expired account on every login).

answered Mar 8, 2012 at 19:33

Peter Kiss

9,3292 gold badges25 silver badges38 bronze badges

Comments

Ben D · Accepted Answer · 2012-03-08 19:34:25Z

0

You can run a PHP script as a cron job if you're using linux or as a scheduled task if you're using Windows.

answered Mar 8, 2012 at 19:34

Ben D

14.6k3 gold badges48 silver badges59 bronze badges

Comments

Your Common Sense · Accepted Answer · 2012-03-08 19:35:08Z

0

Why can't you just check the expiration time in your query instead of group, like everyone else do?

answered Mar 8, 2012 at 19:35

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Collectives™ on Stack Overflow

Executing SQL via PHP after a certain time

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related