The focus of this case study is on importing of existing information in the form of XML markup, to a MySQL database
The Book of Mankind Project (BOMP) is a future non?profit project that will be an encyclopedia of humankind. The general idea is to set up a web site that catalogues mankind, stories of individual human beings, as well as whole cultures. The case study is built using PHP with MySQL with PEAR:DB as the database abstraction layer.
Store Directory (PDA/Wireless)
This case study demonstrates the use of templates to build a site that supports generic HTML browsers, WML support for WAP phones and other mobile devices such as PalmPilots and handhelds running WindowsCE or PocketPC. It builds a store directory that can be used both from HTML and WML browsers.
This case study looks at a web application for the fictional Mighty GhostHunters, Inc., that allows staff and public to post information about ghost sightings and other paranormal events and experiences. This case study allows users to register themselves with a site and post their experiences.
Web Corpus +
This case study takes a look at compiling a web corpus. It delves into building a web corpus and the components of a search engine.
Mission Control Job Board
The case study looks at a web application for I-Spy Inc., a fictional espionage company. They have agents working in the field on a frequent basis and found it necessary to be able to hand out assignments remotely. This case study focuses on a job board with a wireless component. It makes use of WML Templates and PHP, with MySQL as the database.
Classified Ads Board
Leads you through the planning and development of an online classified advertisements board to allow users to post ads online onto the board.
Simple Content Management System
Details a very simple CMS in which document content takes on several forms while using only a single database. This is accomplished by using XML to define each document. While all documents have the same skeleton set of XML tags, each document type differs in the tags used within the element. This content markup is actually stored as is in the database. Each document type will require its own application component to parse and manipulate the document body.
Advanced Content Management System
Focuses on some of the more advanced peripheral aspects of a CMS and builds upon the Simple CMS to look at user categories, privileges, task lists, messaging, activity logs, etc. The techniques discussed in both of these case studies, if combined, would result in an application resembling an essentially complete CMS
A Search Engine for Dynamic Sites
This case study looks at developing a search engine that can search through a site with thousands of products. The search should be fast and should also rank the most exact matches so that users will quickly find the information they are looking for.
Details a complete example of a 3-tier, multi-client wireless web application focussing on a multi-database public data-warehouse application with features available to wireless devices
Details the PostNuke Open Source Portal/Content Management System to build a fairly robust site architecture starting from scratch in a fairly short period of time.