PHP & MySQL: Novice to Ninja: Get Up to Speed With PHP the Easy Way, 6th Edition

PHP & MySQL: Novice to Ninja, 6th Edition is a hands-on guide to learning all the tools, principles, and techniques needed to build a fully functional application using PHP & MySQL. Comprehensively updated to cover PHP 7 and modern best practice, this practical and fun book covers everything from installing PHP and MySQL through to creating a complete online content management system.

You’ll learn how to:

• Install PHP & MySQL on Windows, Mac OS X, or Linux
• Gain a thorough understanding of PHP syntax
• Use object oriented programming techniques
• Master database design principles and SQL
• Develop robust websites that can handle high levels of traffic
• Build a working content management system (CMS)
• And much more!

Table of Contents

Chapter 1. Installation
Chapter 2. Introducing PHP
Chapter 3. Introducing MySQL
Chapter 4. Publishing MySQL Data on the Web
Chapter 5. Relational Database Design
Chapter 6. Structured PHP Programming
Chapter 7. Improving the Insert and Update Functions
Chapter 8. Objects and Classes
Chapter 9. Creating an Extensible Framework
Chapter 10. Allowing Users to Register Accounts
Chapter 11. Cookies, Sessions, and Access Control
Chapter 12. MySQL Administration
Chapter 13. Relationships
Chapter 14. Content Formatting with Regular Expressions
Appendix A. Using The Sample Code Repository
Appendix B. Linux Troubleshooting