PHP & MySQL: Novice to Ninja, 5th Edition

PHP & MySQL: Novice to Ninja is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully-functional database-driven web site using PHP & MySQL.

This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live web-based content management system.

While this is essentially a beginner’s book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL that include:

• MySQL syntax
• MySQL functions
• MysQL column types
• PHP functions for working with MySQL

Table of Contents
Chapter 1. Installation
Chapter 2. Introducing MySQL
Chapter 3. Introducing PHP
Chapter 4. Publishing MySQL Data on the Web
Chapter 5. Relational Database Design
Chapter 6. Structured PHP Programming
Chapter 7. A Content Management System
Chapter 8. Content Formatting with Regular Expressions
Chapter 9. Cookies, Sessions, and Access Control
Chapter 10. MySQL Administration
Chapter 11. Advanced SQL Queries
Chapter 12. Binary Data

Appendix A. Manual Installation Instructions
Appendix B. MySQL Syntax Reference
Appendix C. MySQL Functions
Appendix D. MySQL Column Types

Book Details

• Paperback: 481 pages
• Publisher: SitePoint; 5th Edition  (May 2012)
• Language: English
• ISBN-10: 0987153080
• ISBN-13: 978-0987153081