PurpleBooth

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites

odan

Installing Xdebug for XAMPP with PHP 7.x

• New: XAMPP - XDebug Setup for PHP 8

Requirements

• XAMPP for Windows: https://www.apachefriends.org/download.html
• Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017 and 2019

Setup

ValeriiVasyliev

GIT commands

Add one or more files to staging (index)

git add <filename>

git add *

ValeriiVasyliev

Wordpress as a Dependency

How to install Wordpress as a dependency in your project, without including the WP install in version control.

Rationale

In the spirit of The Twelve Factor App, we want to "explicitly declare and isolate dependencies". Wordpress doesn't really promote this idea out of the box, so we have jump through a few hoops to do it. This document describes a simple method to include Wordpress as a dependency in this way.

General Idea

ValeriiVasyliev

Installing Xdebug for XAMPP with PHP 7.x

• New: XAMPP - XDebug Setup for PHP 8

Requirements

• XAMPP for Windows: https://www.apachefriends.org/download.html
• Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017 and 2019

Setup

ValeriiVasyliev

UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com');

UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com'); 

UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

ValeriiVasyliev

DELETE FROM `wp_posts` WHERE `post_type` = "attachment";

DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attached_file";

DELETE FROM `wp_postmeta` WHERE `meta_key` = "_wp_attachment_metadata";

DELETE FROM `wp_postmeta` WHERE `meta_key` = "_thumbnail_id";

UPDATE `wp_postmeta` SET `meta_value` = NULL WHERE `meta_key` = "_product_image_gallery";

ValeriiVasyliev

DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
DELETE FROM wp_comments WHERE comment_type = 'order_note';
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );
DELETE FROM wp_posts WHERE post_type = 'shop_order';

ValeriiVasyliev

wp core update && wp plugin update --all && wp theme update --all && wp core language update