PHP MySQL loop with Bootstrap 4 columns
Here is how to implement the Bootstrap grid system into a PHP MySQL foreach loop. The code is set to be 4 columns on large screens, 2 on small screens…
Tag: How to
How to do a MySQL GROUP BY with ORDER BY on a COUNT()
MySQL Group by returns the data of the same value into a set rows. It is often use with COUNT, SUM or AVG etc. Doing this will return how often…
Zip and Unzip files in Ubuntu
Zipping is the act of compressing a folder or files into one file (.zip) which can then be unpacked to return to the many files again. This is done for…
PHP MySQL PDO select foreach loop
Doing a loop through on a MySQL query is super useful and common. It allows you to make tables, rows and output data in a controlled manner without doing many…
Updating the Sony A6000 to 3.21 on Windows 10
19th March 2019 Sony A6000 firmware version 3.21 was released My current A6000 firmware is version 3.20 Version 3.21 link here: Sony doesn’t give a whole lot of information for…
PHP format and style MySQL DateTime
MySQL DateTime format is Y-m-d H:i:s known as Year-month-day hour:minute:second. It is the bare bones datetime format for both MySQL and PHP…. it contains all you need to know and…
Adding FFmpeg to system path Windows 10
Being able to use FFmpeg.exe without referencing its location or copying it into the folder you’re operating in is a huge piece of simplicity. Once FFmpeg is added to your…
PHP Making an easy way for MySQL inserts
A MySQL insert in PHP can be easily done however they can be long and tedious. Frustrating to essentially make a table and then repeat it again with an insert…
PHP check if file or directory exists
To check if a file exists you use the PHP function file_exists. Input the path to the file and it will return TRUE if the file exists otherwise FALSE. if…
Managing tags within a string with PHP
By tags I mean hashtags or “describers” often only just a single word but sometimes more. Handling them in PHP is different to most other variables as they’re often singular…