I came across a problem today where I needed to convert a date in an MS Access Database to a MySQL timestamp using PHP. The solution was pretty easy, but took some thinking through. Here is the answer to save you some time if you need it. Get the date from your MS Access database. If you're using PHP to do this, you'll likely use the odbc_exec($connection, $query) function and the odbc_fetch_array() function. Convert the MS Access date format into a UNIX Timestamp using PHP's strtotime() … [Read more...]
database
Convert MS Access Date to Unix Timestamp to MySQL Timestamp
June 9, 2011 By Aaron Brown
Filed Under: Web Development Tagged With: database, handling dates, MS Access, MySQL, MySQL Timestamp, PHP, PHP Date, Unix Timestamp
WordPress wp_postmeta meta_keys
December 2, 2010 By Aaron Brown
wp_postmeta meta_keys I recently needed to know the default key names WordPress uses in the wp_postmeta table. This information is found in the 'meta_keys' field of the wp_postmeta table. I put this list together for my reference and in case anyone else is also in search of the native wp_postmeta meta_keys. For a detailed description of the wp_postmeta table, fields, and entity relationship diagram (ERD), go here. The keys used by WordPress as of 3.0.1 … [Read more...]
Filed Under: Web Development, WordPress Development Tagged With: database, post_meta, wordpress