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 =…
Category: Development
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…
Convert and format Bytes PHP function
A simple PHP function to convert and format Bytes to Megabytes, Gigabytes and Terabytes: function convertBytes(int $bytes, string $convert_to = ‘KB’, bool $format = true, int $decimals = 2): float…
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….
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…
How to make cron jobs from Windows task scheduler
How to create cron jobs on Windows server with the Windows task scheduler. The first step is to open Windows task scheduler and click Create Task The first step under…
Removing duplicates from an array in PHP
Removing duplicate values from an array in PHP by using array_unique(), this will return a new array, based on the input without duplicate values. The second parameter is sort type,…