PHP & MY SQL

• PHP Basics
• How PHP Works
• The php.ini File
• Basic PHP Syntax
• PHP Tags
• PHP Statements and Whitespace
• Comments
• PHP Functions
• Hello World!
• PHP Tags
• PHP Statements and Whitespace
• Comments
• PHP Functions
• Hello World!
• Variables
• Variable Types
• Variable Names (Identifiers)
• Type Strength
• Hello Variables!
• Variable Scope
• Superglobals
• Constants
• Variable-Testing and Manipulation Functions
• PHP Operators
• Creating Dynamic Pages
• Single Quotes vs. Double Quotes
• Howdy World!
• Flow Control
• Conditional Processing
• If Conditions
• Loops
• while
• do...while
• for
• break and continue
• Arrays
• Enumerated Arrays
• Initializing Arrays
• Appending to an Array
• Reading from Arrays
• Two-dimensional Arrays
• Reading from Two-dimensional Arrays
• PHP and HTML Forms
• HTML Forms
• How HTML Forms Work
• A Sample HTML Form
• Form Variables
• String Manipulation
• Formatting Strings
• Concatenation
• String Manipulation Functions
• Examples of String Functions
• Reusing Code and Writing Functions
• Including Files
• require
• require_once
• User Functions
• Defining and Calling Functions
• Default Values
• Variable Scope
• Form Processing
• Code Organization
• Simple SELECTs
• Some Basics
• Comments
• Whitespace and Semi-colons
• Case Sensitivity
• SELECTing All Columns in All Rows
• SELECTing Specific Columns
• Sorting Records
• Sorting By a Single Column
• Sorting By Multiple Columns
• Sorting By Column Position
• Ascending and Descending Sorts
• The WHERE Clause and Operator Symbols
• Checking for Equality
• Checking for Inequality
• Checking for Greater or Less Than
• Checking for NULL
• WHERE and ORDER BY
• WHERE and ORDER BY
• The WHERE Clause and Operator Words
• The BETWEEN Operator
• The IN Operator
• The LIKE Operator
• The NOT Operator
• Checking Multiple Conditions
• AND
• OR
• Order of Evaluation
• Subqueries, Joins and Unions
• Subqueries
• Joins
• Table Aliases
• Multi-table Joins
• Table Aliases
• Multi-table Joins
• Outer Joins
• Unions
• UNION ALL
• UNION Rules
• Inserting, Updating and Deleting Records
• INSERT
• UPDATE
• DELETE
• Conclusion
• Managing Data
• Querying a Database
• Authentication with PHP and SQL
• A Database- Login Form
• Session Control and Cookies
• Sessions
• Configuring Sessions
• Session Functions
• Cookies
• Conclusion
• Sending Email with PHP
• mail()
• PHPMailer
• File System Management
• Opening a File
• fopen()
• Writing to a File
• File Locking
• Uploading Files via an HTML Form
• Getting File Information
• More File Functions
• Directory Functions
• Getting a Directory Listing