Blog Post Editor: Setting Publish Date

Posted Oct 27, 2014

Setting Publish Date and Time to Display Blog Post

Based on the view I created, the publishAt datetime field can have a value of NULL, so a NULL value allows me to save the post, without it publishing to the site. Then I can come back later and continue working on this post until I feel ready to publish it live.

cvazquezblogcake.posts View

https://github.com/cvazquez/CarlosVazquez.org-CakePHP/blob/master/databases/cvazquezblogcake/cvazquezblogcake.sql

The view is pointing to this table:

 

Portfolio-BlogAdmin-Step2

 

Read more posts in the Blog Post Editor series:

Discussions

New Comment














Latest Discussions

  • Carlos: Thank you!
    May 16, 2014 | Replies (0)
  • Jessica: Great info, thanks!
    May 15, 2014 | Replies (1)
  • Walter: Thanks, you totally saved me a bunch of searching around just now. I was setting up a percona xtradb...
    Feb 25, 2014 | Replies (0)
  • Avi: I've found the reason of the problem in my case. It's a bug as described here :http://bugs.mysql.com/bug.php?id=68892Shortly:...
    Dec 12, 2013 | Replies (0)
  • Avi: I've also met that behavior twice on 5.6.12 slaves. However, i didn't find the root cause of that....
    Dec 12, 2013 | Replies (0)