Web 101

HTML, PHP, MySQL and Apache Host Website in Your Home with DSL or Cable

If you look around, you will see internet sites everywhere. HTML, PHP, MySQL and Apache are four popular open-source tools that can work together to help you create a dynamic website, such as the website you are visiting now. (I setup this website by myself and you can do the same after you finish this class.)

This class teaches you to install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server. By the end of this class you will understand how these technologies work, and more importantly, how they can work together to create a dynamic web site. Starting from a simple web page by using HTML, you will learn PHP and MySQL database. Eventually you will learn how to create a dynamic Content Management System (CMS) website just like this one with e-commerce capability of selling and receiving payments online. Additionally, the class will teach you how to quickly add many new features to your website and make your website really useful for business.

This class also teaches you how to host your website on your own computer with your own domain name. There is a certain satisfaction in knowing that you have done it yourself and you're saving the $29.95 monthly hosting fees by hosting your own server.

Web Database Programming with HTML, PHP, MySQL and ApacheMicrosoft ASP.Net 4.0

Installing and Configuring MySQL

Installing and Configuring Apache

Installing and Configuring PHP

Installing Microsoft ASP.Net 4.0 and Visual Web Developer 2010

HTML Fundmentals

  • Basic HTML
  • Text style and Lists
  • Tables
  • Forms

PHP Language Structure

  • The Building Blocks of PHP
  • Flow Control Functions in PHP
  • Working with Functions
  • Working with Strings, Dates and Time
  • Working with Forms
  • Working with Cookies and User Sessions
  • Working with Files and Directory
  • Working with Images

PHP and MySQL Database Integration

  • Database Design Process
  • Learning Basic SQL Commands
  • Using Transactions and Stored Procedures in MySQL
  • Interacting with MySQL Using PHP

Basic Projects

  • Managing a Simple Mailing List
  • Creating an Online Address Book
  • Creating a Simple Discussion Forum
  • Creating an Online Storefront
  • Creating a Shopping Cart Mechnism
  • Restricting Access to Your Applications
  • Logging and Monitoring Server Activity