Unit 1: Introducing the Course
* Getting familiar with the course methodology and format
* Understanding the course objectives and prerequisites
* Why PHP and MySQL?
Unit 2: Installing the Software
* Installing Notepad++ (text editor) and WinMerge (file comparison utility)
* Installing Apache
* Installing PHP
* Configuring Apache to work with PHP and testing PHP
* Checking your PHP settings
Unit 3: Writing PHP Scripts
* Using variables
* Commenting scripts
* Using arrays to store multiple values
* Using quotes correctly
* Loops and functions
* Displaying PHP output
Unit 4: Using Includes to Streamline Your Workload
* Including content from other files
* Identifying the current page with PHP
* Creating pages with variable content
* Dealing with missing include files
* Displaying a random image
* Using includes securely
Unit 5: Bringing Forms to Life
* Gathering information from a form with PHP
* Sending email from a form
* Validating user input
* Handling multiple choice form elements
* Redirecting to another page
Unit 6: Uploading Files
* Checking that your server supports uploads
* Creating an upload directory
* Checking filenames
* Refusing large files
* Restricting file types
* Preventing files from being overwritten
Unit 7: Managing Files with PHP
* Checking that PHP has the necessary permissions
* Reading files in a single operation
* Read/write operations
* Replacing content in a file
* Appending content to a file
* Exploring the file system
Unit 8: Generating Thumbnail Images
* PHP's image manipulation functions
* Generating a scaled down version of an image
* Resizing an image automatically on upload
* Giving each thumbnail a unique name
Unit 9 : Simple Login and Multipage Forms
* Session management with PHP
* Creating and destroying session variables
* Using sessions to restrict authentication
* Setting a session time limit
* Passing information through multipage forms
Unit 10: Setting up MySQL and phpMyAdmin
* Installing and configuring MySQL
* Installing and configuring phpMyAdmin
* Launching phpMyAdmin
* Installing the MySQL GUI Tools
Unit 11: Getting Started with the MySQL Database
* Introduction to database management
* Setting up the MySQL database
* Creating MySQL user accounts
* Connecting to MySQL with PHP
* Finding the number of records in a database query
* Displaying the results of a query
Unit 12: Creating a Dynamic Online Gallery
* Planning the image gallery
* Passing information with a query string
* Displaying database results in a multicolumn table
* Selecting subsets of records
* Navigating through long record sets
Unit 13: Managing Content
* Safeguarding your data from SQL injection attacks
* Writing SQL queries
* Setting up a content management system
* Creating the necessary database table
* Inserting, updating, and deleting records
Unit 14: Solutions to Common PHP/MySQL Problems
* Extracting characters, words, paragraphs, and sentences from text
* Manipulating dates
* Working with multiple database tables
* Finding records with no matching foreign key
* Using lookup tables to resolve many-to-many relationships
* Deleting records with dependent foreign keys
Unit 15: Securing Your Website from Intruders
* Encrypting methods
* Using one-way and two-way encryption
* Registering new users
* Updating user details
|
