Book description
A new edition of this title is available, ISBN-10: 0672329166 ISBN-13: 9780672329166
We've taken the best and made it even better. The third edition of the best-selling PHP and MySQL Web Development has been updated to include material and code on MySQL 5, PHP 5 and on PHPs object model and validation. Through a clear, practical approach, you will learn to develop secure, dynamic websites by integrating and implementing the PHP scripting language and the MySQL database system. Real-world examples and working sample projects will give you a strong foundation on which to start building your own websites, complete with features such as SSL, shopping carts and payment systems. The accompanying CD includes the source code from each example in the book, the entire book in PDF format, and source code and binaries for PHP 5, MySQL 5 and Apache. Readers have called PHP and MySQL Web Development call it the best technical book they've ever read, but don't take their word for it. Find out for yourself!
Table of contents
- Copyright
- Praise for PHP and MySQL Web Development
- About the Authors
- About the Contributors
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
-
I. Using PHP
-
1. PHP Crash Course
- Using PHP
- Creating a Sample Application: Bob's Auto Parts
- Embedding PHP in HTML
- Adding Dynamic Content
- Accessing Form Variables
- Understanding Identifiers
- Creating User-Declared Variables
- Assigning Values to Variables
- Examining Variable Types
- Declaring and Using Constants
- Understanding Variable Scope
- Using Operators
- Using Operators: Working Out the Form Totals
- Understanding Precedence and Associativity: Evaluating Expressions
- Using Variable Functions
- Implementing Control Structures
- Making Decisions with Conditionals
- Repeating Actions Through Iteration
- Breaking Out of a Control Structure or Script
- Employing Alternative Control Structure Syntax
- Using declare
- Next: Saving the Customer's Order
- 2. Storing and Retrieving Data
- 3. Using Arrays
-
4. String Manipulation and Regular Expressions
- Creating a Sample Application: Smart Form Mail
- Formatting Strings
- Joining and Splitting Strings with String Functions
- Comparing Strings
- Matching and Replacing Substrings with String Functions
- Introducing Regular Expressions
- Finding Substrings with Regular Expressions
- Replacing Substrings with Regular Expressions
- Splitting Strings with Regular Expressions
- Comparing String Functions and Regular Expression Functions
- Further Reading
- Next
-
5. Reusing Code and Writing Functions
- Reusing Code
- Using require() and include()
- Using require() for Website Templates
- Using Functions in PHP
- Understanding Why You Should Define Your Own Functions
- Examining Basic Function Structure
- Using Parameters
- Understanding Scope
- Passing by Reference Versus Passing by Value
- Returning from Functions
- Returning Values from Functions
- Implementing Recursion
- Further Reading
- Next
-
6. Object-Oriented PHP
- Understanding Object-Oriented Concepts
- Creating Classes, Attributes, and Operations in PHP
- Instantiating Classes
- Using Class Attributes
- Controlling Access with private and public
- Calling Class Operations
- Implementing Inheritance in PHP
- Designing Classes
- Writing the Code for Your Class
-
Understanding Advanced and New Object-Oriented Functionality in PHP
- Note: PHP4 Versus PHP5
- Using Per-Class Constants
- Implementing Static Methods
- Checking Class Type and Type Hinting
- Cloning Objects
- Using Abstract Classes
- Overloading Methods with __call()
- Using __autoload()
- Implementing Iterators and Iteration
- Converting Your Classes to Strings
- Using the Reflection API
- Next
- 7. Exception Handling
-
1. PHP Crash Course
-
II. Using MySQL
- 8. Designing Your Web Database
-
9. Creating Your Web Database
- Using the MySQL Monitor
- Logging In to MySQL
- Creating Databases and Users
- Setting Up Users and Privileges
- Introducing MySQL's Privilege System
- Setting Up a User for the Web
- Using the Right Database
- Creating Database Tables
- Understanding MySQL Identifiers
- Choosing Column Data Types
- Further Reading
- Next
-
10. Working with Your MySQL Database
- What Is SQL?
- Inserting Data into the Database
- Retrieving Data from the Database
- Updating Records in the Database
- Altering Tables After Creation
- Deleting Records from the Database
- Dropping Tables
- Dropping a Whole Database
- Further Reading
- Next
-
11. Accessing Your MySQL Database from the Web with PHP
- How Web Database Architectures Work
- Querying a Database from the Web
- Checking and Filtering Input Data
- Setting Up a Connection
- Choosing a Database to Use
- Querying the Database
- Retrieving the Query Results
- Disconnecting from the Database
- Putting New Information in the Database
- Using Prepared Statements
- Using Other PHP-Database Interfaces
- Using a Generic Database Interface: PEAR DB
- Further Reading
- Next
- 12. Advanced MySQL Administration
- 13. Advanced MySQL Programming
-
III. E-commerce and Security
-
14. Running an E-commerce Site
- Deciding What You Want to Achieve
- Considering the Types of Commercial Websites
- Understanding Risks and Threats
- Deciding on a Strategy
- Next
-
15. E-commerce Security Issues
- How Important Is Your Information?
- Security Threats
- Usability, Performance, Cost, and Security
- Security Policy Creation
- Authentication Principles
- Authentication
- Encryption Basics
- Private Key Encryption
- Public Key Encryption
- Digital Signatures
- Digital Certificates
- Secure Web Servers
- Auditing and Logging
- Firewalls
- Data Backups
- Physical Security
- Next
- 16. Implementing Authentication with PHP and MySQL
- 17. Implementing Secure Transactions with PHP and MySQL
-
14. Running an E-commerce Site
-
IV. Advanced PHP Techniques
- 18. Interacting with the File System and the Server
- 19. Using Network and Protocol Functions
- 20. Managing the Date and Time
- 21. Generating Images
- 22. Using Session Control in PHP
- 23. Other Useful Features
-
V. Building Practical PHP and MySQL Projects
-
24. Using PHP and MySQL for Large Projects
- Applying Software Engineering to Web Development
- Planning and Running a Web Application Project
- Reusing Code
- Writing Maintainable Code
- Implementing Version Control
- Choosing a Development Environment
- Documenting Your Projects
- Prototyping
- Separating Logic and Content
- Optimizing Code
- Testing
- Further Reading
- Next
- 25. Debugging
- 26. Building User Authentication and Personalization
- 27. Building a Shopping Cart
- 28. Building a Content Management System
- 29. Building a Web-Based Email Service
- 30. Building a Mailing List Manager
- 31. Building Web Forums
- 32. Generating Personalized Documents in Portable Document Format (PDF)
- 33. Connecting to Web Services with XML and SOAP
-
24. Using PHP and MySQL for Large Projects
- VI. Appendixes
Product information
- Title: PHP and MySQL Web Development, Third Edition
- Author(s):
- Release date: September 2004
- Publisher(s): Sams
- ISBN: 9780672326721
You might also like
book
PHP and MySQL Web Development: A Beginner’s Guide
Essential Skills—Made Easy! PHP and MySQL Web Development: A Beginner's Guide takes you from building static …
book
SamsTeachYourself PHP, MySQL & JavaScript: All in One, 6th Edition
In just a short time, you can learn how to use PHP, MySQL, and JavaScript together …
book
PHP and MySQL® Web Development, Fourth Edition
PHP and MySQL Web Development, Fourth Edition The definitive guide to building database-drive Web applications with …
book
Web Database Applications with PHP and MySQL, 2nd Edition
There are many reasons for serving up dynamic content from a web site: to offer an …