Mysql
Martech Zone articles tagged mysql:
-
Ecommerce and Retail
WooCommerce: Why It’s A Pain To Migrate Between Staging and Production… And How To Work Around It
While we’re comfortable declaring our expertise in WordPress, it’s not without challenges. One issue that’s quite frustrating is the database architecture utilized for WooCommerce. Specifically, various records are stored in the wp_posts table in WordPress, and their post type categorizes them. Here’s a list of some common post types used along with a brief description of each: Product: Post type…
-
CRM and Data Platforms
PHP and MySQL: Export a Query to a Tab Delimited or CSV File
This weekend, I wanted to build a PHP page that would back up any MySQL query or table into a Tab Delimited file. Most of the examples out on the net have the columns hard-coded. In my case, I wanted the columns to be dynamic, so I had to first loop through all the table field names to build the…
-
Ecommerce and Retail
Broadleaf Commerce: A Unified, Headless, and Microservice PaaS for Ecommerce
As businesses grapple with the increasing complexities of commerce, solutions like Broadleaf Commerce are invaluable. Broadleaf Commerce is a software solution designed to handle the intricacies of the commerce industry. Its principal mission is to remove hurdles to innovation, providing an open, truly headless, and modular platform built explicitly for complex commerce. Before we speak to the platform-as-a-service (PaaS), let’s…
-
Content Marketing
WordPress: Find and Replace All Permalinks In Your Database using Regular Expressions (Example: /YYYY/MM/DD)
With any site that spans over a decade, it’s not uncommon that there are many changes made to the permalink structure. In the early days of WordPress, it wasn’t uncommon for the permalink structure for a blog post to be set to a path that included the year, month, day, and the slug of the post: /%year%/%monthnum%/%day%/%postname%/ Aside from having…
-
CRM and Data Platforms
Calculate or Query Great Circle Distance Between Points of Latitude and Longitude Using The Haversine Formula (PHP, JavaScript, Java, Python, MySQL, MSSQL Examples)
This month, I’ve been programming in PHP and MySQL for GIS. While researching the topic, I had difficulty finding 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 known as…
-
Content Marketing
WP Migrate: The Easiest Way To Separate A Single Site Away From WordPress Multisite
One of our clients grew to a point that their company separated from their parent company. At issue was that the parent company was managing all of their subbrands via WordPress Multisite. What is WordPress Multisite? WordPress Multisite is a pretty unique feature built within WordPress that enables quite a bit of customization and permissions across a network of sites…