Learning PHP and MySQL / PDF

Learning PHP and MySQL / PDF

Table of Contents:

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 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

 Click here for  Download PDF / FREE

Learning PHP and MySQL / PDF