How to calculate video bitrate from video size and length
Manually calculate the bitrate of a video from its file size and length. This can be done for both Megabits per second and Kilobits per second. Bitrate is the number…
Category: Development
Using the Yahoo finance stock API with PHP
Using the Yahoo finance stock API to firstly get stock ticker symbols and then the stock price with PHP. The Yahoo finance API is a fast and free method to…
Stringgy a free use string and int generator API
Stringgy is a free to use string and int generator API with customizable lengths, types, characters and amounts. With Stringgy you have the option for character length of string or…
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…
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…