Category: MySQL
09/28/2020
How to scale your WordPress site for enterprise level redundancy
Hello! It often becomes a requirement for certain levels of clients to ensure service level agreements for uptime and redundancy are kept. What does this mean? Well we want to ensure that a particular site can withstand a single point of failure, which usually means we would need to expand the services across multiple endpoints. […]
05/08/2020
How to optimize and speed up your WordPress site
Hello! What a topic : how speed up your WordPress site. There are so many elements and factors that contribute to site speed, it is my intention to cover each area that contributes or affects overall site speed, specifically with a WordPress site. Being the most popular CMS in the world means that all sorts […]
09/25/2019
How to create self-populating “smart” forms in Drupal 8 with Form API
Hello! Many years ago (2015 to be exact), we published an article on how to create self-populating dropdown forms using the Drupal 7 Webform API. Now that the year is 2019 and Drupal 8 has been “Released” for quite some time now, with 8.7.1 as of May 2019, we thought it might be a good […]
05/08/2018
How to make bulk changes to WordPress Woocommerce product attributes with PHP
Hello! Sometimes its necessary to make site-wide changes to WordPress posts in order to save time and programmatically propagate changes without having to edit each post one at a time. For bulk manipulation of WordPress data, it is sometimes effective to write a command line PHP script to hook into your WordPress environment and execute […]
01/31/2018
How to craft an XSS payload to create an admin user in WordPress
Hello! XSS (or cross site scripting) attacks are a common method to maliciously execute actions against a website installation. In particular this type of attack vector is useful when dealing with a CMS like WordPress where you have administrative user accounts to target. This means that if you are able to craft an XSS payload […]
12/19/2017
WordPress plugin to integrate Jenkins to streamline your build process
Hello! We love integrating Jenkins into development workflow. Typically Jenkins would be used for custom development projects to streamline the development “push” process in order to seamlessly integrate code changes from a testing / staging environment over to the live environment. For frameworks like Laravel or Django, this works very nicely. Until recently, we haven’t […]
03/14/2017
How to use PHP as a web service to backup MySQL over HTTPS to a remote destination
Hello! Following with the theme of our last post, we thought it might be useful to demonstrate how to create a pure PHP based web service to backup your MySQL database to a remote destination (also with PHP) over a secure HTTPS connection. High level, all we will be doing is iterating over all the […]
01/30/2017
How to use jQuery to sort and reorganize your content
Hello! Recently we were tasked with finding ways to re-organize search results on a Drupal page in such a way that we could prioritize, group and sort the results in a coherent way. The simplest way to look at organizing in general, especially content that is dynamically generated, is to either adjust the query that […]
06/22/2015
Securing your MySQL queries from SQL injection in PHP
Hello! There is many strategies for securing your code against malicious user input. Some frameworks have checks and balances built in. There are simple standard PHP functions that are designed to strip tags and illegal characters from variables like strip_tags and filter_var. Filtering XSS in PHP Those standard functions are good for basic input filtering, […]
04/06/2015
Use PHP to set up a RESTful API with simple authentication
Hello! It is sometimes necessary to bridge different web applications together in order to transmit or receive information and process it. One scenario could be a mobile application that connects to a web service to pull or push data in order to update the app or provide “real time” services with centralized data. One of […]