Useful WordPress SQL queries

Useful WordPress SQL queries

The best Database Editor is phpMyAdmin as for me. It is very simple and comfortable. To run SQL queries below on database choose a required database in the left sidebar and open SQL tab in the top of the right window. How to remove all posts with a custom ‘post type’ and their meta fields…

Read More Read More

WP Comment Object

WP Comment Object

WP_Comment Object ( [comment_ID] => 5 [comment_post_ID] => 1665 [comment_author] => webbizdirect@gmail.com [comment_author_email] => webbizdirect@gmail.com [comment_author_url] => [comment_author_IP] => 192.168.42.7 [comment_date] => 2020-01-17 13:49:26 [comment_date_gmt] => 2020-01-17 13:49:26 [comment_content] => Zodra er een enquête beschikbaar is die bij jou past, ontvang je een e-mail. Je kunt dan zelf bepalen of je die enquête wel of…

Read More Read More

Modifying the WooCommerce Product Query

Modifying the WooCommerce Product Query

WooCommerce builds a custom query for products in its WC_Query class by hooking into the classic pre_get_posts hook and changing WordPress’s query parameters to get the desired products. WooCommerce then removes itself from the query afterward. I am not 100% sure of why, but I presume there is a good reason. It might be running in WooCommerce, but it…

Read More Read More

Get the first & last elements of an associative array

Get the first & last elements of an associative array

This is a small tutorial on how to get the first elements of an associative array in PHP. As you probably already know, associative arrays are extremely popular in PHP, simply because they allow you to set keys/indexes that are human-friendly! Unfortunately, one of the drawbacks to using an associative array is that it can…

Read More Read More

Regex (regular expressions) cheat sheet

Regex (regular expressions) cheat sheet

The tables are not exhaustive, for two reasons. First, every regex flavor is different and we didn’t want to crowd the page with overly exotic syntax. For a full reference to the particular regex flavors you’ll be using, it’s always best to go straight to the source. In fact, for some regex engines (such as…

Read More Read More