PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
ISBN: 0321336577
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 166
Pages: 166
Authors: Larry Ullman
- VISUAL QUICKPRO GUIDE PHP and MySQL FOR DYNAMIC WEB SITES, Second Edition
- Table of Contents
- Copyright
- Introduction
- What Are Dynamic Web Sites?
- What You ll Need
- About This Book
- Is this book for you?
- What s new in this edition
- How this book compares to my other books
- Companion Web Site
- Chapter 1. Introduction to PHP
- Basic Syntax
- Sending Data to the Web Browser
- Understanding PHP, HTML, and White Space
- Writing Comments
- What Are Variables?
- About Strings
- About Numbers
- About Constants
- Single vs. Double Quotation Marks
- Chapter 2. Programming with PHP
- Creating an HTML Form
- Handling an HTML Form
- Managing Magic Quotes
- Conditionals and Operators
- Validating Form Data
- What Are Arrays?
- For and While Loops
- Chapter 3. Creating Dynamic Web Sites
- Including Multiple Files
- Handling HTML Forms with PHP Redux
- Making Sticky Forms
- Creating and Calling Your Own Functions
- Variable Scope
- Date and Time Functions
- Sending Email
- Chapter 4. Introduction to SQL and MySQL
- Choosing Your Column Types
- Choosing Other Column Properties
- Using the mysql Client
- Creating Databases and Tables
- Inserting Records
- Selecting Data
- Using Conditionals
- Using LIKE and NOT LIKE
- Sorting Query Results
- Limiting Query Results
- Updating Data
- Deleting Data
- Using Functions
- Chapter 5. Advanced SQL and MySQL
- Database Design
- Performing Joins
- Grouping Selected Results
- Creating Indexes
- Using Different Table Types
- Performing FULLTEXT Searches
- Database Optimization
- Chapter 6. Error Handling and Debugging
- General Error Types and Debugging
- Displaying PHP Errors
- Adjusting Error Reporting in PHP
- Creating Custom Error Handlers
- Logging PHP Errors
- PHP Debugging Techniques
- SQL and MySQL Debugging Techniques
- Chapter 7. Using PHP with MySQL
- Modifying the Template
- Connecting to MySQL and Selecting the Database
- Executing Simple Queries
- Retrieving Query Results
- Ensuring Secure SQL
- Counting Returned Records
- Updating Records with PHP
- Chapter 8. Web Application Development
- Adjusting Behavior for Server Settings
- Sending Values to a Script Manually
- Using Hidden Form Inputs
- Editing Existing Records
- Paginating Query Results
- Making Sortable Displays
- Understanding HTTP Headers
- Chapter 9. Cookies and Sessions
- Using Cookies
- Using Sessions
- Sessions and Cookies
- Improving Session Security
- Chapter 10. Web Application Security
- More Secure Form Validation
- Handling HTML
- Validating Data by Type
- Form Validation with JavaScript
- Regular Expressions
- Database Security and Encryption
- Chapter 11. Extended Topics
- Handling File Uploads
- PHP and JavaScript
- Using Output Buffering
- Using the Improved MySQL Extension
- New MySQL Features
- Using PEAR
- Chapter 12. ExampleContent Management
- Creating the Template
- Creating the Basic Pages
- Managing URLs
- Managing Files
- Chapter 13. ExampleUser Registration
- Creating the Templates
- Writing the Configuration Scripts
- Creating the Home Page
- Registration
- Activating an Account
- Logging In and Logging Out
- Password Management
- Chapter 14. ExampleE-Commerce
- Creating the Database
- The Administrative Side
- Creating the Public Template
- The Product Catalog
- The Shopping Cart
- Recording the Orders
- Appendix A. Installation
- Installation on Windows
- Installation on Mac OS X
- MySQL Permissions
- Testing Your Installation
- Configuring PHP
- Appendix B. Reference
- PHP
- MySQL
- Appendix C. Resources
- PHP
- MySQL
- SQL
- Security
- Other Resources
- Index
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
ISBN: 0321336577
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 166
Pages: 166
Authors: Larry Ullman