Generate MySQL Datetime Type Using PHP Date() Function
If you want to insert a datetime that matches the default mysql datetime type format use this
date('Y-m-d H:i:s');
Written by Sean Behan on 06/17/2012
Postlearn Job Board
Postlearn is a job board focused on delivering quality jobs listings to people in education.
An affiliate program is available to bloggers and site owners in the edu space. Bloggers who participate receive a percentage of referrer sales. A widget display...
Written by Sean Behan on 06/17/2012
How to import CSV into SQLite3
To import a CSV file into SQLite is easy.
sqlite3 my.db
.mode csv
.import path/to/file.csv name_of_table
And done.
Written by Sean Behan on 12/03/2017
Get Child Categories of Parent Category on Single Post in Wordpress
I was hoping to find a function in the Wordpress API, that goes something like this...
the_child_categories("Vermont");
// print Burlington, Brattleboro... etc if this post has any child categories of Vermont
But I could not. The result that I did ...
Written by Sean Behan on 06/17/2012
Roll Your Own Session Based Flash Messaging w/ Sinatra
Session based flash messages are fairly common in web apps. They work well when you have a temporary status to report back to the user, such as successfully saving a form.
If you use Rails it comes with the Framework. If you are using Sinatra there ar...
Written by Sean Behan on 11/01/2013