Expedition Pass Reservoir drone images
Expedition Pass Reservoir drone images. Oddly shaped and surrounded by steep wooded hills this pleasant looking reservoir can easily be covered by drone. Click images to view larger.
Forecast and current weather data with OpenWeatherMap API PHP
OpenWeatherMap provides a free tier weather API that is detail-packed and easy to use. The API outline can be seen here, In this post I will cover the current weather…
What is Aspect ratio?
Aspect ratio is the relationship between the width and height of an image or video dimensions. Aspect ratio is expressed by 2 numbers separated by a semi-colon. The most popular…
Mount Hope Victoria drone images
The enormous rock outcrop at Mount Hope Victoria as seen by drone. Kow Swamp and Pyramid Hill can be seen in the background.
PHP PDO INSERT on duplicate UPDATE
A MySQL INSERT on duplicate key UPDATE is an all-round excellent query because if a key already exists it will update set values instead of inserting or returning an error….
Show MySQL tables, column names, types and more with PHP
Showing a MySQL database tables with their columns, type, keys and more is done using the MySQL SHOW syntax. For the tables SHOW TABLES is used whilst to get the…
Brown Goshawk in tree
A Brown Goshawk which is possibly a juvenile, high up in a tree overlooking Waranga Basin.
Play to your strengths with your SEO
This concept is a simple one yet I have seen it rarely covered, piggyback on the success of your high ranking terms. Whether your link gained traction online, spread like…
PHP PDO MySQL cheat sheet
PHP PDO is a MySQL handler which uses object orientation. As PDO executes queries with prepared statements it is (with correct usage) safer than MySQLi. Below is the PHP PDO…
Changing video framerate with FFmpeg
Changing a videos frame rate can be easily done with FFmpeg. From the official FFmpeg documentation to change frame rate -filter:v fps=fps=25 is required. If inputvideo.mp4 was 60fps and I…