Home Page Icon
Home Page
Table of Contents for
cover
Close
cover
by Marc Rochkind
Expert PHP and MySQL: Application Design and Development
Title Page
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
CHAPTER 1: Project Organization
People Determine Success
Projects Have Three Dimensions
Requirements
The Development Team
The Schedule
Why Projects Fail
Managing the Project
Dividing the Work
The Workplace
Issue Tracking
Legal Matters
Getting Paid
Chapter Summary
CHAPTER 2: Requirements
Outline of the Requirements Document
When the Requirements Change
Use Cases
Requirements War Stories
Agile Requirements
Chapter Summary
CHAPTER 3: Platforms and Tools
Client-Server Architecture
Server Platform
Client Platform
Development Platform and Tools
Hosting Alternatives
Installing New Versions
Chapter Summary
CHAPTER 4: The Database
Relational Databases
SQL
Entity-Relationship Modeling
Physical Design
Normalization
Constraints
Transactions
Database Security
Performance Optimization
Do You Have a Good Database?
Developing an Object-Relational Mapping Layer
Chapter Summary
CHAPTER 5: Application Structure
Accessing MySQL from PHP
PHP-Browser Interaction
PHP Sessions
A Page Framework
Dealing with Relationships
Chapter Summary
CHAPTER 6: Security, Forms, and Error Handling
PHP Security Overview
Forms
The User Table and Password Management
Logging In and Handling Forgotten Passwords
Changing a Password
Using a YubiKey for 2FA Phase 2
Error Handling
Chapter Summary
CHAPTER 7: Reports and Other Outputs
Queries as Reports
Role-Based Access Control
The Report Class: HTML and CSV Output
Generating PDFs from PHP
The Report Class: PDF Output
Using the Report Class to Build Reports
A Generalized Reports Page
Chapter Summary
CHAPTER 8: Data Conversion
Conversion in the Development Process
Conversion Sources
Generating Conversion Programs Automatically
Dates, Times, and Character Conversion
After Conversion
Variant Names
Chapter Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset