How to upgrade/update PHP on a windows dev server

This article is about how to update your PHP version on Windows, specifically when using EasyPHP dev server. For the average developer, this can be a daunting process, but it’s really not that hard.

My reason for posting this article is that EasyPHP server has stuck any upgrade components behind a paywall, or ‘warehouse’ as they call it, which costs $10/year, which seems crazy when it’s so easy to do yourself.

This guide should work for other servers running on windows as well, you’ll just need to modify certain steps depending on how your specific set up is configured.

Continue reading “How to upgrade/update PHP on a windows dev server” »

How to dump CSV files to MySQL (the easy way)

Sometimes, the only option for dumping data into a database is using CSV files – they’re easy to use for non-technical people, they are a fairly efficient way of storing data and can be easily exported from Excel files.

There’s one huge problem with them, though…they’re a real pain in the arse to work with.

So, I decided to create a reliable, easy to use way for dumping CSV files, no matter how big or small, to a MySQL database. I will, however, show some alternatives along the way.

Continue reading “How to dump CSV files to MySQL (the easy way)” »

How to deploy a Magento site using GIT

There are many ways to deploy a Magento site to your server. Many would argue that a simple FTP upload is fine, while others swear by version control.

The problem with the version control + Magento combo is that, necessarily, Magento stores a lot of information about its state in the filesystem – this can lead to a lot of trouble if care isn’t taken when creating the staging and deployment mechanisms.

I’ll walk you through with a tried and tested method I use for the deploying a Magento site using GIT.

Continue reading “How to deploy a Magento site using GIT” »

How to update the browser on the status of an AJAX process

Websites with AJAX elements are a defacto standard on the web and have been for quite some time. AJAX allows you to run a request on the server without actually leaving the page the user is on, executing it asynchronously while the browser waits for a response.

One big problem with this is that if the process takes more than a few seconds, there’s no built in methods in the AJAX standards to receive content before the entire request is complete, so how do we let the browser know the status of the process on the server, if we can’t stream information to the browser using AJAX? We’ll be addressing this problem in this post.

Continue reading “How to update the browser on the status of an AJAX process” »

‘AND’ and why you should avoid it in programming and in life.

This is one of the most useful tips about programming I’ve seen. It has deep roots in programming philosophy and in philosophy in general. I find I can apply it not only to programming but in other areas such as data management, time management and just life in general. What is this magical paradigm? Let me explain.

Continue reading “‘AND’ and why you should avoid it in programming and in life.” »

Using jQuery BBQ to create an instant bookmarkable search with AJAX

jQuery BBQ creates a nice interface for manipulating your url without having to reload the page. This means that you can create bookmarkable content without having to reload the page every time you want to change a url parameter. This is great for creating AJAX based forms that can display results instantly while still being bookmarkable.

A lot of sites use this sort of functionality already. A good example of this is grooveshark, which uses the hash part of a url to store parameters. Drupal also includes jQuery BBQ in its base package. Page reloads take a long time, so in today’s world of responsive web pages and impatient users, putting url parameters in the hash part of a url makes a lot of sense.

Continue reading “Using jQuery BBQ to create an instant bookmarkable search with AJAX” »