News & Blog

Get Currently Selected MySQL Database with PHP

July 1st, 2014 - Posted by Steve Marks to MySQL, PHP, Web Development.
When debugging a PHP script, or when your site contains multiple MySQL connections, it can be useful to know which database your PHP script is currently connected to. In MySQL you can simply run the following query: SELECT DATABASE(); Pretty easy right? We can do exactly the same thing in ...
phpMyAdmin

Perform Search For String Across Entire Database in phpMyAdmin

June 16th, 2014 - Posted by Steve Marks to MySQL, Web Development.
Searching for a word or phrase within one MySQL table can be easily achieved with an SQL query. Doing a search across a whole database becomes a little bit more complex should you wish to do this with a query. Thankfully, if you use phpMyAdmin there is a built-in feature that enables you d...

How To Bulk Delete Product Variations in WooCommerce

June 3rd, 2014 - Posted by Steve Marks to MySQL, PHP, Software, Web Development.
When building any kind of E-Commerce site in WordPress I always have, and will for the foreseeable future, use the fantastic WooCommerce plugin. I’ve blogged about WooCommerce a few times in the past as I’ve come across various special requirements. Today is no different as I d...

Taking Your WordPress Development To The Next Level

April 16th, 2014 - Posted by Steve Marks to Miscellaneous, MySQL, PHP, Software, Web Development.
Having been an avid web developer for over 10 years now I’ve seen a lot of change during this time. One of which is the explosion in the use of WordPress Content Management System. About 90% of sites we design and build today are based on WordPress, and I’d probably be right in...

Performing a Radial Search with WP_Query in WordPress

January 27th, 2014 - Posted by Steve Marks to MySQL, PHP, Web Development.
If you’re building a site in WordPress that performs some kind of radial search, it can be difficult to know how to do this using the standard functionality included through use of the built-in WP_Query class. I found myself in this exact scenario recently on a site I was developing,...

MySQL CONCAT() Returning NULL Even Though Values Exist

January 24th, 2014 - Posted by Steve Marks to MySQL, Web Development.
The MySQL CONCAT() function is used to concatenate two or more columns or strings together. I had a scenario earlier today where, when concatenating a few columns together the outcome would always be NULL. An example of this query was as follows where I was concatenating a series of addres...

How To Automatically Set WooCommerce PayPal Orders as Completed

October 22nd, 2013 - Posted by Steve Marks to MySQL, PHP, Software, Web Development.
In a normal E-commerce operation an order will be made, the customer will pay for it, the order will be fulfilled and the item(s) dispatched, at which point the order will probably be marked as ‘Completed’. This process is supported in WooCommerce and allows the order to go fro...

How to Install Two Versions of XAMPP Side-by-Side

October 18th, 2013 - Posted by Steve Marks to MySQL, PHP, Web Development.
I’ve used XAMPP for as long as I can remember. I used it originally so I could learn and practice PHP without having to purchase hosting, however I use it now-a-days to develop sites locally before putting them into the public domain. Each version of XAMPP comes by default with a spe...

WordPress Plugin – Property Portal BLM Export – WP-Property Add-On

July 15th, 2013 - Posted by Steve Marks to (X)HTML / CSS, MySQL, PHP, Software, Web Development.
If you send automated feeds to property portals such as Rightmove and Zoopla, to name but a few, you’ll know doubt of heard of BLM files; A format that allows you to send your properties to these property portals in an automated fashion whereby they can be processed the other end. Th...
WordPress Plugin Activated

Debugging Why WordPress Won’t Create Plugin Tables On Activation

July 11th, 2013 - Posted by Steve Marks to MySQL, PHP, Web Development.
I’ve wrote small-ish WordPress plugins in the past, however at the moment I’m working on something a little more girthy (can a WordPress plugin be girthy?) where I’m getting to experiment with more of the advanced features. One of these features I’m getting to play ...