Sefton court bed and breakfast
July 7th, 2009 | written by Simon
Sefton Court is a Michelin approved bed and breakfast in Llandudno, North Wales. David White of Whitekite design, a close working partner of mine, won the contract to redesign the hotel website and he asked me to develop the front-end online booking system with room availability checker together with a back-end booking management application. Having [...]
Category : Blog &MySQL &Partners &Projects &Recent work &Web development &php
playpics
July 7th, 2009 | written by Simon
playpics is a new subscription website for teachers. This new educational resource offers a large library of original images designed specially to support the primary school curriculum. The basis of this project involves a lot of image manipulation and database development while the later phases are to feature more web 2.0 online community functionality. As [...]
Category : Blog &Featured Work &MySQL &Projects &Recent work &Social networking &Web development &e-Learning &php
MySQL to XML with PHP
November 30th, 2008 | written by Simon
This tutorial is based on a bit of code I created to extend Flash Nifties XML slideshow to use an MySQL database as its datasource. It assumes you have a MySQL database where you store your images. [Download sql2xml.zip for XML Slide Show] Step 1: Make the database connection <?php $con = mysql_connect("localhost","username","password"); if (!$con) [...]
PHP, MySQL and Japanese characters
November 16th, 2008 | written by Simon
I recently set up a photoblog for my wife. As Junko is Japanese she wanted the ability to write posts in her mother tongue. WordPress handles this perfectly well out of the box but when I came to interrogating the WordPress database to display the latest blog titles on an external page I was just [...]
