Phpmysql Novicetoninja

FIFTH EDITION

Pantone:

CMYK:

PHP & MYSQL
Grey scale PANTONE Orange 021 C CMYK O, 53, 100, 0 Black 50% PANTONE 2955 C CMYK 100, 45, 0, 37 Black 100%

NOVICE TO NINJA
BY KEVIN YANK

THE EASY WAY TO BUILD YOUR OWN DATABASE DRIVEN WEBSITE

Summary of Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xvii 1. Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2. Introducing MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 3. Introducing PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 4. Publishing MySQL Data on the Web .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 5. Relational Database Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 6. Structured PHP Programming . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 7. A Content Management System . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 8. ContentFormatting with Regular Expressions . . . . . . . . . . . . . . . . . . . . . . 237 9. Cookies, Sessions, and Access Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263 10. MySQL Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 319 11. Advanced SQL Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .341 12. Binary Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 359 A. Manual Installation Instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391 B. MySQL Syntax Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 423 C. MySQL Functions . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . 449 D. MySQL Column Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 483

PHP & MYSQL: NOVICE TO NINJA
BY KEVIN YANK 5TH EDITION

iv

PHP & MySQL: Novice to Ninjaby Kevin Yank Copyright © 2012 SitePoint Pty. Ltd. Product Manager: Simon Mackie Technical Editor: Diana MacDonald Indexer: Fred Brown Printing History: 1st Ed. Aug. 2001, 2nd Ed. Feb. 2003, 3rd Ed. Oct. 2004, 4th Ed. Jul. 2009 5th Ed. May 2012 Latest Update: May 2012 Editor: Kelly Steele Cover Designer: Alex Walker

Notice of Rights
All rights reserved. No part of this book may be reproduced,stored in a retrieval system or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embodied in critical articles or reviews.

Notice of Liability
The author and publisher have made every effort to ensure the accuracy of the information herein. However, the information contained in this book is sold withoutwarranty, either express or implied. Neither the authors and SitePoint Pty. Ltd., nor its dealers or distributors will be held liable for any damages to be caused either directly or indirectly by the instructions contained in this book, or by the software or hardware products described herein.

Trademark Notice
Rather than indicating every occurrence of a trademarked name as such, this book uses thenames only in an editorial fashion and to the benefit of the trademark owner with no intention of infringement of the trademark.

Published by SitePoint Pty. Ltd. 48 Cambridge Street Collingwood VIC Australia 3066 Web: www.sitepoint.com Email: business@sitepoint.com ISBN 978-0-9871530-8-1 (print) ISBN 978-0-9872478-1-0 (ebook) Printed and bound in the United States of America

v About the...