PHP Web Database Programming with MySQL Course Details

• Database Applications and the Web·
• The PHP Scripting Language·
• Arrays, Strings, and Advanced Data Manipulation in PHP·
• Introduction to Object-Oriented Programming with PHP·
• SQL and MySQL·
• Writing to Web Databases·
• Validation with PHP and JavaScript·
• Sessions·
• Authentication and Security·
• Errors, Debugging, and Deployment·
• Advanced Features of Object-Oriented Programming in PHP·
• Managing Customers·
• Shopping Cart·
• Ordering and Shipping at the Online Shopping Cart·
• Searching and Authentication in the Online Shopping Cart


PHP Web Database Programming with MySQL Course Description

HTML Forms and Table for PHP Programming
HTML Page and Tags, Table structure, Lists
Creating a Form,
Text Boxes, Creating Password Boxes
Creating Larger Text Areas, Creating Radio Buttons
Creating Checkboxes, Creating Menus
About Hidden Fields
Adding Hidden Fields to a Form
Creating the Submit Button
Resetting the Form
Disabling Form Elements
Keeping Elements from Being Changed

Database Applications and the Web
Web Programming Introduction
Three-Tier Architectures
The PHP Scripting Language
PHP and other programming languages
Conditions and Branches
Loops
Functions
Working with Types
User-Defined Functions

Arrays, Strings, and Advanced Data Manipulation in PHP
Arrays
Strings
Regular Expressions
Dates and Times
Integers and Floats

Introduction to Object-Oriented Programming with PHP 5
Classes and Objects
Working with Class Hierarchies
Inheritance

SQL and MySQL
Database Basics
MySQL Command Interpreter
Managing Databases and Tables
Inserting, Updating, and Deleting Data
Querying with SQL SELECT
Join Queries
Exploring with SHOW
Querying
Functions

Querying Web Databases
Querying a MySQL Database Using PHP
Processing User Input
MySQL Function Reference

Writing to Web Databases
Database Inserts, Updates, and Deletes
Issues in Writing Data to Databases

Sessions
Introducing Session Management
PHP Session Management
Using Sessions in Validation
When to Use Sessions

Shopping Cart Online
Functional and System Requirements
Application Overview

Shopping Cart
Design a Shopping Cart
Shopping Cart Implementation
Shopping Cart Home Page
Shopping Cart Search Product
Shopping Cart Basket

Managing Customers
Customer Validation
Customer Form

Ordering and Shipping at the Online Shopping Cart
Credit Card and Shipping Instructions
Finalizing Orders
Email Management

Authentication and Security
HTTP Authentication
HTTP Authentication with PHP
Form-Based Authentication
Protecting Data on the Web

Errors, Debugging, and Deployment
Errors
Common Programming Errors

Shopping Cart Admin Panel
Product Management
Order Management
Order Detail