PHP and MySQL

Course Description

Ever since it was created in 1995, PHP has been a favorite of developers for server-side web programming. In fact, in some surveys, it now stands as today's most popular web programming language. By most counts, over a million web sites have been written in PHP, including portions of today's largest, most recognizable sites, and often in tandem with MySQL as the database. As a result, there's a continuing demand for web developers who know how to use PHP and MySQL at the professional level. And, with this course, you can become one of them.

Prerequisites

None. Some knowledge of HTML will be helpful, but it's not necessary.

Objectives

  • To learn how to code a PHP application. 
  • To understand relational databases and MySQL
  • To learn how to use PHP with a MySQL database
  • To learn how to use the MVC pattern to organize your code
  • To learn how to test and debug a PHP application
  • To learn how to work with form data
  • To learn how to code control statements
  • To learn how to work with strings and numbers
  • To learn how to work with dates
  • To learn how to create and use arrays
  • To learn how to work with cookies and sessions
  • To learn how to create and use functions
  • To learn how to create and use objects
  • To learn how to use regular expressions, handle exceptions, and validate data
  • To learn how to design a database
  • To learn how to use SQL to create a MySQL database
  • To learn how to use SQL to work with a MySQL database
  • To learn how to create a database-driven web site
  • To learn how to create secure web sites
  • To learn how to send email and access other web sites
  • To learn how to work with files, uploads, and images
  • To learn how to create an eCommerce web site

Software Required

  • All software required for the course is available as a free download via XAMPP. It includes Apache Web Server, PHP, and MySQL
  • Some kind of Text Editor. The author of the textbook suggests Notepad+ or NetBeans, both of which are freely downloadable.

Course Textbook

Murach's PHP and MySQL
Joel Murach and Ray Harris
ISBN: 1-890774-56-1
Buy the book from Amazon
Buy the book from Murach (Free Shipping)

Outline

Week 1: 

Introduction to web development with PHP
How to code a PHP application

Week 2: 
Introduction to relational databases and MySQL
How to use PHP with a MySQL database

Week 3: 
How to use the MVC pattern to organize your code
How to test and debug a PHP application

Week 4: 
How to work with form data
How to code control statements

Week 5: 
How to work with strings and numbers
How to work with dates

Week 6: 
How to create and use arrays
How to work with cookies and sessions

Week 7: 
How to create and use functions
How to create and use objects

Week 8: 
How to use regular expressions, handle exceptions, and validate data
How to design a database

Week 9: 
How to use SQL to create a MySQL database
How to use SQL to work with a MySQL database

Week 10: 
Professional PHP for working with MySQL
A database-driven web site

Week 11: 
How to create secure web sites
How to send email and access other web sites

Week 12: 
How to work with files, uploads, and images
How to work with files, uploads, and images

Interested?

>>>>>>>>>>>>>   Register here. <<<<<<<<<<<<<<