- About This E-Book
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- Lead Authors
- Contributing Authors
- We Want to Hear from You!
- Reader Services
- Accessing the Free Web Edition
- Introduction
- I: Using PHP
- 1. PHP Crash Course
- Before You Begin: Accessing PHP
- Creating a Sample Application: Bob’s Auto Parts
- Embedding PHP in HTML
- Adding Dynamic Content
- Accessing Form Variables
- Understanding Identifiers
- Examining Variable Types
- Declaring and Using Constants
- Understanding Variable Scope
- Using Operators
- Working Out the Form Totals
- Understanding Precedence and Associativity
- Using Variable Handling Functions
- Making Decisions with Conditionals
- Repeating Actions Through Iteration
- Breaking Out of a Control Structure or Script
- Employing Alternative Control Structure Syntax
- Using declare
- Next
- 2. Storing and Retrieving Data
- 3. Using Arrays
- 4. String Manipulation and Regular Expressions
- Creating a Sample Application: Smart Form Mail
- Formatting Strings
- Joining and Splitting Strings with String Functions
- Comparing Strings
- Matching and Replacing Substrings with String Functions
- Introducing Regular Expressions
- The Basics
- Delimiters
- Character Classes and Types
- Repetition
- Subexpressions
- Counted Subexpressions
- Anchoring to the Beginning or End of a String
- Branching
- Matching Literal Special Characters
- Reviewing Meta Characters
- Escape Sequences
- Backreferences
- Assertions
- Putting It All Together for the Smart Form
- Finding Substrings with Regular Expressions
- Replacing Substrings with Regular Expressions
- Splitting Strings with Regular Expressions
- Further Reading
- Next
- 5. Reusing Code and Writing Functions
- 6. Object-Oriented PHP
- Understanding Object-Oriented Concepts
- Creating Classes, Attributes, and Operations in PHP
- Instantiating Classes
- Using Class Attributes
- Calling Class Operations
- Controlling Access with private and public
- Writing Accessor Functions
- Implementing Inheritance in PHP
- Using Traits
- Designing Classes
- Writing the Code for Your Class
- Understanding Advanced Object-Oriented Functionality in PHP
- Using Per-Class Constants
- Implementing Static Methods
- Checking Class Type and Type Hinting
- Late Static Bindings
- Cloning Objects
- Using Abstract Classes
- Overloading Methods with __call()
- Using __autoload()
- Implementing Iterators and Iteration
- Generators
- Converting Your Classes to Strings
- Using the Reflection API
- Namespaces
- Using Subnamespaces
- Understanding the Global Namespace
- Importing and Aliasing Namespaces
- Next
- 7. Error and Exception Handling
- 1. PHP Crash Course
- II: Using MySQL
- 8. Designing Your Web Database
- 9. Creating Your Web Database
- Using the MySQL Monitor
- Logging In to MySQL
- Creating Databases and Users
- Setting Up Users and Privileges
- Introducing MySQL’s Privilege System
- Setting Up a User for the Web
- Using the Right Database
- Creating Database Tables
- Understanding MySQL Identifiers
- Choosing Column Data Types
- Further Reading
- Next
- 10. Working with Your MySQL Database
- 11. Accessing Your MySQL Database from the Web with PHP
- 12. Advanced MySQL Administration
- 13. Advanced MySQL Programming
- III: Web Application Security
- 14. Web Application Security Risks
- 15. Building a Secure Web Application
- 16. Implementing Authentication Methods with PHP
- IV: Advanced PHP Techniques
- 17. Interacting with the File System and the Server
- 18. Using Network and Protocol Functions
- 19. Managing the Date and Time
- 20. Internationalization and Localization
- 21. Generating Images
- 22. Using Session Control in PHP
- 23. Integrating JavaScript and PHP
- 24. Other Useful Features
- V: Building Practical PHP and MySQL Projects
- 25. Using PHP and MySQL for Large Projects
- Applying Software Engineering to Web Development
- Planning and Running a Web Application Project
- Reusing Code
- Writing Maintainable Code
- Implementing Version Control
- Choosing a Development Environment
- Documenting Your Projects
- Prototyping
- Separating Logic and Content
- Optimizing Code
- Testing
- Further Reading
- Next
- 26. Debugging and Logging
- 27. Building User Authentication and Personalization
- 25. Using PHP and MySQL for Large Projects
- VI: Appendix
- Index
PHP and MySQL® Web Development
Copyright © 2017 by Pearson Education, Inc.
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, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
ISBN-13: 978-0-321-83389-1
ISBN-10: 0-321-83389-9
Library of Congress Control Number: 2016934688
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.
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 (800) 382-3419.
For government sales inquiries, please contact [email protected].
For questions about sales outside the U.S., please contact [email protected].
Editor
Mark Taber
Project Editor
Lori Lyons
Project Manager
Dhayanidhi
Copy Editor
Lori Eby
Indexer
Tim Wright
Technical Editor
Julie Meloni
-
No Comment