[PHP + MySQL] Making a basic product database – Part 1
12 October 2008 – Category: Development
Firstly you need a server which supports PHP and Mysql. If you haven’t got one, you can set up your computer as a local web server. If you are on Windows, you can follow this guide to help you Set up your PC as a test environment using Apache, PHP and MySQL.
Create the database and [...]
[Drupal] Installation
22 September 2008 – Category: Development
You will need to have set up an IIS or Apache webserver with PHP 5.2 or greater and a Mysql/PostgreSQL database before you can work on Drupal. For more requirements see [Drupal] Overview.
If you do not have a webserver yet but wish to set up your personal computer as a testing environment, please read through [...]
[Drupal] Overview
22 September 2008 – Category: Development
What is Drupal?
Drupal is an open source CMF (Content Management Framework) created by Dries Buytaert.
What is the difference between a CMS and a CMF?
Not a lot but Drupal is refered to as a CMF due to is configurability and customisation that you are able to do through it’s excellent back end and through the use of [...]
UK Counties & Countries data files (CSV + MySQL)
22 September 2008 – Category: Other
The following files are data files that can be used in projects that require a list of UK Counties and/or all of the Countries in the world.
The following files are useful for web developers to use for their select drop downs or a lookup table in a database.
[MySQL] Using MySQL to analyze web usage from Windows ISA logs
22 September 2008 – Category: Development
This tutorial will teach you how to import a tab delimited file in to a MySQL database. I built a program to do this for Windows ISA Server logs which contained over 500,000 lines which was way too many for Microsoft Excel to handle and too much for notepad to handle properly. What MySQL functions [...]
Server Migration
3 August 2008 – Category: Other
Site was down for a couple of days due to a server migration. There was a problem with importing the database dump on to the new server, but everything should be sorted now.
