Advanced PHP and MySQL

USING PHP

Module 1: PHP Crash Course

• Using PHP
• Embedding PHP in HTML
• Adding Dynamic Content
• Accessing Form Variables

Module 2: Storing and retrieving data

• Opening a file
• Writing a File
• Closing a File
• Reading from a File

Module 3: Using Arrays

• Numerically Indexed Array
• Associative Arrays
• Sorting Arrays
• Recording Arrays

Module 4: String Manipulation and Regular Expressions

• Formatting Strings
• Joining and Splitting Strings with String Functions
• Comparing Strings
• Matching and Replacing Substrings with String Functions

Module 5: Reusing Code and Writing Functions

• Using require() and include()
• Using Functions
• Parameters
• Recursion

Module 6: Object – Oriented PHP

• Object - Oriented Concepts
• Creating Classes, Attributes, Operations in PHP
• Implementing Inheritance in PHP
• Designing Classes

USING MY SQL

Module 7: Designing your web database

• Relational Database Concepts
• How to Design Your Database
• Web Database Architecture

Module 8: Creating your web database

• Creating Databases and Users
• Introduction to MySQL’ Privilege System
• Setting Up a User for the Web
• Creating Database Tables

Module 9: Working with your MySQL database

• Inserting Data in to the Database
• Retrieving Data from the Database
• Updating Records in the Database
• Altering Tables after Creation

Module 10: Accessing your MySQL Database from the web with PHP

• How Web Database Architectures Work
• Checking and Filtering Input Data
• Setting Up a connection
• Querying the Database

Module 11: Advanced MySQL

• Making Your MySQL Database Secure
• Speeding Up Queries with Indexes
• Different Table Types
• Backing Up Your MySQL Database

 

E-COMMERCE AND SECURITY

Module 12: Running a E-commerce site

• Types of Commercial Web Sites
• Risks and Threats
• Deciding on a Strategy

Module 13: E-commerce security issues

• Security Threats
• Creating a Security Policy
• Encryption Basics
• Digital Signatures

Module 14: Implementing Authentication with PHP and MySQL

• Implementing Access Control
• Basic Authentication
• Using Basic Authentication in PHP
• Creating Your Own Customer Authentication

Module 15: Implementing secure transactions with PHP and MySQL

• Providing Secure Transactions
• Using Secure Sockets Layer (SSL)
• Screening User Inputs
• Providing Secure Storage

 

ADVANCED PHP TECHNIQUES

Module 16: Interacting with the file system and the server

• Using other Websites
• Using Network Lookup Functions

Module 18: Managing Date and Time

• Getting the Date and Time from PHP
• Converting Between PHP and MySQL Date Formats
• Date Calculations
• Using the Calendar Functions

Module 19: Generating Images

• Setting up Image Support in PHP
• Image Formats
• Creating Images
• Drawing Figures and Graphing Data

Module 20: Using Session Control in PHP

• Basic Session Functionality
• Implementing Simple Sessions
• Configuring Session Control
• Implementing Authentication with Session Control

Module 21: Other Useful features

• Using Magic Quotes
• Evaluating Strings: evals ()
• Terminating Execution: die and exit
• Serialization

 

BUILDING PRACTICAL PHP AND MySQL PROJECTS

Module 22: Using PHP and MySQL for large projects

• Applying Software Engineering to Web Development
• Planning and Running a Web Application Project
• Reusing Code
• Writing Maintainable Code

Module 23: Debugging

• Programming Errors
• Variable Debugging Aid
• Error Reporting Levels
• Handling Errors Gracefully

Module 24: Building Used Authentication and Personalization

• Implementing the Database
• Implementing the Basic Site
• Implementing User Authentication
• Implementing Bookmark Storage and Retrieval

Module 25: Building a Shopping Cart

• Implementing the Database
• Implementing the Online Catalog
• Implementing the Shopping Cart
• Implementing Payment

Module 26: Building a Content Management System

• Using Metadata
• Formatting the Output
• Image Manipulation
• Extending the Project

Module 27: Building a web-based Email service

• Setting up the Database
• Script Architecture
• Logging In and Out
• Setting up Accounts

Module 28: Building a Mailing list manager

• Setting up the Database
• Script Architecture
• Implementing Login
• Implementing User Functions

Module 29: Building Web Forums

• Viewing the Tree of Articles
• Viewing Individual Articles
• Adding New Articles
• Extensions

Module 30: Generating Personalized Documents in PDF Format

• Evaluating Document Formats
• Solution Components
• Solution Overview
• Problems with Headers

Module 31: Connecting to web services with XML and SOAP

• Understanding XML
• Understanding Web Services
• Solution Components
• Installing the Project Code

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.