php - MySQL trigger when today's date matches due date -

php - MySQL trigger when today's date matches due date -

i'm developing application in cakephp 2.4.7

i have mysql database , i've come necessity of triggering update when sistem's date , hr matches due date have in table.

the table i'm using following

create table applied_surveys (id char(36) not null primary key, display_name varchar(200), area_id char(36) not null, survey_id char(36) not null, sistem_user_id char(36) not null, code varchar(50), init_date date, due_date date, init_hour time, due_hour time, completed int, state tinyint default 1, max_responders int, created date, modified date, foreign key (area_id) references areas(id), foreign key (survey_id) references surveys(id), foreign key (sistem_user_id) references sistem_users(id));

as can see, i'm using init date/hour , due date/hour. intention here add together survey , set due date. when due date , hr reached sistem must alter status(state) value 0, meaning survey has been closed.

i'm integrating database cakephp application, i'm not sure should programme logic situation.

you can't write "sistem", it's system.

you need run cron job every second/minute/hour, or whatever prefer, check each record , see ones later scheme date. can't expect run @ time dates become same, if business relationship seconds.

you can read cron jobs here : http://code.tutsplus.com/tutorials/managing-cron-jobs-with-php--net-19428

php mysql date cakephp triggers