The following docker-compose.yml file setups a local WordPress docker instance alongside a MySql server and an Adminer web app which can be used as an alternative to PhpMyAdmin. version: '3.9' services: wp_mysql: image: mysql:latest container_name: wp_mysql command: mysqld --character-set...
How to let Avada Post Cards element fetch posts from the database based on a value of a custom field in the posts
Context In the last couple of months, I have been working on the website of Stichting Civic. Stichting Civic is a Dutch foundation committed to improving the Dutch civic integration policy for refugees and other newcomers. The foundation aims at 1) collecting and stimulating socio-scientific and...
How to change the prefix of WordPress database tables using MySql in phpMyAdmin
In this article you will learn how to change the name of all MySql (WordPress) database tables in one shot to save you time and maybe money too :)
How to use Google Workspace Gmail server alongside other mail server
A step-by-step guide on how to setup a split-delivery to use Google-Workspace email service and your traditional mail service offered by your hosting provider
How to check/uncheck all checkboxes on a web page using vanilla Javascript
A couple of years ago I wrote this short post about checking/selecting all checkboxes on a web page using jQuery. However, how would we do that if we can’t included jQuery on the page or if we want to do it only with Javascript! To uncheck all checked checkboxes on a web page using only...
How to trigger a specific code after a new product is created via WooCommerce REST API
I ran yesterday into a situation where I needed WordPress to perform a specific action after a product is inserted into WooCommerce database using the REST API endpoint POST /wp-json/wc/v3/products I have searched online for a couple of hours and I found multiple solutions, but non of them worked...
How to perform SQL queries with WooCommerce?
This post will be updated regularly. This is a work in progress 🙂 DISCLAIMER: Maybe the title is a bit misleading, but this blog post is meant to be as a reference for people just like me who are forced to google everytime how to get a or to manipulate product, product category and all other stuff...
How to speed up Vagrant on Windows 10 using NFS
Background At work (FlexKids) I have a Windows 10 machine (at home I use both Ubuntu and Windows). We don’t only Windows, we use OSX and Linux as well. To overcome this (not the only reason) we use Vagrant, Virtual box (CentOs 7) as a development environment. Thus we can ensure we all have...
How to use Fabric to deploy a flask web application
Lately, I have been busy making a deploy script for a Flask API. I have never worked before with Flask and I just got to know Flask a couple of months ago. I have to admit, there are not a lot of resources online explaining how to work exactly with Fabric. Although, the website of fabric (fabfile)...
How to save a base64 encoded image on hard disk in Python
In some cases you receive an image as bas64 encoded string and you need to save it first on disk before you can reopen it and use it! First of all you have to import base64 package. import base64 decoded_image= base64.b64decode(YOUR_BASE64_ENCODED_IMAGE) with open('your_image.jpg', 'wb') as f: f...