Creating Interactive Websites With Php and Web Services

by Rosebrock, Eric

• ISBN13: 9780782142792
• ISBN10: 0782142796
• Edition: 1st
• Format: Paperback
• Copyright: 2003-12-23
• Publisher: Sybex

Summary

Build Dynamic Websites with PHP and MySQL-and Extend Those Sites with Web ServicesPHP and MySQL are great tools for building database-driven websites. There's nothing new about that. What is new is the environment in which your site operates-a world rich (and growing richer) in web services that can add value and functionality in many different ways. Creating Interactive Web Sites with PHP and Web Services walks you through every step of a major web project-a content-management system-teaching you both the basic techniques and little-known tricks you need to build successful web sites. And you can use those skills to develop dynamic applications that will meet your special requirements. Here's some of what you'll find covered inside: Adding, deleting, and displaying data with a custom content-management system Building a template system with PHP Interacting with web services using PHP and MySQL Creating and managing a user system and a shopping cart Processing credit card payments using merchant accounts and third-party payment solutions Tracking site statistics using PHP and MySQL Enhancing your site with third-party scripts Tons of examples, complete with explanations and supported by online source code, will speed your progress, whether you're a true beginner or already have PHP experience. This book is platform-agnostic, so it doesn't matter if you're deploying your site on Linux or Windows. You also get PHP and MySQL references, so you can quickly resolve questions about syntax and similar issues.

Author Biography

Eric Rosebrock, owner of PHP Freaks (http://www.phpfreaks.com), a community of developers helping one another learn and troubleshoot PHP. Eric has developed web pages with HTML, JavaScript, and ASP for 7 years and has been a professional PHP developer for 2 years. He has extensive knowledge of PHP, MySQL, Apache Web Server, and the Linux. Eric was a Windows 2k Sys Admin for the U.S.A.F. for 5 years, and has maintained over 2,000 workstations, 50 Windows 2k and NT servers, and IIS web servers.

Table of Contents

Introduction	xvii
Introducing PHP	1	(24)
Getting a History Lesson in PHP	2	(1)
Understanding the Requirements for PHP	3	(1)
Operating System Support	3	(1)
Web Server Support	4	(1)
Exploring PHP-Related Software	4	(1)
MySQL Database Management Tools	4	(1)
PHP Editors	5	(1)
Working with PHP	5	(18)
Writing Your First PHP Script	6	(2)
Working with Strings and Variables	8	(7)
Working with PHP Functions	15	(6)
Error Handling and Trapping	21	(1)
Using Output Buffering	22	(1)
What's Next?	23	(2)
Planning Your Project	25	(14)
Getting the Most from Your Idea	26	(3)
Brainstorming Details for an Idea	27	(1)
Researching Concepts	28	(1)
Planning and Information Gathering	29	(3)
Planning a Website Layout, Sections, and Features	30	(1)
Planning a MySQL Database	30	(1)
Planning for a Target Audience	31	(1)
Setting Up the Project Logistics	32	(4)
PHP Developers	32	(1)
Graphic Artists	32	(1)
Server Administrators	33	(2)
Project Managers/Team Coordinators	35	(1)
What's Best for You?	35	(1)
Considering the Hardware Requirements	36	(1)
What's Next?	37	(2)
Building a Database Schema with MySQL	39	(28)
Understanding MySQL	40	(3)
MySQL Table Types	40	(1)
MySQL Column Types	41	(1)
What Is ADOdb?	42	(1)
Using MySQL Database Tools	43	(23)
Using phpMyAdmin: Web-Based MySQL Administration	43	(14)
SQLyog MySQL Manager for Windows	57	(6)
Connecting to MySQL Databases with PHP	63	(1)
Persistent and Nonpersistent MySQL Connections	64	(1)
Making the Connection	64	(2)
What's Next?	66	(1)
Building a Website Template with PHP	67	(18)
Designing Your Layout	68	(7)
Creating the HTML	69	(2)
Creating the PHP Code	71	(2)
Using the layout.php File	73	(2)
Introducing Classes	75	(9)
Creating the Basic Class Structure	75	(2)
Creating the META Content Class	77	(4)
Using the Meta Content Class	81	(3)
What's Next?	84	(1)
Creating a Website Membership System	85	(60)
Preparing the Membership System	86	(3)
Creating the common.php File	86	(1)
Including a Welcome Message HTML File	87	(1)
Securing Web Directories	88	(1)
Setting Up the Membership System Database Tables	89	(1)
Creating a Membership Signup Script	90	(33)
Creating the HTML Signup Form	90	(3)
Creating the join.php Script Structure	93	(1)
Processing the Form Information	94	(12)
Inserting the Members' Data into the MySQL Database	106	(1)
Sending E-mail with PHP	107	(6)
Displaying Success Message After Signup	113	(1)
Verifying the User's E-mail Address	114	(4)
Looking at the join.php File Summary	118	(5)
Creating the Login System	123	(7)
Starting PHP Sessions	123	(1)
Creating the Login Verification Script	124	(6)
Creating a Lost Password Script	130	(7)
Creating the Membership Hyperlinks Box	137	(4)
Granting Member-Only Access	141	(1)
Logging Out	142	(2)
What's Next?	144	(1)
Developing a Website News System	145	(58)
Planning the News System	146	(1)
Preparing the Website Administrator Access	146	(1)
Preparing the MySQL Database	147	(1)
Creating the News Article Category Management System	148	(18)
Creating the News Article Category Insert Script	148	(6)
Creating the News Article Category Update and Delete Script	154	(7)
Creating the News Article Category Administrator Hyperlinks	161	(2)
Testing the News Article Category Management System	163	(3)
Creating the News Article Management System	166	(34)
Creating the News Article Insert Script	166	(6)
Creating the News Article Modify and Delete Script	172	(10)
Testing the News Article Management System	182	(4)
Creating the News Article Index Include File	186	(6)
Creating the Read Full Articles Script	192	(6)
Creating a Hyperlinks Box	198	(2)
Challenge: Create a News Article Comment System	200	(1)
Adding News Feeds	200	(1)
What's Next?	201	(2)
Enhancing Your Website with Web Services and APIs	203	(26)
Working with Web Services	204	(10)
Using Google Language Translation Services	204	(4)
Using the Google Search Engine in Your Website	208	(6)
Working with APIs	214	(14)
Amazon Web Services API Made Simple	214	(14)
What's Next?	228	(1)
Creating a Shopping Cart System	229	(46)
Planning Your Shopping Cart	230	(1)
Preparing the Code for Your Shopping Cart	231	(3)
Creating a Simple Storefront	234	(4)
Making a Shopping Cart Class	238	(8)
Shopping Cart Class: get_cart_id Function	241	(1)
Shopping Cart Class: cart_add Function	242	(4)
Shopping Cart Class: empty_cart Function	246	(1)
Building the Shopping Cart Interface: cart.php	246	(15)
Shopping Cart Interface: cart.php Initialization	251	(1)
Shopping Cart Interface: cart.php add case	251	(1)
Shopping Cart Interface: cart.php default case	252	(5)
Shopping Cart Interface: cart.php update case	257	(2)
Shopping Cart Interface: cart.php remove case	259	(1)
Shopping Cart Interface: cart.php empty_confirm case	260	(1)
Shopping Cart Interface: cart.php empty case	261	(1)
Building the Shopping Cart Interface: checkout.php	261	(7)
Providing a Shopping Cart Side Box	268	(2)
Testing Your Shopping Cart System	270	(3)
Creating a Products Catalog Hyperlink	273	(1)
What's Next?	274	(1)
Processing Payments for Your Website	275	(40)
Merchant Account Gateways vs. Third-Party Payment Solutions	276	(5)
What Is a Merchant Account Gateway?	276	(2)
What Is a Third-Party Payment Solution?	278	(1)
What's the Major Difference?	279	(2)
Preparing Your Site for E-Commerce	281	(1)
Creating the Payment Processing Scripts	282	(24)
Processing Payments with VeriSign Payflow Pro	284	(12)
Processing Payments with PayPal	296	(4)
Completing the Order: ordercomplete.php	300	(6)
Testing the Payment Systems	306	(3)
Testing the VeriSign Scripts	306	(3)
Testing PayPal Payment Scripts	309	(1)
Utilizing Curl to Process Payments	309	(3)
Customizing This Project	312	(1)
What's Next?	313	(2)
Tracking Website Statistics	315	(18)
Creating Custom Tracking with PHP and MySQL	316	(14)
Setting a PHP Sessions Counter	316	(2)
Tracking the Number of Users and Visitors Online	318	(7)
Tracking Search Engine Spiders	325	(4)
Creating a Quick Stats Box	329	(1)
Using Web Analyzing Software	330	(2)
Using Webalizer	331	(1)
Using Urchin	331	(1)
Monitoring Your Website with Alexa	332	(1)
What's Next?	332	(1)
Using Third-Party PHP Scripts	333	(18)
Exploring Some Great Third-Party PHP Scripts	334	(16)
Using the phpAdsNew Advertisement System	334	(6)
Using the phpBB Bulletin Board System	340	(5)
Using the PowerPhlogger Statistics Tracking Script	345	(2)
Using the MyNewsGroups News Client	347	(3)
Finding Third-Party PHP Scripts	350	(1)
What's Next?	350	(1)
Closing Statements	351	(6)
It Gets in Your Blood	352	(1)
Getting Support	352	(4)
PHP Support Sites	353	(2)
PHP Manual	355	(1)
Live Support	355	(1)
PHP Frequently Asked Questions (FAQ)	355	(1)
Contributing to PHP	356	(1)
Keep On Truckin'	356	(1)
Appendix A PHP Reference	357	(18)
Popular PHP Functions	358	(9)
Array Functions	358	(2)
Date and Time Functions	360	(2)
File Handling Functions	362	(1)
MySQL Database Functions	363	(2)
String Manipulation Functions	365	(1)
System Configuration Functions	366	(1)
System Execution Functions	366	(1)
Text Formatting Functions	366	(1)
Control Structures	367	(2)
PHP Superglobals	369	(3)
Superglobal: $_Server	369	(2)
Other Superglobals	371	(1)
Operators	372	(3)
Arithmetic Operators	372	(1)
Assignment Operators	372	(1)
Comparison Operators	372	(1)
Error Control Operator	373	(1)
Incrementing Operators	373	(1)
Logical Operators	374	(1)
String Operators	374	(1)
Appendix B MySQL Syntax Reference	375	(20)
Alter	376	(1)
Analyze Table	377	(1)
Backup Table	377	(1)
Begin	378	(1)
Check Table	378	(1)
Commit	378	(1)
Create	378	(3)
Delete	381	(1)
Desc	382	(1)
Describe	382	(1)
Do	382	(1)
Drop	382	(1)
Explain	382	(1)
Flush	383	(1)
Grant	383	(1)
Insert	384	(1)
Join	385	(1)
Kill	385	(1)
Load Data Infile	386	(1)
Lock Tables	387	(1)
Optimize	387	(1)
Rename	387	(1)
Repair Table	387	(1)
Replace	388	(1)
Reset	388	(1)
Restore Table	388	(1)
Revoke	388	(1)
Rollback	388	(1)
Select	389	(2)
Set	391	(2)
Set Transaction	393	(1)
Show	393	(1)
Truncate	393	(1)
Union	393	(1)
Unlock Tables	394	(1)
Update	394	(1)
Use	394	(1)
Index	395