PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

by Ullman, Larry

• ISBN13: 9780321336576
• ISBN10: 0321336577
• Edition: 2nd
• Format: Paperback
• Copyright: 2005-01-01
• Publisher: Peachpit Pr

Summary

The follow-up to the bestselling task-based guide to MySQL and PHP, at a price readers will appreciate.

Table of Contents

Introduction	ix
Introduction to PHP	1	(34)
Basic Syntax	2	(4)
Sending Data to the Web Browser	6	(4)
Understanding PHP, HTML, and White Space	10	(5)
Writing Comments	15	(3)
What Are Variables?	18	(3)
About Strings	21	(4)
About Numbers	25	(4)
About Constants	29	(3)
Single vs. Double Quotation Marks	32	(3)
Programming with PHP	35	(46)
Creating an HTML Form	36	(4)
Handling an HTML Form	40	(4)
Managing Magic Quotes	44	(3)
Conditionals and Operators	47	(5)
Validating Form Data	52	(5)
What Are Arrays?	57	(20)
For and While Loops	77	(4)
Creating Dynamic Web Sites	81	(44)
Including Multiple Files	82	(9)
Handling HTML Forms with PHP Redux	91	(4)
Making Sticky Forms	95	(3)
Creating and Calling Your Own Functions	98	(12)
Variable Scope	110	(4)
Date and Time Functions	114	(4)
Sending Email	118	(7)
Introduction to SQL and MySQL	125	(44)
Choosing Your Column Types	126	(4)
Choosing Other Column Properties	130	(2)
Using the mysql Client	132	(4)
Creating Databases and Tables	136	(3)
Inserting Records	139	(3)
Selecting Data	142	(2)
Using Conditionals	144	(3)
Using LIKE and NOT LIKE	147	(2)
Sorting Query Results	149	(2)
Limiting Query Results	151	(2)
Updating Data	153	(2)
Deleting Data	155	(2)
Using Functions	157	(12)
Advanced SQL and MySQL	169	(42)
Database Design	170	(16)
Performing Joins	186	(4)
Grouping Selected Results	190	(2)
Creating Indexes	192	(3)
Using Different Table Types	195	(3)
Performing FULLTEXT Searches	198	(7)
Database Optimization	205	(6)
Error Handling and Debugging	211	(24)
General Error Types and Debugging	212	(6)
Displaying PHP Errors	218	(1)
Adjusting Error Reporting in PHP	219	(3)
Creating Custom Error Handlers	222	(4)
Logging PHP Errors	226	(3)
PHP Debugging Techniques	229	(3)
SQL and MySQL Debugging Techniques	232	(3)
Using PHP with MySQL	235	(40)
Modifying the Template	236	(1)
Connecting to MySQL and Selecting the Database	237	(4)
Executing Simple Queries	241	(9)
Retrieving Query Results	250	(4)
Ensuring Secure SQL	254	(6)
Counting Returned Records	260	(6)
Updating Records with PHP	266	(9)
Web Application Development	275	(48)
Adjusting Behavior for Server Settings	276	(3)
Sending Values to a Script Manually	279	(4)
Using Hidden Form Inputs	283	(6)
Editing Existing Records	289	(8)
Paginating Query Results	297	(8)
Making Sortable Displays	305	(8)
Understanding HTTP Headers	313	(10)
Cookies and Sessions	323	(52)
Using Cookies	324	(18)
Using Sessions	342	(17)
Sessions and Cookies	359	(9)
Improving Session Security	368	(7)
Web Application Security	375	(46)
More Secure Form Validation	376	(12)
Handling HTML	388	(4)
Validating Data by Type	392	(5)
Form Validation with JavaScript	397	(7)
Regular Expressions	404	(12)
Database Security and Encryption	416	(5)
Extended Topics	421	(52)
Handling File Uploads	422	(12)
PHP and JavaScript	434	(10)
Using Output Buffering	444	(9)
Using the Improved MySQL Extension	453	(5)
New MySQL Features	458	(9)
Using PEAR	467	(6)
Example --- Content Management	473	(54)
Creating the Template	474	(4)
Creating the Basic Pages	478	(4)
Managing URLs	482	(31)
Managing Files	513	(14)
Example --- User Registration	527	(50)
Creating the Templates	528	(4)
Writing the Configuration Scripts	532	(7)
Creating the Home Page	539	(2)
Registration	541	(11)
Activating an Account	552	(4)
Logging In and Logging Out	556	(8)
Password Management	564	(13)
Example --- E-Commerce	577	(56)
Creating the Database	578	(5)
The Administrative Side	583	(16)
Creating the Public Template	599	(4)
The Product Catalog	603	(12)
The Shopping Cart	615	(11)
Recording the Orders	626	(7)
Appendix A: Installation	633	(20)
Installation on Windows	634	(5)
Installation on Mac OS X	639	(4)
MySQL Permissions	643	(5)
Testing Your Installation	648	(2)
Configuring PHP	650	(3)
Appendix B: Reference	653	(10)
PHP	654	(4)
MySQL	658	(5)
Appendix C: Resources	663	(12)
PHP	664	(3)
MySQL	667	(2)
SQL	669	(1)
Security	670	(1)
Other Resources	671	(4)
Index	675