---

Case Study: Highcliffe Sailing Club Webcam

We were approached by a local IT company who had installed four IP cameras at the sailing club. The cameras take a picture at a defined time interval, in this case set to every five minutes, and transmits the picture to a folder within the clubs website, each camera having its own folder. We created some PHP code to check which was the newest picture in each of the folders and get the time and date from the file details. Lastly we set up a page to display the four pictures which refreshes itself every five minutes thereby displaying the newest picture in the given folder.. http://www.highcliffesailing.co.uk/webcam.php

---

Web form to PDF project.

The client, an insurance company, wanted to create and issue policy documents as PDFs with agents entering the clients details via a web portal.

The policy documents were then stored on the server as hard copy docs and a record of the docs created, with the clients and the agents details, stored to a database where they could be accessed by the central admin team.

A fun project, PDFs are so shiny...

---

Case Study:
Traumacare practitioners' address database

Traumacare's business is to match up the victims of accidents with the appropriate treatment local to themselves, physiotherapists, osteopaths and the like. They were using an internal network and running their practitioners' database accross that using MS Works. They decided that they wanted to make the database accessible across the web so that they could allow employees to work from home.

We recreated this database in mySQL and created an interface for users with search facilties.

Later they decided that it would be easier to match practitioners to patients locally if they had a postcode comparison function. We constructed this so that an employee entering a postcode and the type of treatment required into the system for a search is then presented with the nearest practitioners and the number of miles they are situated from the patients home.

Unfortunately because of the private nature of the data in this system we are unable to present a demonstration.

---