
- Paperback: 528 pages
 - Publisher: Prentice Hall PTR; Pap/Cdr edition (November 14, 2006)
 - Language: English
 - ISBN-10: 0132239973
 
 “Practical PHP and MySQL reflects Jono’s 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, it’s easy to build commercial-quality Web applications using free and open source software. With this book, you’ll learn from eight ready-to-run, real-world applications–all backed by clear diagrams and screenshots, well-documented code, and simple, practical explanations.
  
 Leading open source author Jono Bacon teaches the core skills you’ll need to build virtually any application. You’ll 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, you’ll 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, Ubuntu’s 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 O’Reilly Networkweblog author. He is a lead developer onthe Jokosher (www.jokosher.org) project,and co-founder of LUGRadio–a 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
 About the Author
 Jono Bacon works for Canonical as the Ubuntu community manager and is an established speaker, author, and regular contributor to the Open Source community. As an author, Bacon co-authored Linux Desktop Hacks and the Official Ubuntu Book, and has written more than 400 published articles in more than 14 publications. Bacon has also contributed as a columnist for Linux Format, Linux User & Developer, and PC Plus, and is an O’Reilly Network weblog author.
  
 In addition, Bacon is a regular contributor to Open Source in a range of projects, a lead developer on the Jokosher (www.jokosher.org) project, and one of the co-founders of the popular LUGRadio (www.lugradio.org) podcast–a show with more than 15,000 listeners and an annual event that pulls visitors from around the world.
 Download:
 http://w13.easy-share.com/991453.html