Caching a MySQL HTML table with PHP
MySQL and PHP, the perfect match right?! Well close enough, anyway displaying a table with data from a MySQL database is a common task for a web developer. It’s easily…
Category: Development
PhpStorm Tips in Gifs; Handy!
I came across PhpStorm Tips when browsing medium and I wanna speak about it with two parts. The first part is how handy it is for PHPstorm users to check…
Defining color variables in CSS
CSS can at times become confusing or hard to work in and edit, especially color codes. A well designed website will have similar color codes due to shading and lighter…
Taking a screenshot with FFmpeg
To take a screenshot or save a frame as an image with FFmpeg here is the basic command: ffmpeg -ss 01:10:35 -i invideo.mp4 -vframes 1 -q:v 3 screenshot.jpg -ss is…
Inspect a CSS hover element in chrome dev tools
Here is how to view the CSS hover state for an element with the Chrome developer tools and element selector. Once in Google Chrome and at your webpage, Open the…
How to add a tab icon in html
The little icon that sits before the tab title text is called a favicon. A favicon can be in png or ico format, with png being supported by all browsers…
MYSQL get Max and Min for each day
To get the Max and Min value of a column for each day in MYSQL with a WHERE clause: SELECT DATE(t.datetimecol), MAX(t.col1), MIN(t.col2) FROM TABLENAME t WHERE id = 1…
Now is an excellent time to use Vultr
Vultr recently announced that for new users it will match dollar for dollar in credits. If you put $40 onto your Vultr account you will now have $80 to use,…
Formatting and handling date time in PHP
Handling and formatting dates and times in PHP is quite common, that’s why PHP has a mass of inbuilt functions to use here is the list. In this post are…