Table of Contents


book cover
VISUAL QUICKPRO GUIDE PHP and MySQL FOR DYNAMIC WEB SITES, Second Edition
By Larry Ullman
...............................................
Publisher: Peachpit Press
Pub Date: June 21, 2005
ISBN: 0-321-33657-7
Pages: 720
 



Table of Contents  | Index

   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



PHP and MySQL for Dynamic Web Sites. Visual QuickPro Guide
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
ISBN: 0321336577
EAN: 2147483647
Year: 2005
Pages: 166
Authors: Larry Ullman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net