MySQL: What Are Sub Queries & How Are They Used?
I have had a few questions recently asking what sub queries are and how they are used. While there are a number of articles out there on the subject they don’t explain it in a detailed manner as I would like. So here is my take on them.
Store Multiple Values In A Single Row MySQL – Revisited
I originally wrote a post about 2 year ago explaining how to store multiple values in a single MySQL row. Now I have more experience with PHP/MySQL I have decided to revisit this topic to clear up any confusion about the method that should be used.
Setting Up XAMPP & WordPress For Local Testing
Using WordPress for the first time can be daunting, so one of the best ways to become familiar with it is to install a local version. So this tutorial is going to show you how to set up XAMPP & WordPress for local testing purposes.
Measuring The Speed Of PHP Scripts
It’s always useful to run speed tests on your scripts to check how fast they are running, and so that you can then measure any improvements when you are optimizing scripts. Here is how I do it, plus a few tips.
Simple Data Sanitization with preg_replace
Sanitizing data is a very important part of any server side scripting language, and it’s no different for PHP. So here is one simple way of sanitizing data using the dreaded REGEX.
Writing Text On An Image With GD
Writing text on your images using GD is a handy ability to have. Maybe you are developing an imagehost or you have a project where you need to place text on an existing image. Whatever the reason here is how it’s done.
WordPress: PHP CGI Vs PHP FCGI
This is a little bit of a niche post, but it’s all about a problem I had recently with my site. It was all to do with WordPress and how it responded when running under PHP as FastCGI instead of CGI.
Optimizing WordPress For Shared Hosting
There are lots of websites hosted on shared hosting in this age, and the majority are probably running WordPress. While it’s a great application once set up with plugins it isn’t the lightest one on the block. Here we are going to look at making WordPress as shared server friendly as possible.
PHP Basics: The Switch Statement
Today we are going back to basics with a small tutorial on how to use the PHP switch statement. They can be extremely useful, but knowing how to use them properly can save you a lot of time.
Showing Or Saving An Image Retrieved Via cURL
As a developer cURL can be a very handy for numerous reasons. In my case I have used it for my plugin Twitter Stream, but here we are going to look at a little tip I stumbled across while playing with cURL.
Loading ...
