Database Administration
Add a Foreign Key in MySQL
Add a foreign key in MySQL to link two tables and have the database enforce it, rejecting orphan rows while an ON DELETE CASCADE…
//
Author: admin
Database Administration
Create a MySQL Table From the Terminal
Create a MySQL table from the terminal with a single CREATE TABLE statement: typed columns, an AUTO_INCREMENT primary key, and sensible defaults, confirmed with…
Programming
Format Dates and Times in PHP
Format, parse, and compare dates with PHP's built-in DateTime class. format() prints any layout, createFromFormat() reads non-standard strings, and diff() measures the gap between…
Programming
Register a Custom Taxonomy in WordPress
Group your WordPress content your own way, beyond the built-in categories and tags. register_taxonomy() on the init hook creates a hierarchical Topic taxonomy —…
Server Administration
Create an Apache Virtual Host
Create an Apache virtual host to serve multiple sites from one Apache install. Define a block with ServerName and DocumentRoot, add a hosts-file entry,…
Programming
Add a Custom Meta Box in WordPress
Give the WordPress post editor an extra field of your own — a short "key takeaway" saved with each post. A small plugin adds…