Learning PHP & MySQL
Step-by-Step Guide to Creating Database-Driven Web Sites
2nd Edition
Published on 25. September 2007
Book
Paperback/Softback
428 pages
978-0-596-51401-3 (ISBN)
Description
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.
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.
More details
Other editions
Previous edition
Michele Davis | Jon Phillips
Learning PHP and MySQL
Book
07/2006
1st Edition
O'Reilly
€24.50
Article exhausted; check for reprint
Person
Michele E. Davis has co-authored and authored over 11 books and has been a career writer since she sold her first poem to CRICKET magazine in second grade. She has an MFA in Writing from Hamline University and is always trying to improve her writing technique. Someday it will be perfect.on A. Phillips is a software engineer who loves Open Source technology. He's been working with web development and databases for over 12 years and is always exploring new technology. Additionally, he co-authored a Dreamweaver for Dummies book that came out July 2006.Queries and code for Learning PHP & MySQL can be found at: http://www.krautgrrl.com/learningphp
Content
Inhaltsverzeichnis
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
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