• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• Z

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.This course has been updated as of November 2008.

Course PHP with MySQL Essential Training Author Kevin Skoglund SKU ISBN Release Date 2007-06-26 Duration 11.01 hrs / 99 tutorials Work files Yes Price $ 49.95 Retail price $ 99.95 Language Tags

1. PHP Overview What is PHP? 02:56 History 03:16 Why choose PHP? 04:46 Installation overview 04:42 2. Mac Installation Installing on Mac 10.4 (Tiger) (updated) 11:59 Installing on Mac 10.5 (Leopard) (updated) 13:40 Configuring 03:50 The text editor 02:34 phpMyAdmin 11:23 3. Windows Installation Installing 06:31 Configuring 08:22 The text editor 04:21 4. First Steps Viewing PHP configuration information 08:09 Embedding PHP 06:55 ''Hello World!'' 05:20 The operational trail 01:36 Inserting comments 03:51 5. Exploring Data Types Variables 09:05 Strings 05:43 String functions 07:37 Numbers pt. 1: Integers 05:14 Numbers pt. 2: Floating points 05:07 Arrays 12:18 Array functions 05:40 Booleans and NULL 08:25 Type switching and casting 07:35 Constants 04:03 6. Control Structures Pt. 1: Logical Expressions If statements 06:10 Else and elseif statements 02:34 Logical operators 05:58 Switch statements 04:18 7. Control Structures Pt. 2: Loops While loops 07:04 For loops 04:01 Foreach loops 06:39 Continue 03:02 Break 03:13 Understanding array pointers 05:18 8. User-Defined Functions Defining functions 11:28 Using functions 06:28 Returning values from a function 07:46 Setting global variables 06:40 Setting default values 06:30 9. Debugging Debugging and troubleshooting 07:09 10. Building Web Pages Links and URLs 03:49

Using GET values 05:50 Encoding GET values 07:39 Encoding for HTML 08:51 Building forms 05:28 Setting cookies 09:55 Establishing sessions 08:49 Headers and page redirection 12:19 Including and requiring pages 07:22 11. MySQL Basics MySQL introduction 04:46 Creating a database in MySQL 06:20 Populating a MySQL database 07:12 phpMyAdmin 12:16 Connecting to MySQL with PHP 06:12 Accessing data in MySQL with PHP 06:22 12. Building a Content Management System Blueprinting your application 08:46 Building the CMS database 08:17 Understanding relational databases 05:26 Establishing your work area 04:51 Creating your first page 07:05 Making page assets reusable 09:01 Connecting your site to a database 11:28 Building dynamic navigation 09:16 Refactoring the navigation 10:25 Adding links to your navigation 04:53 Determining which page is selected 04:49 Displaying HTML based on the selection 04:16 13. Application CRUD Finding a subject in the database 12:14 Finding a page in the database 05:24 Creating a page for a new subject 11:48 Creating a subject entry form 06:53 Adding subjects 09:50 Escaping values for MySQL 09:26 Form validation 07:18 Additional form validation 03:18 Editing a subject 04:59 Using single-page submission 05:41 Updating a subject in the database 08:17 Sending form results as messages 05:36 Deleting a subject 08:39 CRUD review and assignment 07:16 CRUD assignment results 09:18 14. Building the Public Area The public appearance 03:39 Navigation in the public context 06:57 Functions in the public context 05:30 Creating a default subject behavior 05:19 Text encoding and transforming 08:06 15. Regulating Page Access User access overview 02:30 Encryption 07:57 Creating a login system 05:04 Checking authorization 06:00 Using sessions to maintain login status 06:42 Creating a logout page 08:27 Conclusion Goodbye 02:45