Cover -- Open Source Database Driven Web Development: A Guide for Information Professionals -- Copyright -- Contents -- Acknowledgements -- List of figures and tables -- About the author -- Preface -- 1 Weighty worlds of wonder: whats, whys and wherefores of the Web -- The twin perils of our time -- Effective stage management -- Notes -- 2 The open source movement -- The rise of UNIX -- Evolving environments -- A dynasty unravels -- For whom the bell tolls -- A moral imperative -- Free software re-imagined -- Summary -- Notes -- 3 Six reasons to consider open source -- Stability and improvements -- Standards -- Scalability -- Portability -- Cost effectiveness -- Access -- Other considerations -- Notes -- 4 The database driven web -- Static vs. database driven -- New possibilities -- Big believers -- Seven reasons for pursuit -- Seven excuses for delay -- Summary -- Notes -- 5 Building block I: cascading style sheets -- Web services platforms -- Cascading style sheets -- Notes -- 6 Building block II: PHP -- Driving the data -- Basic coding principles -- Summary -- Notes -- 7 Building block III: relational databases -- Database definitions -- Flat-file versus relational databases -- Summary -- Notes -- 8 Building block IV: database design and normalisation -- Database normalisation -- First normal form -- Second normal form -- Third normal form -- Notes -- 9 Building block V: MySQL -- Getting started -- The login process -- Creating a database -- Granting permissions -- Creating tables -- Inserting data -- Updating data -- Deleting data -- Indexing columns -- Summary -- Notes -- 10 Standards and accessibility -- Accessibility standards -- Compliance: ethical and professional issues -- Compliance: business issues -- Compliance: legal issues -- Summary -- Notes -- 11 In pursuit of accessibility -- Applying major web standards.

Automated HTML/XHTML validation -- CSS validation -- Accessibility validation -- Notes -- 12 Web development planning -- Identify resources -- Build a web team -- Know your content -- Brainstorming and envisioning -- Discover 'what's out there' -- Find out 'what people think' -- Evaluate -- Study your current site -- Make decisions and continuously circle back -- Draft demos -- Circle back, again -- Software and web engineering -- Summary -- Notes -- 13 The dynamic duo -- Making the connection -- Querying the database -- Summary -- Notes -- 14 The indispensable function -- Jeffersonian functions -- Summary -- Notes -- 15 Database driven web applications -- Pulling it all together -- Sending commands with forms and variables -- Adding entries -- Editing entries -- Viewing entries -- Deleting entries -- Keyword searching -- Summary -- 16 Case studies -- Case study 1: A database driven website -- Case study 2: A web content management system -- Case study 3: A searchable online database -- Case study 4: A digital object management system -- Case study 5: A searchable URL database -- Case study 6: A link management system -- Case study 7: A database management system -- Notes -- Further reading -- Accessibility and standards -- CSS -- Database design and normalisation -- Free and open source software -- General web development -- MySQL -- PHP -- Index.