There is a very quick and simple way to pull crypto prices without the need for a paid or free cryptocurrency price API. The basic formula goes like this =IMPORTDATA("https://cryptoprices.cc/BTC")...
Read More
Amazon S3 WP Uploads Hosting + Amazon Cloudfront CDN Hosting media is one of the best wordpress hosting sites on Amazon S3 and using the Amazon Cloudfront CDN for serving…
RewriteCond %{QUERY_STRING} ^$ RewriteRule ^subfolder/?$ /new-subfolder/ [R=301,L,NC]
Read More
In this blog post, I’ll show you how to update a range of cells in a Google Sheet that have formulas. This is useful if you want to create an…
I've recently had to implement Google ReCaptcha in a custom PHP form. It's an easy thing to do, in theory, if you know how all the pieces fit together, but...
Read More
This snippet queries your MySQL database for all tables and then returns their sizes sorted from largest to smallest. Replace DATABASE with the name of your database. SELECT TABLE_NAME AS…
Imagine you have a multisite with many similar client sites. Perhaps you have a plugin or custom data stored about each subsite. One day you have to update that custom…
// Google Geocoding API Key $apiKey = 'API KEY GOES HERE'; $address = urlencode( '1600 Amphitheatre Pkwy, Mountain View, CA 94043' ); $url = "https://maps.googleapis.com/maps/api/geocode/json?address={$address}key={apiKey}"; $resp = json_decode( file_get_contents( $url...
Read More
In this blog post I will show you how to sync data between a set of specified worksheets in a Google Sheet to prevent common payroll errors. This code is…
Below is the structure for adding bootstrap, or any other node module SCSS. The hardest part was to get the syntax correctly for the imports and knowing that you need…