The best PHP MySQL SELECT and UPDATE loop
Testing 3 Types of MySQL SELECT and then UPDATE from an API call loops with PHP for speed, efficiency and ability to scale. The idea is needing to select a…
Category: Development
FFmpeg encode percentage progress bar with PHP
Using an HTML progress bar to view FFmpeg video encode progress percentage, With the usage of Ajax and PHP to parse the FFMpeg output file. This method enables a web-based…
PHP Live search from MySQL with AJAX
Creating a live search input form that matches the current input against a MySQL database using AJAX and PHP combined. I needed this to suite a “product select” project whereby…
PHP str_contains() is born
Early 2020 there was this post on /r/PHP posing the question “With so many features added to PHP, why is there no str_contains?”. flippeeer who submitted this post is right,…
PHP ternary operator; shorthand conditional statements
The Shorthand ternary operator in PHP is a much more compressed and essentially one line equivalent to the traditional tabbed if-else comparison that can easily span several lines. The ever…
Using Find in Linux
A method to find files on a Linux system is with the well named find command, find allows for certain parameters to be passed allowing for a more specialized and…
Simple PHP user register and login class
Featuring PHP OOP design with injection safe PDO MySQL queries, this easy to read class for a user registration, login and logout system serves as a backbone to any user/account…
Adding audio to a video file with FFmpeg
Adding an audio file to a video with FFmpeg, this is achieved with mapping. The key to this is mapping. Video files can contain more than just a video and…
MySQL SELECT before or after a datetime
Filtering a MySQL SELECT query based on a DateTime being before, after, within or older than is a common need. It can be done a few ways with plenty of…
Adding metadata to a video or audio file with FFmpeg
Depending on a video or audio container it can store various metadata or information like title, description, year, author, episode, album, track etc. Using FFmpeg to add this metadata to…