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