Your website is important – there’s no denying that. It’s your virtual storefront, your first impression, the way you attract new clients/customers. Your website is where people learn about who you are, what you do and how GREAT you are at what you do. And it’s where they decide if they want to give you…
I ran into a small problem where my ACF text fields and textareas with shortcodes in them, on a new WordPress page template, were not working. I took different steps to try and troubleshoot this issue, making sure that the shortcodes were correct in the backend and that the theme was not stripping them in any way. I know…
Hello, today I want to talk about MySQL. This discussion requires some understanding of MySQL. Let’s discuss the optimization of NESTED SELECT statements. Consider this MySQL statement: SELECT name, (SELECT count(carts.product_id) FROM carts WHERE carts.product_id = products.id AND cart.date=’2015-01-01’) as count FROM products; I have a table for orders and carts and I want to find how many…
Here’s a fun little issue that didn’t take a newer developer more than 2.5 hours to figure out! Let’s say you plan to migrate a site from another host to Rackspace Cloud Sites, so you grab the files from the ftp server and move them over to the new host. You then retrieve either an unzipped, zipped, or…
Developers on all sides of the coding table run into walls on a rather regular basis, particularly entry-level developers. We tend to frequently need help but because the workloads never cease, we have to very quickly learn how to handle our problems alone. Of course, that’s not to say that 100% of issues should be…
MySQL statements can be complicated, and writing them can sometimes be quite tedious. Today I want to talk about a simple technique to help improve readability and cut down modifications for MySQL statements in PHP, such as, INSERT and UPDATE. This method requires some knowledge of PHP and MySQL. We will be using an array of data…
Update 2016/11/13: The git repository that goes along this article has been updated for the latest post-release version of Angular, which is 2.1.1. The original article used 2.0.0-rc1, and that version can be found at the corresponding tag. AngularJS is a popular javascript framework that can help to mitigate complexity on the front-end of your…
As developers we’ve all been there, banging our head on the table thinking, “Why is this not working?”, staring deeply into our code asking why. Knowing that we’ve gone through the right process to make this work, and for whatever reason, it’s not. Occasionally, there may be something strange going on to cause this, however,…
When we talk to our clients, often times we’ll throw out the terms “frontend” or “backend” and they don’t know what the heck we’re talking about. We use this office jargon daily and almost forget that it’s nerd-talk and not normal-people-talk. So we thought, wouldn’t it be a great idea to explain a little on the situation?…