Php Video Tutorials - Database Website From Scratch

How is the course structured?
It’s 13 lessons 6+ hours with all source code provided! I saved the code at the end of every lesson so you can start from any lesson you like. Starting from the beginning and coding every line along with me is the best way though! you’ll learn more and have a better understanding of how everything works.

Lesson 01 - Introduction
We talk about what we are going to build.

Lesson 02 - Setting up the database
Create our database and set up the tables we are going to need. We also talk about the relationships between our tables.

Lesson 03 - PHP to MySql
Now we dive head first into connecting to MySQL from PHP. We also set up all the SQL for our Application (Creating, Selecting, Updating, Deleting)

Lesson 04 - Code to functions
Then we review our code and turn it into nice functions we can reuse over and over again!

Lesson 05 - MVC
We talk about MVC application layout. Look at some diagrams and think about how we can achieve this application layout.

Lesson 06 - Setting up the application
We begin to layout out our application and framework.

Lesson 07 - Routing System
Now we have a foundation.. it’s time to add friendly URLs and using our knowledge of regular expressions we set up a cool little routing system! Go PHP go!!

Lesson 08 - Routing to functions
We then review our code again and re-factor it into functions. It’s all about keeping your code in the right spots and keeping everything tidy.

Lesson 09 - Layouts and Forms
Our Application needs a layout so using some simple logic we set up a cool Templating system! Then we move onto setting up all our HTML forms.

Lesson 10 - Forms to Database
Now we have our forms we need to make them talk to PHP and MySQL so that’s what we do!

Lesson 11 - Part 1 WYSIWYG and Validation
We add rich editing to our forms and then we setup some simple validation and functions! did someone say CMS!! yeah baby!

Lesson 11 - Part 2 Magic Quotes and Pagination
We look at magic quotes and add previous and next links to our application.

Lesson 12 - User Authentication
It’s time to make our CMS secure so now we add Password Protection!

Lesson 13 - Styling
Our Application is almost complete just need to make it shiny. I go away for an hour and mock up a design we come back and add it to the app! We are done! I shed a tear or two and crack it at Windows Vista.

Download Here:

http://rapidshare.com/files/93290587/php_db_lesson01_introduction.rar
http://rapidshare.com/files/93264255/php_db_lesson02_setting_up_database.rar
http://rapidshare.com/files/93265690/php_db_lesson04_code_to_functions.rar
http://rapidshare.com/files/93265817/php_db_lesson05_MVC.rar
http://rapidshare.com/files/93266602/php_db_lesson06_setting_up_application.rar
http://rapidshare.com/files/93268705/php_db_lesson07_routing_system.rar
http://rapidshare.com/files/93270678/php_db_lesson08_routing_to_functions.rar
http://rapidshare.com/files/93272800/php_db_lesson09_layouts_and_forms.rar
http://rapidshare.com/files/93275583/php_db_lesson10_form_to_database.rar
http://rapidshare.com/files/93278539/php_db_lesson11-WYSIWG_and_validation_magic_quotes_pagination.part1.rar
http://rapidshare.com/files/93281716/php_db_lesson11-WYSIWG_and_validation_magic_quotes_pagination.part2.rar
http://rapidshare.com/files/93282401/php_db_lesson11-WYSIWG_and_validation_magic_quotes_pagination.part3.rar
http://rapidshare.com/files/93285075/php_db_lesson12_authentication.rar
http://rapidshare.com/files/93287642/php_db_lesson13_styling.part1.rar
http://rapidshare.com/files/93289920/php_db_lesson13_styling.part2.rar
http://rapidshare.com/files/93289977/php_db_README_SOURCE_FILES_DESIGN.rar