Catching PHP PDO exceptions
How to handle PHP PDO exceptions with the try and catch method to control the flow of any potential errors with PDO connections and queries. The try and catch exceptions…
Category: Development
PHP PDO MySQL Cheat sheet guide
PDO is a PHP extension for accessing and interacting with databases using object-orientation. As PDO is targetted for executing queries with prepared statements it is (with correct usage) safer than…
Downloading all files and folders with Wget
Guide for downloading all files and folders at a URL using Wget with options to clean up the download location and pathname. A basic Wget rundown post can be found…
A guide to upscaling or downscaling video with FFmpeg
How to do video scaling using FFmpeg with examples for different types of upscaling and downscaling methods. Scaling a video means to make it either larger (higher resolution) or smaller…
Testing the new Bunny.net video streaming service
A look at the soon to be released bunny.net (formally BunnyCDN) video streaming CDN service. Simply labelled for now as “video” you can upload video files to have them be…
Authenticating and protecting Ajax requests with PHP
Methods to authenticate and protect jQuery Ajax calls with PHP. This prevents external access and usage to your web app. Method 1: Tokens Method 1 is using tokens set via…
MySQL UPDATE from a SELECT WHERE query
How to do a MySQL table UPDATE from a SELECT WHERE query. A handy command which uses JOIN inside an UPDATE. This command will update the status table and set…
Moving gradient text with CSS
Some simple animated gradient text with CSS which is more attention-grabbing than just plain, stationary coloured text This method utilizes the CSS animation property. CodePen link. The CSS h1 {…
Bootstrap sticky first column, horizontal scrolling table
Making a horizontal scrolling table where the first column is sticky and stays in place. Tables are fine to an extent but once you start having more than a few…
Vanilla Javascript basics; Adding and removing classes
Adding and removing classes to HTML elements with vanilla Javascript. Also included is a toggle and replace method. Adding a class name to an element with classList.add() document.getElementById(“theId”).classList.add(“green-text”); Add multiple…