Web Site Builder

PHP & MySQL

Course overview

Course Summary

Duration: 10 weeks, 70 hours

Project will be written by the end of the course.


Why should you Learn PHP and MySQL?

PHP & MySQL Knowledge is a plus for securing a high-paying job.

Employer will be convinced that your knowledge is beyond the basic Web design technologies. PHP and MySQL is for seasoned Web Designers and Developers who wish to create dynamic and interactive web sites with the e-commerce capabilities.


Benefits of the PHP & MySQL for Professionals

  • Demonstrates a working knowledge of Dynamic Web Site Design and Publishing 
  • Confirms commitment to profession 
  • Offers a career differentiator, with enhanced credibility and marketability 
  • Takes you beyond basic user's knowledge to the IT Pros who know how to create web sites 


What are the Prerequisites?

Individuals should have a basic knowledge of programming logic, in addition be able to use an editor to create and save web pages as part of this course. Knowledge of HTML is also required.


Audience:

This course is for anyone who would like to create dynamic Web sites using PHP and MySQL.


Course Description:

This course teaches learners to create dynamic Web sites. Learners will be able to apply their knowledge to the creation of dynamic Web applications such as content management, user registration, and e-commerce.

 

Course Overview


PHP and MySQL: 1 Installing Required Software

Description

After taking this course, the learner will be able to download, install, configure, and test all the software required to create dynamic Web sites using PHP and MySQL.

Objectives

  • To install and configure MySQL
  • To install and configure Apache with PHP
  • To create MySQL users and grant privileges
  • To test PHP and MySQL installations
  • To configure PHP


PHP and MySQL: 2 PHP Basics

Description

After taking this section, the learner will be able to describe the PHP scripting language, and create basic PHP scripts using proper PHP syntax.

Objectives

  • Identify basic PHP syntax
  • Create basic PHP scripts
  • Send data to the Web browser
  • Apply variables, strings, and constants to a PHP a script


PHP and MySQL: 3 Programming with PHP

Description

After taking this section, the learner will be able to create elaborate scripts, write HTML forms, and program PHP to handle the form data.

Objectives

  • Handle HTML forms using PHP scripts
  • Validate form data
  • Manage arrays using various types of loops
  • Work with magic quotes


PHP and MySQL: 4 Creating Dynamic Web Sites

Description

This section provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that are responsive to users and can alter content based on differing situations.

Objectives

  • Create PHP scripts using multiple files
  • Display and handle HTML forms within a single PHP script
  • Create and call functions
  • Create functions that take arguments and return values
  • Set and alter variable scope
  • Send email from a PHP script


PHP and MySQL: 5 SQL and MySQL

Description

After taking this section, the learner will be able to create databases and tables, and sort and retrieve data using SQL and MySQL.

Objectives

  • Choose column types and other column properties
  • Create databases and tables
  • Insert records, select, update and delete data
  • Use conditionals and functions


PHP and MySQL: 6 Advanced SQL and MySQL

Description

After taking this section, the learner will be able to use the principles of database design, including normalization and use of forms. They will also be able to use MySQL to create relational databases, and perform searches on those databases.

Objectives

  • Normalize a database into First, Second and Third Normal Forms
  • Create and populate a database in MySQL
  • Search a database using joins, groupings, and FULLTEXT searches
  • Change the search engine type of a table
  • Create indexes to improve the ability to search a database


PHP and MySQL: 7 Error Handling and Debugging

Description

This section provides the learner with the steps and tools necessary to identify and correct errors that can occur when running PHP and MySQL applications.

Objectives

  • Identify error types
  • View, log, and debug errors
  • Adjust PHP's error reporting
  • Create custom error handlers


PHP and MySQL: 8 Using PHP with MySQL

Description

This section provides the learner with step-by-step instructions for using PHP to create dynamic Web sites that allow for database interactions such as the storing, gathering, and updating of information.

Objectives

  • Describe how arguments and PHP functions relate to the database
  • Differentiate between simple and complex functions depending on execution results
  • Understand the importance of associative and indexed arrays.
  • Modify specific scripts to allow for secure data transmission
  • Update database records using PHP scripts


PHP and MySQL: 9 Developing Web Applications

Description

This section provides the learner with information about a number of independent topics that are present in more sophisticated Web applications.

Objectives

  • Adjust behavior for server settings
  • Pass variables and values to a script
  • Edit existing records
  • Paginate query results
  • Make sortable displays
  • Use HTTP headers


PHP and MySQL:10 Cookies and Sessions

Description

This section provides the learner with information about using cookies and sessions with PHP to overcome the statelessness of the Web.

Objectives

  • Use cookies
  • Use sessions
  • Improve session security
  • Manage the relationship between cookies and sessions


PHP and MySQL:11 Web Application Security

Description

In this section, the learner will become familiar with methods for increasing the security of their web applications using PHP and MySQL. These techniques include methods of form validation, the ability to define patterns and then matching or replacing those patterns, and data encryption.

Objectives

  • Prevent forms from being submitted multiple times
  • Validate form data
  • Define patterns and both match and replace them
  • Manage database encryption and decryption techniques


PHP and MySQL:12 Extended Topics

Description

This section covers extended PHP topics that are worth considering in your development work, but not related to every Web application.

Objectives

  • Upload a file in PHP
  • Develop JavaScript using PHP
  • Utilize output buffering
  • Identify Improved MySQL Extension functions
  • Describe the purpose of PEAR


PHP and MySQL:13 Content Management Example

Description

After taking this section, the learner will become familiar with the foundational information required to build a sample content management site through PHP interactions using a database.

Objectives

  • Create the advanced PHP scripts needed for a content management site
  • Update and add information with a database
  • Download files through PHP scripts and database interactions
  • Manage files through PHP scripts and database interactions


PHP and MySQL:14 User Registration Example

Description

This section provides an overview of the user registration system.

Objectives

  • Handle user registration
  • Activate accounts
  • Create login and logout scripts
  • Apply password management


PHP and MySQL:15 E-Commerce Example

Description

After taking this section, the learner will have the information and sample needed to create an e-commerce site using PHP and MySQL, including creating the database, creating the public and administrative pages, and managing the shopping cart.

Objectives

  • Create a database for an e-commerce site
  • Create the administrative pages for an e-commerce site
  • Create pages for a customer to browse the inventory and place orders from an e-commerce site
  • Create and manage an online shopping cart for your e-commerce site