PHP & MySQL
- Module 1:Introduction of Web & PHP
- What is PHP?
- The history of PHP
- Why choose PHP?
- Installation overview
- Embedding PHP code on a page
- Outputting dynamic text
- The operational trail
- Inserting code comments
- Variables
- Strings
- String functions
- Numbers part one: Integers
- Numbers part two: Floating points
- Arrays
- Associative arrays
- Array functions
- Booleans
- NULL and empty
- Type juggling and casting
- Constants
- If statements
- Else and elseif statements
- Logical operators
- Switch statements
- While loops
- For loops
- Foreach loops
- Continue
- Break
- Understanding array pointers
- Defining functions
- Function arguments
- Returning values from a function
- Multiple return values
- Scope and global variables
- Setting default argument values
- Common problems
- Warnings and errors
- Debugging and troubleshooting
- Links and URLs
- Using GET values
- Encoding GET values
- Encoding for HTML
- Including and requiring files
- Modifying headers
- Page redirection
- Output buffering
- Building forms
- Detecting form submissions
- Single-page form processing
- Validating form values
- Problems with validation logic
- Displaying validation errors
- Custom validation functions
- Single-page form with validations
- Working with cookies
- Setting cookie values
- Reading cookie values
- Unsetting cookie values
- Working with sessions
- MySQL introduction
- Creating a database
- Creating a database table
- CRUD in MySQL
- Populating a MySQL database
- Relational database tables
- Populating the relational table
- Database APIs in PHP
- Connecting to MySQL with PHP
- Retrieving data from MySQL
- Working with retrieved data
- Creating records with PHP
- Updating and deleting records with PHP
- SQL injection
- Escaping strings for MySQL
- Introducing prepared statements
- Blueprinting the application
- Building the CMS database
- Establishing your work area
- Creating and styling the first page
- Making page assets reusable
- Connecting the application to the database
- Adding pages to the navigation subjects
- Refactoring the navigation
- Selecting pages from the navigation
- Highlighting the current page
- Moving the navigation to a function
- Finding a subject in the database
- Refactoring the page selection
- Creating a new subject form
- Processing form values and adding subjects
- Passing data in the session
- Validating form values
- Creating an edit subject form
- Using single-page submission
- Deleting a subject
- Cleaning up
- Assignment: Pages CRUD
- Assignment results: Pages CRUD
- The public appearance
- Using a context for conditional code
- Adding a default subject behaviour
- The public content area
- Protecting page visibility
- User authentication overview
- Admin CRUD
- Encrypting passwords
- Salting passwords
- Adding password encryption to CMS
- New PHP password functions
- Creating a login system
- Checking for authorization
- Creating a logout page
- Using variable variables
- Applying more array functions
- Building dates and times: Epoch/Unix
- Formatting dates and times: Strings and SQL
- Setting server and request variables
- Establishing global and static variable scope
- Making a reference assignment
- Using references as function arguments
- Using references as function return values
- Introducing the concept and basics of OOP
- Defining classes
- Defining class methods
- Instantiating a class
- Referencing an instance
- Defining class properties
- Understanding class inheritance
- Setting access modifiers
- Using setters and getters
- Working with the static modifier
- Reviewing the scope resolution operator
- Referencing the Parent class
- Using constructors and destructors
- Cloning objects
- Comparing objects
- File system basics
- Understanding file permissions
- Setting file permissions
- PHP permissions
- Accessing files
- Writing to files
- Deleting files
- Moving the file pointer
- Reading files
- Examining file details
- Working with directories
- Viewing directory content
- Configuring PHP for email
- Sending email with mail()
- Using headers
- Reviewing SMTP
- Using PHPMailer
Module 2: First Steps
Module 3: Exploring Data Types
Module 4: Control Structures: Logical Expressions
Module 5: Control Structures: Loops
Module 6: User-Defined Functions
Module 7: Debugging
Module 8: Building Web Pages with PHP
Module 9: Working with Forms and Form Data
Module 10: Working with Cookies and Sessions
Module 11: MySQL Basics
Module 12: Using PHP to Access MySQL
Module 13: Building a Content Management System (CMS)
Module 14: Using Site Navigation to Choose Content
Module 15: Application CRUD
Module 16: Building the Public Area
Module 17: Regulating Page Access
Module 18: Advanced PHP Techniques
Module 19: Introduction to Object-Oriented Programming (OOP)
Module 20: OOP in Practice
Module 21: Working with Files and Directories
Module 22: Sending Emails