Open source database driven web development : a guide for information professionals / Isaac Hunter Dunlap.

Format:

Book

Author/Creator:

Dunlap, Isaac Hunter.

Series:

Chandos Information Professional Series

Chandos information professional series

Language:

English

Subjects (All):

Web site development.

Open source software.

Physical Description:

1 online resource (253 p.)

Edition:

1st ed.

Place of Publication:

Oxford, England : Chandos Publishing, 2006.

Language Note:

English

Summary:

Almost every organization seeks a simple means of managing, publishing and/or providing searchable web access to information. Written by a knowledgeable web developer, this book demonstrates the simplicity, cost-effectiveness, and versatility of designing database driven web applications with Open Source resources. Case studies of 'real world' implementations address both theoretical aspects and practical considerations of developing applications with the easy-to-use PHP scripting language and powerful MySQL relational database. Project organization and design issues are considered along with

Contents:

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 effectivenessAccess; 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 formSecond 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 planningIdentify 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 entriesEditing 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

Notes:

Description based upon print version of record.

Includes bibliographical references and index.

Description based on online resource; title from PDF title page (ebrary, viewed February 14, 2014).

ISBN:

1-78063-188-X

OCLC:

871224718