Sams Teach Yourself PHP and MySQL

Julie Meloni is the technical director for i2i Interactive, a multimedia company located in Campbell, CA. She has been developing Web-based applications since the early days of the Web, and is the author of several books and articles on web-based programming languages and database topics, including Sams Teach Yourself MySQL in 24 Hours and Blogging in a Snap

Book

Part I - Laying the Groundwork
1. Installation QuickStart Guide
2. Installing and Configuring MySQL
3. Installing and Configuring Apache
4. Installing and Configuring PHP

Part II - PHP Language Structure
5. The Building Blocks of PHP
6. Flow Control Functions in PHP
7. Working with Functions
8. Working with Arrays and Objects

Part III - Getting Involved with the Code
9. Working with Strings, Dates and Times
10. Working with Forms
11. Working with Cookies and User Sessions
12. Working with Files and Directories
13. Working with the Server Environment
14. Working with Images IV. PHP and MySQL Integration
15. Understanding the Database Design Process
16. Learning Basic SQL Commands
17. Interacting with MySQL Using PHP

Part V - Basic Projects
18. Managing a Simple Mailing List
19. Creating an Online Address Book
20. Creating a Simple Discussion Forum
21. Creating an Online Storefront
22. Creating a Shopping Cart Mechanism
23. Creating a Simple Calendar
24. Restricting Access to Your Applications
25. Logging and Monitoring Web Server Activity
26. Application Localization

Part VI - Administration and Fine-Tuning
27. Apache Performance Tuning and Virtual Hosting
28. Setting up a Secure Web Server
29. Optimizing and Tuning MySQL
30. Software Upgrades

 

Video

PHP: Foundations - 60 Minutes
Lesson 1: Getting to Know PHP - 10 Minutes
Lesson 2: PHP Applications - 10 Minutes
Lesson 3: Variables - 10 Minutes
Lesson 4: Flow Control - 10 Minutes
Lesson 5: Functions - 10 Minutes
Lesson 6: An Online Catalog - 10 Minutes

PHP: Working With Data - 60 Minutes
Lesson 1: Working with Numbers - 10 Minutes
Lesson 2: Working with Strings - 10 Minutes
Lesson 3: Working with Arrays - 10 Minutes
Lesson 4: Using Regular Expressions - 10 Minutes
Lesson 5: Using Classes - 10 Minutes
Lesson 6: A Customer Database - 10 Minutes

PHP and MySQL: The Web Environment- 60 Minutes
Lesson 1: Processing HTML Forms  - 10 Minutes
Lesson 2: Generating Dynamic HTML- 10 Minutes
Lesson 3: Form Validation - 10 Minutes
Lesson 4: Cookies and Sessions  - 10 Minutes
Lesson 5: User Authentication - 10 Minutes
Lesson 6: An Online Order Form - 10 Minutes

PHP and MySQL : Using Others Services - 60 Minutes
Lesson 1: Filesystem Access - 10 Minutes
Lesson 2: Host Program Execution - 10 Minutes
Lesson 3: Using a MySQL Database - 10 Minutes
Lesson 4: Database Abstraction - 10 Minutes
Lesson 5: Error Handling and Debugging - 10 Minutes
Lesson 6: An Order Processing System - 10 Minute