Cover image for PHP & MySQL: Novice to Ninja, 5th Edition

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

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