Book Description
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
-
PHP & MySQL: Novice to Ninja
- Preface
- 1. Installation
- 2. Introducing MySQL
- 3. Introducing PHP
- 4. Publishing MySQL Data on the Web
- 5. Relational Database Design
- 6. Structured PHP Programming
- 7. A Content Management System
- 8. Content Formatting with Regular Expressions
- 9. Cookies, Sessions, and Access Control
- 10. MySQL Administration
- 11. Advanced SQL Queries
- 12. Binary Data
- A. Manual Installation Instructions
- B. MySQL Syntax Reference
- C. MySQL Functions
- D. MySQL Column Types
- Index