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…
//
Tag: Command Line
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,…
Database Administration
Join Tables in MySQL
Join tables in MySQL to combine related rows in a single query. Learn INNER JOIN for matches, LEFT JOIN to keep unmatched rows, table…
Programming
Hash and Verify Passwords in PHP
Hash and verify passwords in PHP with password_hash() and password_verify(). Store a secure bcrypt hash, check logins against it, and upgrade old hashes automatically…
Server Administration
Enable mod_rewrite in Apache
Enable mod_rewrite in Apache to turn ugly query strings into clean URLs. Load the module, allow .htaccess overrides, then add one RewriteRule so a…
Programming
Resize an Image in PHP
Resize an image in PHP with the GD extension. Load the source, create a smaller canvas, and copy the pixels across with imagecopyresampled() to…