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…
Tag: How to
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…
How to disable SSH password login on Ubuntu
How to disable normal username/password login authentication to your Ubuntu server, only allowing SSH key authentication. This gives you the advantages of SSH’s whilst securing your server that little bit…
Guide to create and setup a Valheim multiplayer server on Windows with SteamCMD
A guide to installing and setting up a Valheim dedicated multiplayer server using SteamCMD on a Windows server. Using a dedicated server compared to a local server setup means you…
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…
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…
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…
Setup and install Rust server on Windows server 2019 with SteamCMD
An easy to follow guide on installing and setting up a Rust server using SteamCMD. This guide was made on a Windows Server 2019 VPS from Vultr with SteamCMD. It…
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…