|
Learning PHP and MySQL 2nd Edition
PHP and MySQL are quickly becoming the de facto standard for
rapid development of dynamic, database-driven web sites.
This book is perfect for newcomers to programming as well as
hobbyists who are intimidated by harder-to-follow books.
With concepts explained in plain English, the new edition
starts with the basics of the PHP
language, and explains how
to work with MySQL, the popular open source database. You
then learn how to put the two together to generate dynamic
content.
If you come from a web design or graphics design background
and know your way around HTML, Learning PHP & MySQL is the
book you've been looking for. The content includes:
PHP basics such as strings and arrays, and pattern matching
A detailed discussion of the variances in different PHP
versions
MySQL data fundamentals like tables and statements
Information on SQL data access for language
A new chapter on XHTML
Error handling, security, HTTP authentication, and more
Learning PHP & MySQL explains everything from fundamental
concepts to the nuts and bolts of performing specific tasks.
As part of O'Reilly's bestselling Learning series, the book
is an easy-to-use resource designed specifically for
beginners. It's a launching pad for future learning,
providing you with a solid foundation for more advanced
development.
Preface
1. Dynamic Content and the Web
HTTP and the Internet
PHP and MySQL's Place in Web Development
The Components of a PHP Application
Integrating Many Sources of Information
Requesting Data from a Web Page
2. Installation
Developing Locally
Working Remotely
3. Exploring PHP
PHP and HTML Text
Coding Building Blocks
4. PHP Decision-Making
Expressions
Operator Concepts
Conditionals
Looping
5. Functions
Calling Functions
Defining Functions
Object-Oriented Programming
6. Arrays
Array Fundamentals
7. Working with MySQL
MySQL Database
Managing the Database
Using phpMyAdmin
Database Concepts
Structured Query Language
8. Database Best Practices
Database Design
Backing Up and Restoring Data
Advanced SQL
9. Getting PHP to Talk to MySQL
The Process
Querying the Database with PHP Functions
Using PEAR
10. Working with Forms
Building a Form
Templates
11. Practical PHP
String Functions
Date and Time Functions
File Manipulation
Calling System Calls
12. XHTML
Why XHTML?
XHTML and XML Namespaces
XHTML Versions
Generating XHTML with PHP
13. Modifying MySQL Objects and PHP Data
Changing Database Objects from PHP
Manipulating Table Data
Displaying Results with Embedded Links
Presenting a Form to Add and Process in One File
Updating Data
Deleting Data
Performing a Subquery
14. Cookies, Sessions, and Access Control
Cookies
PHP and HTTP Authentication
Sessions
Using Auth_HTTP to Authenticate
15. Security
Session Security
16. Validation and Error Handling
Validating User Input with JavaScript
Pattern Matching
Redisplaying a Form After PHP Validation Fails
17. Sample Application
Configuration File
Page Framework
Database
Displaying a Postings Summary
Displaying a Posting and Its Comments
Adding and Changing Posts
Adding and Changing Comments
18. Finishing Your Journey
PHP Coding Standards
PEAR
Frameworks
Ajax
Wikis
Finding Help on the Web
Appendix. Solutions to Chapter Questions
Index
|
