This book is a short guide, suitable for everyone, that teaches you how to structure data and set-up your MySQL database tables efficiently and easily.

phpMyAdmin Providing a powerful graphical interface for managing MySQL, phpMyAdmin is one of the most popular open source applications. While most MySQL developers use routine features of phpMyAdmin every day, few are aware of the power and potential of its advanced features. This book builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet of this legendary tool.

MySQL Used by millions of developers, MySQL is the most popular open source database, supporting numerous large dynamic websites and applications. MySQL has acquired this wide popularity by virtue of its open source nature, performance, reliability, robustness, and support for various platforms. However, this popularity has also been helped by the existence of phpMyAdmin, the industry standard administration tool that makes database management easy for both the experienced developer and their novice.

This is a comprehensive, practical guide for programmers who want to develop production-quality, database-enabled web applications with PHP and MySQL. Long-time developer Marc Wandschneider systematically addresses the entire process: not only coding, but also upfront application, user interface and database design, PLUS security, testing, and more.

Youll walk through building three applications from start to finish: a calendaring system, a weblog engine, and an e-commerce store. Along the way, youll master essential strategies for creating robust web database applications and learn how to avoid the common pitfalls that trip up many developers moving to PHP and MySQL.

• Starts with a complete primer on PHP for developersincluding coverage of code organization, reuse, and object-oriented PHP
• Contains detailed treatments of data access, including transactions, foreign keys, and indexes
• Presents powerful data validation techniques utilizing PHP regular expressions
• Walks through planning web applications, including user interfaces and user management
• Offers systematic guidance on securing web applications from end to end
• Covers a wide range of implementation issuesincluding internationalization, error handling, data validation, debugging, session management, and deployment
• Includes detailed chapters on XML, XML-based web services, and the PEAR framework for reusable PHP components
• Shows how to work with the Oracle and PostgreSQL databases