![[99p host web hosting system screenshot]](img/99phost.jpg)
Utilising a third party SOAP XML based Text messaging system, this PHP driven website allowed customers to place an order online and then pay for their internet web hosting using SMS technology. The system assigned each customer a unique 6 character code which had to be "texted" in to the third party gateway which then notified the system.
The system then sent out two "reverse billed premium rate" text messages to the customer who then had to enter them on the website - upon which the system will automatically create their cPanel web hosting account and enter their details in the WHMAutopilot billing system.
The system would automatically send out renewal notification emails to the customer and, if their account was not renewed, it would automatically suspend their account upon non-payment.
![[Adlive proofing system screenshot]](img/adlive.jpg)
Developed in 2002, this project utilised a third party Internet Explorer ActiveX component to allow customers of a printing company to "pre-flight" their files ready for printing on their own computers. The ActiveX component would upload an XML summary of the file to the Perl driven website which would check the details against records stored in an Microsoft Access database.
Once the file had been "passed", the user would then be able to upload it to an FTP server which was "watched" by Adlive - once the file had been uploaded, the user would be notified and the file would be placed within their "basket".
After the user had built their "basket", they could then select which of the 6 magazine printing companies the files should be sent to and the files would then be sent via FTP.
![[FreeVirtualNumbers home page screenshot]](img/freevirtualnumbers.jpg)
Using a third party ordering system as the backed, this UK Voice Over IP provider had me create the website (using a pre-purchased website template) whilst keeping in mind the search engine optimisation, work with the ordering-system provider to correct issues on their system, and then build a unique "telephone number to cost" lookup system: allowing customers to see exactly where a telephone number points to (country and region) and the cost of the service via the VoIP operator compared to British Telecom.
This site is powered by PHP and MySQL - with the MySQL tables having to be designed in a specific way to cope with the overlapping "charge bands" for the VoIP and British Telecom (for instance: telephone calls to UK numbers starting XX should be classed as 'Special rate' unless they start with XXYY when they are classified as a "local rate" unless the number is XXYY ZZZ which means it's actually a totally different rate).
![[IT Development console screenshot]](img/it_dev.jpg)
Created in just over a month, this PHP and PostgreSQL system was designed to allow a 2,000 user business help log work for the 15 developers, for the work to be allocated by the development manager to team leaders and developers and for feedback to be given back to the original requestor.
This PHP and PostgreSQL system was complete with due dates, review dates and Gantt charts, this system also interacted with the company's Active Directory system to enable auto-completion of users names, email addresses and position.
![[eCommerce Web Reporting Application screenshot]](img/web_reporting_ecommerce.jpg)
Pulling in information from a remote Microsoft SQL database Server (MS-SQL) and a remote PostgreSQL database server, this application allowed for online sales figures to be viewed for the two eCommerce systems in operation (previously there was no sales reporting information available) and for the information to be compared between the systems.
Written in PHP, this system utilised the Yahoo! YUI Javascript library to enable online graphs to be displayed and interacted with - along with allowing output in web page (HTML) and CSV (Comma Seperate Value) file formats for importing into Microsoft Excel. The system, due to the confidential nature of the data, had a strict user authentication system which used Active Directory network logons and PostgreSQL's user management faciltiies.
![[MeDuSa Brand Product Maintenance screenshot]](img/medusa_brand_maintenance.jpg)
Developed in a day, this PHP system utilised a PostgreSQL database system and the Yahoo! YUI (Yahoo User Interface) Javascript library to allow the client to search for products in their catalogue and assign "brands" (manufacturers names and logos) to individual products.
As many manufacturers had similar names and mis-spelling was a problem, the YUI library was utilised to auto-complete/auto-suggest names and show the appropriate logo to the end user.