SQL to Update Multiple Database Table Columns With a Custom Value

Sample database structure

On a recent project, I needed to populate a newly created column added to an existing database table with over 10 rows of record with a custom values and I'm going to show us how I did it. Take for example, a database table that previously consisted of three columns and an additional handler_structure column was added to it via the SQL below. [crayon-5618929070692347639550/] Notice the handler_structure columns for all row records are … [Continue reading]

How to Reset a WordPress User Password hosted on Localhost

How to Reset a User WordPress Password hosted on Localhost

While working on a WordPress site hosted on a developmental server (simply called, localhost) in my computer, I mistakenly updated my admin password to a random WordPress generated one. Thus, I was logged out and no longer was able to log in again because I have no record of the new password. Using the password reset option won't work because email can't be sent on a local server (at least in mine). In this concise tutorial, I will show … [Continue reading]

How to fix “Warning: An existing WordPress network was detected.”

How to fix "Warning: An existing WordPress network was detected."

While converting a WordPress single install to multisite, the following error notice was displayed at the Network Setup admin page. Warning: An existing WordPress network was detected. It took me quite some time to finally figure out what I was doing wrong. Mind you, the instruction in Network Setup page clearly stated that the PHP constant definition below should be placed before /* That’s all, stop editing! Happy blogging. */ in … [Continue reading]

How to Destroy a User Session in WordPress

How to Destroy the Session of a Logged in User in WordPress

Below is a PHP function that can programmatically logout or destroy a user session in WordPress taking the user ID as an argument. [crayon-5618929070df8922727884/] … [Continue reading]

How to Fix Size of XAMPP Installation Folder Getting Bigger

Folder eating up my local drive disk space

In a previous post, i showed us how to find and delete files eating up a PC disk space and in it, we could see that XAMPP was the largest consumer of my PC disk space. One might wonder, how the heck did XAMPP consume such large a size of disk space? turned out if you have xdebug profiling enabled, runtime information about the PHP scripts you execute are written into systems temp folder (by default) which is XAMPP tmp folder in my … [Continue reading]

Better Free Downloads In Easy Digital Downloads Powered Store

EDD License Free Download

If you sell digital products such as WordPress plugins and themes, you agree with me that Easy Digital Downloads (simply EDD) plugin is arguably the best to set up a store for selling. I use it in selling my premium plugins and couldn't be happier. A month ago, I release an extension for EDD called License Free Download that allow shop owners to give free downloads to customers that holds a license for another product. We use the … [Continue reading]

Find and Delete Files Eating up Your Windows PC Hard Disk Space

Folder eating up my local drive disk space

I recently had a problem where the C-Drive disk space of my Windows 8.1 PC mysteriously got filled up. As a result, I kept getting this error message "you are running very low on disk space". I scan through all my files deleting several large files and uninstalling software that were infrequently used yet the size of the disk space only reduced by few gigabytes. I calculated the size of my files and installed program and no way could they … [Continue reading]

Customizing the Homepage of WooCommerce Storefront and Its Child Themes

WooCommerce Storefront theme

By default, Storefront WooCommerce theme by WooThemes displays a maximum number of four(4) feature, recent, on sale and top rated products in four columns while the product categories are in three columns. This also hold true for its child theme save for Boutique which displays a limit of three homepage products in three columns. In this tutorial, i will show us how to increase the number of feature, recent, on sale and top rated … [Continue reading]