Web Development

687 Pages·2016·8.01 MB·English

by  Luke Welling

ptg18145125
ptg18145125
“I’ve never purchased a better “I picked up this book two days ago
programming book… This book proved and I am half way finished. I just can’t
to be the most informative, easiest to put it down. The layout and flow is
follow, and had the best examples of perfect. Everything is presented in such
any other computer-related book I have a way so that the information is very
ever purchased. The text is very easy to palatable. I am able to immediately grasp
follow!” all the concepts. The examples have also
been wonderful. I just had to take some
—Nick Landman
time out to express to you how pleased
I have been with this book.”
“This book by Welling & Thomson
is the only one which I have found to —Jason B. Lancaster
be indispensable. The writing is clear
and straightforward but never wastes “This book has proven a trusty
my time. The book is extremely well companion, with an excellent crash
laid out. The chapters are the right course in PHP and superb coverage of
length and chapter titles quickly take MySQL as used for Web applications.
you where you want to go.” It also features several complete
applications that are great examples
— Wright Sullivan, President,
A&E Engineering, Inc., of how to construct modular, scalable
Greer South Carolina applications with PHP. Whether you
are a PHP newbie or a veteran in search
“I just wanted to tell you that of a better desk-side reference, this one
ptg18145125
I think the book PHP and MySQL is sure to please!”
Web Development rocks! It’s logically
—WebDynamic
structured, just the right difficulty level
for me (intermediate), interesting and
“The true PHP/MySQL bible, PHP
easy to read, and, of course, full of
and MySQL Web Development by Luke
valuable information!”
Welling and Laura Thomson, made me
—CodE-E, Austria realize that programming and databases
are now available to the commoners.
“There are several good Again, I know 1/10000th of what there
introductory books on PHP, but is to know, and already I’m enthralled.”
Welling & Thomson is an excellent
—Tim Luoma, TnTLuoma.com
handbook for those who wish to build
up complex and reliable systems. It’s
“Welling and Thomson’s book is
obvious that the authors have a strong
a good reference for those who want
background in the development of
to get to grips with practical projects
professional applications and they
straight off the bat. It includes webmail,
teach not only the language itself, but
shopping cart, session control, and
also how to use it with good software
web-forum/weblog applications as a
engineering practices.”
matter of course, and begins with a
— Javier Garcia, senior telecom engi- sturdy look at PHP first, moving to
neer, Telefonica R&D Labs, Madrid MySQL once the basics are covered.”
—twilight30 on Slashdot
“This book is absolutely excellent, applications with two of the most
to say the least…. Luke Welling and popular open-source Web development
Laura Thomson give the best in-depth technologies…. The projects are the
explanations I’ve come across on such real jewel of the book. Not only are the
things as regular expressions, classes and projects described and constructed in
objects, sessions etc. I really feel this a logical, component-based manner,
book filled in a lot of gaps for me with but the selection of projects represents
things I didn’t quite understand…. This an excellent cross-section of common
book jumps right into the functions components that are built into many
and features most commonly used with web sites.”
PHP, and from there it continues in
—Craig Cecil
describing real-world projects, MySQL
integration, and security issues from “The book takes an easy, step-by-
a project manager’s point of view. step approach to introduce even the
I found every bit of this book to be well clueless programmer to the language of
organized and easy to understand.” PHP. On top of that, I often find myself
—notepad on codewalkers.com referring back to it in my Web design
efforts. I’m still learning new things
“A top-notch reference for about PHP, but this book gave me a
programmers using PHP and MySQL. solid foundation from which to start
Highly recommended.” and continues to help me to this day.”
—The Internet Writing Journal —Stephen Ward ptg18145125
“This book rocks! I am an “This book is one of few that really
experienced programmer, so I didn’t touched me and made me ‘love’ it.
need a lot of help with PHP syntax; I can’t put it in my bookshelf; I must
after all, it’s very close to C/C++. I don’t put it in a touchable place on my
know a thing about databases, though, working bench as I always like to refer
so when I wanted to develop a book from it. Its structure is good, wordings
review engine (among other projects) are simple and straight forward, and
I wanted a solid reference to using examples are clear and step by step.
MySQL with PHP. I have O’Reilly’s Before I read it, I knew nothing of PHP
mSQL and MySQL book, and it’s and MySQL. After reading it, I have the
probably a better pure-SQL reference, confidence and skill to develop any
but this book has earned a place on my complicated Web application.”
reference shelf…Highly recommended.”
—Power Wong
—Paul Robichaux
“This book is God…. I highly
“One of the best programming recommend this book to anyone
guides I’ve ever read.” who wants to jump in the deep end
with database driven Web application
—jackofsometrades from Lahti, Finland
programming. I wish more computer
books were organized this way.”
“This is a well-written book
for learning how to build Internet —Sean C Schertell
PHP MySQL
and ®
Web Development
ptg18145125
Fifth Edition
Developer’s Library
ESSENTIAL REFERENCES FOR PROGRAMMING PROFESSIONALS
Developer’s Library books are designed to provide practicing programmers with unique,
high-quality references and tutorials on the programming languages and technologies
they use in their daily work.
All books in the Developer’s Library are written by expert technology practitioners who
are especially skilled at organizing and presenting information in a way that’s useful for
other programmers.
Key titles include some of the best, most widely acclaimed books within their
topic areas:
PHP & MySQL Python Essential Reference
Web Development David Beazley
Luke Welling & Laura Thomson
Node.js, MongoDB and Angular
MySQL Web Development ptg18145125
Paul DuBois Brad Dayley
Programming in C C++ Primer Plus
Stephen Kochan Stephen Prata
Developer’s Library books are available in print and in electronic formats at most
retail and online bookstores, as well as by subscription from Safari Books Online at
safari.informit.com
Developer’s
Library
informit.com/devlibrary
PHP MySQL
and ®
Web Development
ptg18145125
Fifth Edition
Luke Welling
Laura Thomson
Hoboken, NJ • Boston • Indianapolis • San Francisco
New York • Toronto • Montreal • London • Munich • Paris • Madrid
Cape Town • Sydney • Tokyo • Singapore • Mexico City
PHP and MySQL® Web Development Editor
Copyright © 2017 by Pearson Education, Inc. Mark Taber
Project Editor
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system,
or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, Lori Lyons
without written permission from the publisher. No patent liability is assumed with respect Project Manager
to the use of the information contained herein. Although every precaution has been taken Dhayanidhi
in the preparation of this book, the publisher and authors assume no responsibility for
Copy Editor
errors or omissions. Nor is any liability assumed for damages resulting from the use of the
Lori Eby
information contained herein.
Indexer
ISBN-13: 978-0-321-83389-1
Tim Wright
ISBN-10: 0-321-83389-9 Technical Editor
Library of Congress Control Number: 2016934688 Julie Meloni
Printed in the United States of America
First Printing: September 2016
Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have
been appropriately capitalized. Pearson cannot attest to the accuracy of this information.
Use of a term in this book should not be regarded as affecting the validity of any trademark
or service mark.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible,
but no warranty or fitness is implied. The information provided is on an “as is” basis. The
authors and the publisher shall have neither liability nor responsibility to any person or entity
with respect to any loss or damages arising from the information contained in this book.
ptg18145125
Special Sales
For information about buying this title in bulk quantities, or for special sales opportunities
(which may include electronic versions; custom cover designs; and content particular to your
business, training goals, marketing focus, or branding interests), please contact our
corporate sales department at [email protected] or [phone].
For government sales inquiries, please contact [email protected].
For questions about sales outside the U.S., please contact [email protected].
Contents at a Glance
Introduction 1
I: Using PHP
1 PHP Crash Course 11
2 Storing and Retrieving Data 53
3 Using Arrays 75
4 String Manipulation and Regular Expressions 101
5 Reusing Code and Writing Functions 131
6 Object-Oriented PHP 159
7 Error and Exception Handling 199
II: Using MySQL
8 Designing Your Web Database 209
ptg18145125
9 Creating Your Web Database 221
10 Working with Your MySQL Database 247
11 Accessing Your MySQL Database from the Web with PHP 271
12 Advanced MySQL Administration 291
13 Advanced MySQL Programming 315
III: Web Application Security
14 Web Application Security Risks 331
15 Building a Secure Web Application 341
16 Implementing Authentication Methods with PHP 365
IV: Advanced PHP Techniques
17 Interacting with the File System and the Server 379
18 Using Network and Protocol Functions 403
19 Managing the Date and Time 423
viii Contents at a Glance
20 Internationalization and Localization 437
21 Generating Images 449
22 Using Session Control in PHP 475
23 Integrating JavaScript and PHP 493
24 Other Useful Features 519
V: Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects 529
26 Debugging and Logging 543
27 Building User Authentication and Personalization 561
28 Building a Web-Based Email Service with Laravel Part I Web Edition
29 Building a Web-Based Email Service with Laravel Part II Web Edition
30 Social Media Integration Sharing and Authentication Web Edition
31 Building a Shopping Cart Web Edition
ptg18145125
VI: Appendix
A Installing Apache, PHP, and MySQL 599
Index 615