PHP converting hours, minutes & seconds string to seconds
Converting hours, minutes and seconds (H:i:s) string to just seconds with PHP can be done with an adaptable function that also works for just a minutes and seconds string. The…
Tag: How to
MySQL rollback with PHP PDO
Roll back a MySQL transaction with the PDO rollBack() function. All that is needed is beginTransaction. Start a transaction and run a query that modifies a table: $db->beginTransaction(); $update =…
Random time from timestamp string with PHP
How to generate a random time from an H:i:s formatted timestamp with PHP. For this example 02:38:55 will be used which represents 2 hours, 38 minutes and 55 seconds. The…
Speed up and slow down video with FFmpeg
How to speed up or slow down video using FFmpeg. -filter:v “setpts=” Is the method to achieve this. The documentation states that for fast motion: -filter:v setpts=0.5*PTS Slow motion: -filter:v setpts=2.0*PTS In…
How to calculate 16:9 aspect ratio
The calculation for a 16:9 video resolution aspect ratio, given the width or height value. Read up about the 16:9 aspect ratio. Calculating width To calculate the 16:9 width for…
Leaflet map latitude and longitude marker with PHP
How to make a simple Leaflet map box with a marker at your set latitude and longitude values. Leaflet is a free, open-source javascript library for working with interactive maps….
Getting image EXIF data with Ubuntu
Getting image EXIF data on Ubuntu can be done with Exif, this is an Ubuntu package that can output and change JPEG EXIF data. Installing is done with: sudo apt-get…
Using PHP __DIR__
PHP __DIR__ returns the current working directory, its usage is common when including files as you don’t have to dynamically define the directory each time. Simply running echo __DIR__; Will…
Bootstrap toggle button status update with AJAX PHP and MySQL
How to make a Bootstrap toggle button with a status update by using PHP, Ajax and MySQL. The toggle button represents on/off which is 1 and 0 in the database….
Automatically overwrite file if already exists with FFmpeg
Automatically overwrite a file if already exists with FFmpeg by using -y which means overwrite files without asking: ffmpeg -i input.mp4 -c:v libx264 -crf 25 -preset fast -y output.mp4 The…