MySql wordpress 

How to replace WordPress site URL in Database – updated 2021

There might be many possibilities when you want to change the WordPress site URL. Completely moving your site from one domain name to another. when we want o to add HTTPS instead of HTTP which is migrating sight from HTTP to HTTPS. when you want to add www. to your site. Solution 1: Using MySQL Update replace query Solution 2: Using WordPress Plugin “Search and Replace” There are many ways we can solve this Note: Before doing any of the following methods please back up your database once Solution one…

Read More
API's MySql PHP Web API 

Google API to Calculate a Distance in PHP / Mysql

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. If you remember ‘the old days’ of calculating a distance between two points, it was simply the hypotenuse of a triangle (A² + B² = C²). That’s an interesting start but it doesn’t apply with Geography since the distance between lines of latitude and longitude are not an equal distance apart. As you get closer to the equator, lines of latitude get further apart.…

Read More