Storing and reading a JSON file in MySQL with PHP
Storing values from a json output into a database is a common occurence, but storing the whole json call into a column not so much. Traditionally it is more efficient…
Tag: How to
FFmpeg choosing stream to download
With most online streams, decent ones at least you can choose the quality. The stream quality is mostly bit rate and resolution based. Lowering the resolution means you can lower…
Creating a dynamic captcha image with PHP
Sick of my contact form being used as an express way for spammers i set about to make a solution to end the spam to which i was surprised still…
Full install and setup of Apache, PHP, MySQL, SSL and FTP Ubuntu 18.10
How to install a full web server setup on Ubuntu 18.10 x64. This will also work on other versions of Ubuntu such as 18.04 and 16.04 x64. Installing Apache with…
How to have a batch file to mass check ping locations
Here is a simple ping command in a batch file that allows you to add servers/addresses to ping and it will return the ping time for all at once. An…
MySQL count for multiple conditions
MySQL COUNT allows you to count rows in your MySQL database, a useful way to use this is to apply a condition like: SELECT COUNT(*) FROM invoices WHERE `paid` =…
Measuring page load time with PHP
A simple method to view a PHP pages load time in seconds can be done with the use of microtime(). Microtime when called counts in microseconds, using microtime true makes…
Complete SEO guide for images
Having excellent SEO for your images means that not only Google images will index them but it also helps in adding to the overall SEO and value to the page/post…
Guide to installing cPanel on CentOS 7
Here is a simple guide to easily install cPanel and WHM on a CentOS 7 VPS. SSH as root into your VPS or server First step is to set your…
Getting latest Sub Reddit posts with PHP
Fetching a Sub Reddits latest posts is actually easy, mostly because the Reddit API is free and you don’t need a key. You can do self archiving with PHP and…