Apache alias; Map URL to a filesystem location
Apache alias is the method to use the filesystem other than under the document root. Setting an alias directory with Apache means that when going to the specified URL path…
How to attach BuyVM Block storage slabs
A simple method and guide to attaching BuyVM storage disk slabs to your VPS. This post uses a 3TB disk slab and VPS running Ubuntu 20.04. Firstly make sure your…
How to POST JSON data with PHP
How to POST JSON data or a file in PHP including receiving the POST request and saving it to a file. This is done with the easy to use PHP…
How to validate a date with PHP
A simple method to validate a date or check the date is true to the Gregorian calendar in PHP by defining the month, day and year. PHP checkdate() will return…
The Relational database model
The Relational database model or schema is one that uses many tables that are all related to each other, hence the relational name tag. With the data all being related…
Load and execute SQL files with PHP
How to load a SQL query from a file instead of having an inline query. This is done to help with formatting and easier understanding of the code. All that…
Doing MySQL insert from a PHP loop the right way
Effectively manage PHP MySQL inserts from a large loop using the PDO connection. The key is to avoid committing data on each loop, this is done using a transaction. Use…
Lake Eppalock Derrinal Pool drone images
Drone images of Derrinal Pool, Moorabbee Bluff and Mt Ida inlet Lake Eppalock with the old wood bridge. Lake level at 37% Click images to view larger.
How to enable GD Library with XAMPP PHP 8 on Windows
How to enable the GD image library for PHP 8 with XAMPP on Windows. All that’s needed is a simple php.ini file edit. Enable GD PHP 8 XAMPP To enable…
PHP PDO MySQL backup script with compression option
Modern PHP PDO MySQL database backup script which includes a gzip compression option. Modified from this Stack Overflow post, the script is easy to use with configurable options for the…