Setting Up PHP 5 for Windows with Apache or IIS

In this title, Kevin Yank, author of the book Build Your Own Database Driven Website Using PHP & MySQL, explains how to set up a complete web server on Windows. The training covers PHP 5, as well as the Apache web server and IIS. Targeted toward those new to web programming and experienced programmers alike, this tutorial, published by SitePoint, is a thorough guide to setting up PHP 5 and Apache or IIS on Windows.

Table of contents

Setting Up PHP 5 for Windows with Apache or IIS

• Setting Up PHP 5 for Windows with Apache or IIS

Setting Up MySQL 5 for PHP in Windows

In this title, Kevin Yank, author of the book Build Your Own Database Driven Website Using PHP & MySQL, guides users through the process of installing MySQL 5 on Windows. This hands-on tutorial, published by SitePoint, teaches how to develop and test database-driven web applications on Windows. Kevin also covers how to get a fully featured MySQL server running obediently in the background, how to configure MySQL and install it as a service, and how to set a root password.

Table of contents

Setting Up MySQL 5 for PHP in Windows

• Setting Up MySQL 5 for PHP in Windows

Rapidshare:
http://rapidshare.com/files/22847490/Setting.Up.PHP.5.rar

PHP with MySQL Beyond the Basics

In PHP with MySQL Beyond the Basics, expert instructor Kevin Skoglund introduces powerful PHP programming techniques using object-oriented programming (OOP). Both novice and experienced PHP developers will benefit from the efficient, well-organized, reusable, and easy-to-understand code that OOP offers. Kevin shows how OOP techniques can streamline database queries, help manage sessions, and simplify user logins. While building a real-world web application, Kevin also includes practical advice on topics ranging from structuring code to logging user actions. Exercise files accompany the course.

Table of contents

Introduction

• Welcome 1:28 14.4 MB
• Using the exercise files 2:36 2.4 MB
• 1. Installation and Project Setup
• PHP and MySQL installation 0:48 1.3 MB
• Project setup 3:48 3.4 MB

2. Intermediate PHP Techniques

• Using variable variables 5:20 4.7 MB
• Applying more array functions 5:32 5.4 MB
• Building dates and times: Epoch/Unix 8:47 6.9 MB
• Formatting dates and times: Strings and SQL 10:06 9.0 MB
• Setting server and request variables 5:37 5.0 MB
• Establishing global and static variable scope 5:43 5.1 MB
• Making a reference assignment 3:00 2.7 MB
• Using references as function arguments 4:08 3.5 MB
• Using references as function return values 6:13 5.7 MB

3. Introduction to Object-Oriented Programming (OOP)

• Introducing the concept and basics of OOP 6:25 4.2 MB
• Defining classes 4:07 3.8 MB
• Defining class methods 3:30 3.3 MB
• Instantiating a class 6:00 4.9 MB
• Referencing an instance 4:40 3.6 MB
• Defining class properties 7:34 7.6 MB

4. OOP in Practice

• Understanding class inheritance 6:24 5.6 MB
• Setting access modifiers 8:03 7.2 MB
• Using setters and getters 4:02 3.4 MB
• Working with the static modifier 8:20 7.0 MB
• Reviewing the scope resolution operator 2:50 2.5 MB
• Referencing the Parent class 6:49 5.6 MB
• Using constructors and destructors 6:10 4.9 MB
• Cloning objects 3:27 3.1 MB
• Comparing objects 4:47 4.2 MB

5. Photo Gallery Project Setup

• Overview of the project 3:09 2.1 MB
• Creating project and asset directories 6:08 5.5 MB
• Creating a MySQL database 5:31 4.5 MB

6. Foundations of an OOP Project

• Creating the MySQL Database class 6:12 6.8 MB
• Adding queries to the MySQL Database class 3:09 4.1 MB
• Using the database object 6:47 6.5 MB
• How OOP is an improvement 5:16 6.9 MB
• Creating a User class 6:25 7.4 MB
• Instantiating user objects 8:46 10.6 MB
• Revising find methods to instantiate 4:03 4.3 MB
• Autoload: The undeclared object safety net 4:08 4.6 MB
• Creating the Session class 7:11 6.6 MB
• Logging in using the Session class 8:56 12.6 MB
• Initializing files and path constants 6:02 8.1 MB
• Using path content for layout 4:51 5.9 MB
• Late static binding 13:05 15.4 MB

7. Working with Files and Directories

• File system basics 5:28 5.2 MB
• Understanding file permissions 8:48 6.4 MB
• Setting file permissions 5:07 5.3 MB
• PHP permissions 10:53 11.1 MB
• Accessing files 9:45 7.9 MB
• Writing to files 5:19 5.2 MB
• Deleting files 1:51 1.8 MB
• Moving the file pointer 3:58 3.4 MB
• Reading files 6:17 7.2 MB
• Examining file details 6:26 7.2 MB
• Working with directories 6:44 7.5 MB
• Viewing directory content 5:28 6.4 MB
• Creating a log file: Assignment 5:44 4.1 MB
• Creating a log file: Solution 7:56 7.1 MB

8. Uploading Files

• Configuring PHP for file uploads 5:42 4.8 MB
• Sending files as form data 4:22 5.4 MB
• Inspecting uploaded files 3:55 3.4 MB
• Uploading errors 3:59 3.7 MB
• Moving uploaded files 5:54 5.8 MB

9. Completing the User Class

• Remaining user CRUD 2:04 2.1 MB
• Creating users 5:18 5.8 MB
• Updating users 5:58 7.6 MB
• Deleting users 3:39 4.6 MB
• Abstracting the database table name 3:30 7.3 MB
• Abstracting the attributes 5:56 9.1 MB
• Finding the database attributes 3:35 3.8 MB

10. The Photograph Class

• Starting the Photograph class 6:16 8.4 MB
• Coding the Photograph class 5:53 8.4 MB
• Saving photographs 5:22 8.6 MB
• Uploading photographs 6:46 8.1 MB
• Listing photographs 5:55 8.2 MB
• Storing messages in the Session class 6:15 8.7 MB
• Deleting photographs 7:54 11.1 MB
• Displaying photographs in the public area 4:34 6.0 MB

11. The Comment Class

• Creating the Comment class 7:07 9.3 MB
• Building the comment form 6:43 9.6 MB
• Listing comments 6:05 12.2 MB
• Reviewing comments in the staff area 7:28 9.3 MB

12. Pagination

• Understanding the concepts behind pagination 2:51 2.7 MB
• Using LIMIT, OFFSET, and COUNT 2:56 2.2 MB
• Finding the pagination variables 5:51 8.9 MB
• Using the Pagination class 5:02 5.0 MB
• Paginating photographs 2:53 4.3 MB
• Using pagination links 5:26 6.7 MB

13. Sending Emails

• Configuring PHP for email 7:30 5.2 MB
• Sending email with mail() 7:09 5.8 MB
• Using headers 6:50 7.3 MB
• Reviewing SMTP 4:09 2.5 MB
• Using PHPMailer 8:41 12.4 MB
• Building notification for new comments 8:41 11.7 MB

14. Templating and Code Organization

• Using MVC architecture 4:12 5.9 MB
• Simple templating 8:10 10.6 MB
• Using the Smarty PHP templating engine 2:10 3.1 MB
• Building PHP libraries and frameworks 3:14 2.1 MB

Conclusion

• Goodbye 1:40 1.0 MB

Appendix: PHP Installation and Configuration Assistance

• Installing on Mac 10.4 (Tiger) 11:59 13.6 MB
• Installing on Mac 10.5 (Leopard) 11:23 9.8 MB
• Configuring a Mac 13:39 10.0 MB
• The text editor on Mac 3:27 3.6 MB
• phpMyAdmin installation on Mac 2:26 2.2 MB
• Installing on Windows 6:30 6.2 MB
• Configuring on Windows 8:21 7.6 MB
• The text editor on Windows 4:11 4.8 MB
• MySQL basics: phpMyAdmin

PHP with MySQL Essential Training

Web site and database assimilation is a necessity for many of today's businesses, and learning to work with PHP is key to integration success. The objective of PHP with MySQL Essential Training is to teach both new and experienced web developers the comprehensive steps for building dynamic, data-driven, interactive websites. Using PHP 5.2.x and MySQL 5.0.x, instructor Kevin Skoglund demonstrates the entire process of building a content management system. He starts with the basics of the PHP language (variables, arrays, loops, functions, etc.) and works up to building dynamic web pages with a MySQL back end. Kevin also covers blueprinting applications; structuring and interacting with databases; building, validating, and processing forms; and regulating user access with passwords. In addition, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques for improving existing code. The course has been updated for Mac OS 10.5 Leopard. Updated exercise files accompany the tutorials.

Table of contents

Introduction

• Introduction (updated) 2:24 1.8 MB
• Using the exercise files 2:46 4.0 MB

1. PHP Overview

• What is PHP? 2:56 2.0 MB
• History 3:16 2.7 MB
• Why choose PHP? 4:46 7.1 MB
• Installation overview 4:42 3.2 MB

2. Mac Installation

• Installing on Mac 10.4 (Tiger) (updated) 11:59 10.6 MB
• Installing on Mac 10.5 (Leopard) (updated) 11:23 9.2 MB
• Configuring 13:40 17.8 MB
• The text editor 3:50 5.5 MB
• phpMyAdmin 2:34 3.9 MB

3. Windows Installation

• Installing 6:31 7.7 MB
• Configuring 8:22 12.6 MB
• The text editor 4:21 6.3 MB

4. First Steps

• Viewing PHP configuration information 8:09 10.5 MB
• Embedding PHP 6:55 5.8 MB
• ''Hello, World!'' 5:20 4.9 MB
• The operational trail 1:36 1.2 MB
• Inserting comments 3:51 4.0 MB

5. Exploring Data Types

• Variables 9:05 9.0 MB
• Strings 5:43 5.8 MB
• String functions 7:37 7.7 MB
• Numbers pt. 1: Integers 5:14 5.5 MB
• Numbers pt. 2: Floating points 5:07 4.6 MB
• Arrays 12:18 11.4 MB
• Array functions 5:40 6.0 MB
• Booleans and NULL 8:25 9.6 MB
• Type switching and casting 7:35 7.7 MB
• Constants 4:03 3.9 MB

6. Control Structures Pt. 1: Logical Expressions

• If statements 6:10 5.2 MB
• Else and elseif statements 2:34 2.4 MB
• Logical operators 5:58 6.7 MB
• Switch statements 4:18 4.1 MB

7. Control Structures Pt. 2: Loops

• While loops 7:04 6.8 MB
• For loops 4:01 4.1 MB
• Foreach loops 6:39 6.7 MB
• Continue 3:02 3.8 MB
• Break 3:13 3.2 MB
• Understanding array pointers 5:18 6.0 MB

8. User-Defined Functions

• Defining functions 11:28 10.5 MB
• Using functions 6:28 7.9 MB
• Returning values from a function 7:46 8.8 MB
• Setting global variables 6:40 7.4 MB
• Setting default values 6:30 7.7 MB

9. Debugging

• Debugging and troubleshooting 7:09 6.0 MB

10. Building Web Pages

• Links and URLs 3:49 4.7 MB
• Using GET values 5:50 5.9 MB
• Encoding GET values 7:39 7.2 MB
• Encoding for HTML 8:51 10.1 MB
• Building forms 5:28 7.2 MB
• Setting cookies 9:55 11.8 MB
• Establishing sessions 8:49 8.9 MB
• Headers and page redirection 12:19 13.0 MB
• Including and requiring pages 7:22 8.0 MB

11. MySQL Basics

• MySQL introduction 4:46 3.2 MB
• Creating a database in MySQL 6:20 5.5 MB
• Populating a MySQL database 7:12 8.3 MB
• phpMyAdmin 12:16 16.0 MB
• Connecting to MySQL with PHP 6:12 6.5 MB
• Accessing data in MySQL with PHP 6:22 8.0 MB

12. Building a Content Management System

• Blueprinting your application 8:46 7.4 MB
• Building the CMS database 8:17 10.5 MB
• Understanding relational databases 5:26 5.9 MB
• Establishing your work area 4:51 6.0 MB
• Creating your first page 7:05 12.6 MB
• Making page assets reusable 9:01 13.4 MB
• Connecting your site to a database 11:28 15.4 MB
• Building dynamic navigation 9:16 13.5 MB
• Refactoring the navigation 10:25 16.1 MB
• Adding links to your navigation 4:53 6.8 MB
• Determining which page is selected 4:49 6.7 MB
• Displaying HTML based on the selection 4:16 6.1 MB

13. Application CRUD

• Finding a subject in the database 12:14 16.5 MB
• Finding a page in the database 5:24 7.7 MB
• Creating a page for a new subject 11:48 23.9 MB
• Creating a subject entry form 6:53 8.8 MB
• Adding subjects 9:50 11.0 MB
• Escaping values for MySQL 9:26 13.8 MB
• Form validation 7:18 9.6 MB
• Additional form validation 3:18 4.0 MB
• Editing a subject 4:59 8.2 MB
• Using single-page submission 5:41 9.7 MB
• Updating a subject in the database 8:17 12.4 MB
• Sending form results as messages 5:36 9.9 MB
• Deleting a subject 8:39 15.3 MB
• CRUD review and assignment 7:16 8.8 MB
• CRUD assignment results 9:18 17.5 MB

14. Building the Public Area

• The public appearance 3:39 3.6 MB
• Navigation in the public context 6:57 10.9 MB
• Functions in the public context 5:30 9.8 MB
• Creating a default subject behavior 5:19 9.8 MB
• Text encoding and transforming 8:06 8.9 MB

15. Regulating Page Access

• User access overview 2:30 2.0 MB
• Encryption 7:57 11.5 MB
• Creating a login system 5:04 6.9 MB
• Checking authorization 6:00 10.0 MB
• Using sessions to maintain login status 6:42 8.3 MB
• Creating a logout page 8:27 11.6 MB

Conclusion

• Goodbye