specializing in digital media technologies

• Introduction
• What are Dynamic Web Sites?
• What is PHP?
• What is MySQL?
• What You'll Need
• About This Book
• 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
• Sending Values to a Script Manually
• What Are Arrays?
• For and While Loops
• Chapter 3: Creating Dynamic Web Sites
• Using External Files
• Creating and Calling Your Own Functions
• Variable Scope
• Handling HTML Forms with PHP Redux
• Sending Email
• HTTP Headers
• Making Sticky Forms
• Date and Time Functions
• Chapter 4: Introduction to SQL and MySQL
• Designing Tables
• Using the mysql monitor
• 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
• Chapter 5: Advanced SQL and MySQL
• Database Design
• Performing Joins
• Using Functions
• Indexes
• Chapter 6: Using PHP and MySQL
• Making the Template
• Connecting to MySQL and Selecting the Database
• Error Handling
• Executing Simple Queries
• Retrieving Query Results
• Security
• Using mysql_num_rows()
• Updating Records with PHP
• Chapter 7: Cookies and Sessions
• Using Cookies
• Using Sessions
• Sessions and Cookies
• Chapter 8: Security
• HTTP Authentication
• Form Validation with JavaScript
• Regular Expressions
• Database Security
• Chapter 9: Web Application Development
• PHP Debugging Techniques
• SQL and MySQL Debugging Techniques
• PHP Error Management
• MySQL Error Management
• Improving Web Application Performance
• Chapter 10: Extended Topics
• Output Buffering
• Page Caching
• Web Browser Detection
• PHP and JavaScript
• Using PEAR
• Chapter 11: ExampleÑContent Management
• Creating the Template
• Creating the Basic Pages
• Managing URLs
• Managing Files
• Chapter 12: ExampleÑUser Registration
• Creating the Templates
• Writing the Configuration Scripts
• Creating the Home Page
• Registration
• Logging In and Logging Out
• Password Management
• Site Administration
• Chapter 13: ExampleÑE-Commerce
• Creating the Database
• The Administrative Side
• Creating the Public Template
• The Product Catalog
• The Shopping Cart
• Appendix A: Installation
• Installation on Mac OS X
• Installation on Windows
• MySQL Permissions
• Testing Your Installation
• Appendix B: Third-Party Applications
• phpMyAdmin
• Template Systems
• Forum Software
• Content Management
• E-Commerce
• Search Engines
• Code Repositories
• Appendix C: Reference
• PHP
• MySQL
• Appendix D: Resources
• PHP
• MySQL
• SQL
• Security
• Other
• Index

Search This Book!

Temporary Site Outage

After performing some routine maintenance, the DMC Insights, Inc. server will need to be rebooted on Friday, July 11, 2008, between 4:00am and 7:00am EST. The Web site should be unavailable for no more than 15 minutes. I apologize for any inconvenience.
(July 9, 2008)

Newsletter #14 Released

I just sent out the latest version of the newsletter. It covers a bunch of different things, with some early thoughts on the Ruby programming language. You can read it online at www.DMCInsights.com/newsletter.php.
(July 9, 2008)

Adobe AIR: VQS Chapter Available Online

Peachpit Press, has posted part of Chapter 2, "Creating an Application," from the book "Adobe AIR (Adobe Integrated Runtime) with Ajax: Visual QuickStart Guide" on their Web site. The pages discuss some of the basic technologies and how they can be used together in an AIR application. The direct URL is http://www.peachpit.com/articles/article.aspx?p=1211888.
(July 2, 2008)

more news...