Re: updating table field by date

Chris,

Just to help you out instead of the giant mktime string you have you can also use strtotime().  Within the function you can simply do strtotime('+30 days') which will do the same thing as above.

On Wed, Dec 19, 2012 at 2:39 PM, Chris <chris69m@yahoo.com> wrote:

hi cricket,.... thank you for your response 

I have another approach to it,... on the click to advertising banner and/or link thru function (link goes thru function), and checks and compare  "featured_end" date with today's date,... and if it less than today's date it resets table. 

here is the function,... just in case anyone needs it: 

  function featured($id = null)

  {

    if(!($dba = $this->Dba->findById($id)))

    {

      $this->flash('error', ucfirst(i18n::translate('dba not found')));

      $this->redirect('/not_found');

    }

    elseif(!($user = $this->User->findById($dba['Dba']['user_id'])))

    {

      $this->flash('error', ucfirst(i18n::translate('user not found')));

      $this->redirect('/not_found');

    }

    else

    {

$today = date('Y-m-d H:i:s');

    if($dba['Dba']['featured_end'] <= $today)

    {

      $dba['Dba']['featured'] = 0;

      $dba['Dba']['featured_start'] = NULL;

      $dba['Dba']['featured_end'] = NULL;

      $this->Dba->save($dba);

      $this->redirect('/');

    }

        $this->redirect('/dbas/view/' . $dba['Dba']['id']);

    }    

 }

On Wednesday, December 19, 2012 11:11:07 AM UTC-8, cricket wrote:

Create a shell task to fetch all records with featured == 1 and
end_date in the past. Run a cron job at midnight to call it.

On Wed, Dec 19, 2012 at 6:22 AM, Chris <chri...@yahoo.com> wrote:
> hi guys,... can anyone help please
>
> I'm building promotional advertising feature on a site,...
> and have a table fields: "featured_start" once the user is call the function
> and "featured_end" after 30 days:
>
> $dba['Dba']['featured'] = 1;
> $dba['Dba']['featured_start'] = date('Y-m-d H:i:s');
> $after_30 = mktime(date("H"), date("i"), date("s"), date("m"), date("d")+30,
> date("y"));
> $dba['Dba']['featured_end'] = date('Y-m-d H:i:s', $after_30);
>
> now I want to set $dba['Dba']['featured'] = 0; after 30 days,
> and reset "featured_start" and "featured_end" to NULL
> so the promotion can stop,...
>
> how can I this,...?
>
> thanks in advance
> chris
>
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.

> To post to this group, send email to cake...@googlegroups.com.

> To unsubscribe from this group, send email to

> cake-php+u...@googlegroups.com.

> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>
>

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
 
 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.