codeignitercodeigniter-urlcodeigniter-datamapper

codeigniter - make a difference in the two dates with database

Help me .. !! I 'm in the final project , build a web with Framwork CodeIgniter . but I difficulty to make a difference in the control script , the examples I list dated 07.02.2015 and should regristasi before 3 days but I forgot to register so it appears the warning .. how to make

Solution

  • irwan you have to run cron job for check the date daily. By cron job run this code :

    $current_date=date('Y-m-d');
$date = strtotime($date);
$date = strtotime("+3 day", $date);
$adate=date=date('Y-m-d', $date); // this is after three days's date.

    then run the query:

    $this->db->where('date',$adate);
$q=$this->db->get('table');

    then do something(whatever you want like send mail or anything) if you get data from above query. Hope you got the point :)