PHP and SQL: Calculate or Query Distance Between Points of Latitude and Longitude

Reading Time: 3 minutes This month I’ve been programming quite a bit in PHP and MySQL with respect to GIS. Snooping around the net, I actually had a hard time finding some of the Geographic calculations to find the distance between two locations so I wanted to share them here. The simple way of calculating a distance between two points is using the Pythagorean formula to calculate the hypotenuse of a triangle (A² + B² = C²). This is

WordPress: Create Sidebars Automatically For Each Category

Reading Time: 2 minutes I’ve been simplifying this site to improve speed times and to attempt to monetize the site better without irritating my readers. There are multiple ways that I’ve monetized the site… here they are from most to least lucrative: Direct sponsorships from partner companies. We work on collective strategies that incorporate everything from webinars to social media shares to promote their events, products, and/or services. Affiliate marketing from an array of affiliate platforms. I scour and

Local: Build a Desktop Database to Develop and Sync Your WordPress Site

Reading Time: 2 minutes If you’ve done a lot of WordPress development, you know that it’s often much more flexible and fast to work on your local desktop or laptop than to always have to worry about connecting remotely. Running a local database server can be quite a pain, though… like setting up MAMP or XAMPP to startup a local web server, accommodate your programming language, and then connect to your database. WordPress is pretty simple from an architecture

Stop Updating Years in Business on Your WordPress Site with this Shortcode

Reading Time: < 1 minute One of the greatest things about WordPress is the flexibility to build out shortcodes. Shortcodes are basically substitution strings that you can insert into your content that renders dynamic content. I’m helping a client this week where they’re taking one of their products and rolling it out into a new domain. The site is hundreds of pages and has been quite an undertaking. As we’ve been working on the hit list of issues, one that

Redirect WordPress in Header

Reading Time: < 1 minute The redirection plugin built for WordPress is a fantastic means of organizing and managing redirects. I use it on this site and have organized my groups of redirects for updated posts, affiliate links, downloads, etc. However, I ran into a unique problem where I have a reverse proxy set up for a client where WordPress is running at a path… but not the root of the site. The primary site is running on IIS in