“Practical PHP and MySQL reflects Jonos commitment to the spirit of making open source subjects accessible to everyone. The book carefully walks you through the code for eight useful, dynamic Web applications. Projects are presented in a playful way, like the forum project that touts horror movies that make you ‘hide behind the couch.”
From the Foreword by Christopher Negus, Series Editor, Negus Live Linux Series
Build Dynamic Web Sites Fast, with PHP and MySQL...
Learn from Eight Ready-to-Run Applications!
Suddenly, its easy to build commercial-quality Web applications using free and open source software. With this book, youll learn from eight ready-to-run, real-world applicationsall backed by clear diagrams and screenshots, well-documented code, and simple, practical explanations.
Leading open source author Jono Bacon teaches the core skills youll need to build virtually any application. Youll discover how to connect with databases, upload content, perform cascading deletes, edit records, validate registrations, specify user security, create reusable components, use PEAR extensions, and even build Ajax applications.
Working from complete examples on the CD-ROM, youll create
Generic dynamic Web sites
Blogs
Discussion forums
Shopping carts
Auction sites
Calendars
FAQ systems
Reusable components
Content management systems
News sites
JONO BACON is Ubuntu community manager for Canonical, Ubuntus sponsor. He is an established speaker, author, and contributor to the open source community. Bacon co-authored Linux
Desktop Hacks and The Official Ubuntu Book; has served as a columnist for Linux Format, Linux User & Developer, and PC Plus; and is an OReilly Networkweblog author. He is a lead developer onthe Jokosher (www.jokosher.org) project,and co-founder of LUGRadioa podcastwith more than 15,000 listeners, andan annual event that attracts visitorsfrom around the world.
CD-ROM Includes
XAMPP for Linux: easy-to-install, preconfigured Apache distributions containing MySQL, PHP, Perl, and more
Source code for all eight fully-working applications discussed in the book
A remastered Ubuntu live CD, set to run all eight applications live
System Requirements
CPU: Pentium III, 650 MHz. RAM: 256MB (recommended 512MB).
Hard disk: No space required to run live CD; 250MB of space needed to put XAMPP server and projects on installed system.
Contents
Foreword xi
About the Author xii
Acknowledgments xiii
Introduction 1
Chapter 1 A New Approach 5
Chapter 2 Getting Started with PHP and MySQL 15
Chapter 3 Running the Projects 53
Chapter 4 Building a Weblog 63
Chapter 5 Discussion Forums 111
Chapter 6 Creating a Shopping Cart 169
Chapter 7 Building an Online Auction Site 219
Chapter 8 Creating a Web-Based Calendar 265
Chapter 9 FAQ Content Management System 303
Chapter 10 Building a Re-Usable Project 379
Chapter 11 Building a News Web Site 425
Appendix A Web Site Design 469
Index 499
