PHP with MySQL Essential Training (kurs PHP i MySQL/ video/ angielski)



Kurs "PHP with MySQL Essential Training" ma za zadanie nauczyć nowych i zaawansowanych technik do tworzenia dynamicznych i interaktywnych stron internetowych. Używając PHP 5.2.x i MySQL 5.0.x, Kevin Skoglund demonstruje cały proces budowania strony. Zaczyna od podstaw języka PHP (zmienne, pętle, funkcje itp) i kończy na bazie danych MySQL Kevin przedstawia także interakcję z bazą, tworzenie formularzy oraz tworzenie logowania itp..

Język: Angielski
Format: MOV
Czas trwania: 11 godzin
Rozmiar: 850mb + 5% danych naprawczych






Spis zagadnień:

Introduction
Introduction (updated)
Using the exercise files

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

2. Mac Installation
Installing on Mac 10.4 (Tiger) (updated)
Installing on Mac 10.5 (Leopard) (updated)
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

Conclusion
Goodbye


Party - 200mb

Kod:
http://rapidshare.com/files/286924565/PWMET.part1.rar
http://rapidshare.com/files/286942412/PWMET.part2.rar
http://rapidshare.com/files/286960028/PWMET.part3.rar
http://rapidshare.com/files/286978512/PWMET.part4.rar
http://rapidshare.com/files/286987789/PWMET.part5.rar