How to remove “Powered by Shopify” from the footer of your website.

So you’ve launched your new site, everything looks good, but there in the footer is a little piece of text that makes is clear to your customers that you use Shopify. Powered by Shopify Not that it isn’t something to be proud of, Shopify is an awesome platform! However to complete the customisation of your […]

When to use the IN operator in your SQL WHERE statement

Finding your SQL statements growing and difficult to understand? Inherited some code that contains complex looking SQL statements? Let me show you one way to make them easier to read and understand… Sooner or later you will have to create a SQL statement with multiple WHERE conditions, usually AND and OR’s. If you have three […]

How many ways are there to output HTML using PHP

The con, the cat and t’e nation! Have you heard of concatenation? No? Stay with me if you haven’t! According to wikipedia: String concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “snow” and “ball” is “snowball”. Concatenation is an import concept in PHP for outputting HTML. Also used in […]

How to get your new website showing in Google search results

You’ve bought your domain name You’ve worked hard developing up your website. You’ve launched it, tested it out in your browser. Sent a link to friends, shared it on social media. Then you went to Google… … to search your new domain name and … it didn’t show up?!?! You are thinking how’s that possible? […]

Essential tech and tools for a new eCommerce site

Assuming you’ve already chosen your eCommerce platform. Below is a list of essentials that you should consider for your new e-commerce store. If you haven’t chosen a platform already. Some of the main contenders are Shopify, WooCommerce with WordPress, Magento. If you are selling digital products you could use Gumroad or GoSpaces. If you are […]

How to access PHP session variables from another PHP page

​​ One of my subscribers sent me an email asking me about problems he was having with sessions. He had already created a session variable in one PHP file. Now he had a second PHP and wanted to access the session variable in it. However he was struggling to access his session variable. He found […]

How to use PDO to UPDATE data in MySQL using PHP

You need to get data safely updated from a web page to a MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table […]

How to use PDO to DELETE data from MySQL using PHP

You need to delete data safely from a web page and your MySQL table in your database You need to sanitize that data from user input and protect against SQL injections. The following simple example will show you how to accomplish that. These are the ingredients you will need: A MySQL database A table to […]