PHP with MySQL Essential Training

[vphamquoc]

PHP with MySQL Essential Training | .mov | 860x660 | 10hrs : 45min

<| RS | ISO | 600MB compressed | 854MB decompressed |>

Website 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. 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. Exercise files accompany the tutorials.


*Contain the GUI menu for MAC also. The default GUI menu is for windows that you can see in screenshot.

0. Introduction
- Introduction
- Using the exercise files

1. PHP Overview
- What is PHP?
- History
- Why choose PHP?
- Installation overview

2. Mac Installation
- Installing
- Configuring
- The text editor
- phpMyAdmin

3. Windows Installation
- Installing
- Configuring
- The text editor

4. First Steps
- Viewing PHP configuration information
- Embedding PHP
- ''Hello, World!'
- The operational trail
- Inserting comments

5. Exploring Data Types
- Variables
- Strings
- String functions
- Numbers pt. 1: Integers
- Numbers pt. 2: Floating points
- Arrays
- Array functions
- Booleans and NULL
- Type switching and casting
- Constants

6. Control Structures Pt. 1: Logical Expressions
- If statements

- Else and elseif statements
- Logical operators
- Switch statements

7. Control Structures Pt. 2: Loops
- While loops
- For loops
- Foreach loops
- Continue
- Break
- Understanding array pointers

8. User-Defined Functions
- Defining functions
- Using functions
- Returning values from a function
- Setting global variables
- Setting default values

9. Debugging
- Debugging and troubleshooting

10. Building Web Pages
- Links and URLs
- Using GET values
- Encoding GET values
- Encoding for HTML
- Building forms
- Setting cookies
- Establishing sessions
- Headers and page redirection
- Including and requiring pages

11. MySQL Basics
- MySQL introduction
- Creating a database in MySQL
- Populating a MySQL database
- phpMyAdmin
- Connecting to MySQL with PHP
- Accessing data in MySQL with PHP

12. Building a Content Management System
- Blueprinting your application
- Building the CMS database
- Understanding relational databases
- Establishing your work area
- Creating your first page
- Making page assets reusable
- Connecting your site to a database
- Building dynamic navigation
- Refactoring the navigation
- Adding links to your navigation
- Determining which page is selected
- Displaying HTML based on the selection

13. Application CRUD
- Finding a subject in the database
- Finding a page in the database
- Creating a page for a new subject
- Creating a subject entry form
- Adding subjects
- Escaping values for MySQL
- Form validation
- Additional form validation
- Editing a subject
- Using single-page submission
- Updating a subject in the database
- Sending form results as messages
- Deleting a subject
- CRUD review and assignment
- CRUD assignment results

14. Building the Public Area
- The public appearance
- Navigation in the public context
- Functions in the public context
- Creating a default subject behavior
- Text encoding and transforming

15. Regulating Page Access
- User access overview
- Encryption
- Creating a login system
- Checking authorization
- Using sessions to maintain login status

- Creating a logout page

16. Conclusion
- Goodbye

17. Exercises

System requirements:
Windows:
- 1024x768 or higher screen resolution
- Windows XP or Windows 2000
- Broadband Internet connection (ISDN/DSL/CABLE)
- QuickTime*: QuickTime 6.0 or better plug-in, QuickTime 7.0.4 or better
* To view movies with closed captioning, QuickTime 7.0.4 is required.
- One of the following browsers: Internet Explorer 6 or better, Firefox 1.0 or better
Macintosh:
- 1024x768 or higher screen resolution
- Mac OS X or higher
- Broadband Internet connection (ISDN/DSL/CABLE)
- QuickTime*:
- QuickTime 6.0 to 6.5.2
- QuickTime 7.0.4 or better
* To view movies with closed captioning, QuickTime 7.0.4 is required.
- One of the following browsers: Safari 1.0 or better (part of the Mac OS X system), Firefox 1.0 or better

**Broadband Internet connection (ISDN/DSL/CABLE) and Browsers are needed only if you watch this courses online. For this DVD is no need of any browser or internet connection.

HomeSite

+++++++++++++++++++ < Download links > +++++++++++++++++++
RapidShare (854 MB after decompress)

RapidShare Part1 (100MB)
RapidShare Part2
RapidShare Part3
RapidShare Part4
RapidShare Part5
RapidShare Part6
RapidShare Part7 (1MB)