More work on the Musical Festival administration

Work on the Hastings Musical Festival administration site continues apace. The latest phase is the production of certificates. Unfortunately,. I have been unable to get the PDF conversion routine to handle a full A4 page image as a background, so we will fall back onto over-printing the certificates for this year, but I hope to have it cracked by the 2011 Festival. The only bits remaining to migrate from the old Microsoft Access database onto the PHP/MySQL solution are that of inputting marks and calculating the winners of the Aggregate trophies (of which there are more than 100!).

More PHP Development

Yet another satisfied customer. He is launching a web-based music collaboration site and wished interactivity that was not currently available. As a result, he approached the webmaster of 1066online.com for help and was referred to Roy Penfold Computer Services.

We discussed his requirements and very quickly put together a custom PHP based site that fully met his requirements.


Why not head over to noisecube and have a look.

Website Design in Hastings

We now offer a fully bespoke web-design service providing affordable website design for companies and individuals in East Sussex.

Using traditional technologies such as PHP and MySQL we can create a fully content managed website for you. If you require more interactivity, we can give your site the 'Facebook' feel by incorporating AJAX programming to make pages dynamic with the 'Web 2' feel at no extra cost to you.

All sites include domain name registration for a year and the setup of unlimited email addresses.

Another Site Finished

Another site that has just been completed is that of http://www.samphire.it. This is a completely custom site designed for a racing tipster. The code is a mixture of PHP, Javascript and HTML with a back-end MySQL database.

The site features full CMS on all pages with automatic updating of results summaries in real time. In addition, it links through to PayPal for handling subscriptions.

Returning an alphabetical list consisting of the first letter in MySQL

In a recent project, one task involved returning the unique first letter of the data held in a MySQL field in order to provide hyperlink navigation through the web-site as opposed to a drop down menu.

This was accomplished using the MySQL statement below;

SELECT DISTINCT (left( [field], 1 ) )FROM `[table]` ORDER BY [field]

Revisions to websites

I'm spending the next few days making some changes to websites http://www.findapro.co.uk and http://www.hastingsmusicalfestival.co.uk

The Findapro one is a directory of professionals (accountants, builders etc) and I am employing a few SEO tactics to get its Google pagerank up a bit, not to mention permitting inclusion of banner adverts. The Findapro site is totally bespoke written using PHP and MySQL.

With the Musical Festival, it is a case of extracting the results from their bespoke Access database, re-formatting then uploading results pages to the website which is based upon Joomla. As time permits, I plan to write some custom Joomla modules to permit on-line entry and real-time updating of results.

FindaPro Relaunch

I've just uploaded the re-work of the FindaPro directory website. There are still a few tweaks to put in place, but the client wanted the revenue streams up and running as soon as possible. The site has been written using PHP and MySQL and is fully bespoke, featuring postcode searching and a content management system.

Why not pop over there and have a look?