PHP Web Database Programming with MySQL

PHP Web Database Programming with MySQL 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