PHP and MySQL Web Development - P6: PHP and MySQL Web Development teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP. | xxvi Contents Searching 578 Editor Screen 581 Extending the Project 582 Next 583 27 Building a Web-Based Email Service 585 The Problem 585 Solution Components 586 Solution Overview 587 Setting Up the Database 588 Script Architecture 590 Logging In and Out 597 Setting Up Accounts 600 Creating a New Account 602 Modifying an Existing Account 604 Deleting an Account 604 Reading Mail 605 Selecting an Account 605 Viewing Mailbox Contents 608 Reading a Mail Message 611 Viewing Message Headers 614 Deleting Mail 615 Sending Mail 616 Sending a New Message 616 Replying to or Forwarding Mail 618 Extending the Project 620 Next 620 28 Building a Mailing List Manager 621 The Problem 621 Solution Components 622 Setting Up a Database of Lists and Subscribers 622 File Upload 622 Sending Mail with Attachments 623 Solution Overview 623 Setting Up the Database 625 Contents xxvii Script Architecture 627 Implementing Login 635 Creating a New Account 636 Logging In 639 Implementing User Functions 642 Viewing Lists 642 Viewing List Information 647 Viewing List Archives 649 Subscribing and Unsubscribing 650 Changing Account Settings 652 Changing Passwords 652 Logging Out 654 Implementing Administrative Functions 655 Creating a New List 655 Uploading a New Newsletter 657 Handling Multiple File Upload 660 Previewing the Newsletter 665 Sending the Message 666 Extending the Project 673 Next 673 29 Building Web Forums 675 The Problem 675 Solution Components 676 Solution Overview 677 Designing the Database 678 Viewing the Tree of Articles 681 Expanding and Collapsing 683 Displaying the Articles 686 Using the treenode Class 687 Viewing Individual Articles 694 Adding New Articles 696 Extensions 703 Using an Existing System 704 Next 704 xxviii Contents 30 Generating Personalized Documents in Portable Document Format PDF 705 The Problem 705 Evaluating Document Formats 706 Paper 706 ASCII 706 HTML 707 Word Processor Formats 707 Rich Text Format 708 PostScript 708 Portable Document Format 709 Solution
