PHP and MySQL Essentials

php course

Introduction

Explore our course on WordPress and PHP, designed to equip you with not just relevant but cutting-edge skills. Despite the continuous evolution of technology, WordPress and PHP remain indispensable, standing the test of time as the most used programming language on websites. Dive into the world of MySQL, the globally acclaimed open-source database, and harness the power of PHP for crafting robust server-side web applications. Gain hands-on experience in building dynamic and database-driven web applications, solidifying your expertise in these in-demand technologies. It’s essential to note that WordPress and PHP are not outdated; they are still very relevant today, making this course a valuable investment in acquiring skills that are perpetually sought after in the tech industry. Elevate your proficiency in WordPress and PHP, ensuring that you stay ahead with skills that stand out in the current digital landscape.

Pre-requisite:

Computer literacy, Programming Basic, Basic English

Duration:

15 hours / Part time

Course Outline

  1. Installation
    • Windows Installation
    • Installing MySQL
    • Installing PHP
    • Linux Installation
    • Mac OS X Installation
    • Post-Installation Setup Tasks
    • If Your Web Host Provides PHP and MySQL
    • Your First PHP Script
  2. Getting Started with MySQL
    • An Introduction to Databases
    • Logging On to MySQL
    • So what’s SQL?
    • Creating a Database
    • Creating a Table
    • Inserting Data into a Table
    • Viewing Stored Data
    • Modifying Stored Data
    • Deleting Stored Data
  3. Getting Started with PHP
    • Introducing PHP
    • Basic Syntax and Commands
    • Variables and Operators
    • Arrays
    • User Interaction and Forms
    • Control Structures
    • Multipurpose Pages
  4. Publishing MySQL Data on the Web
    • A Look Back at First Principles
    • Connecting to MySQL with PHP
    • Sending SQL Queries with PHP
    • Handling SELECT Result Sets
    • Inserting Data into the Database
    • A Challenge
  5. Relational Database Design
    • Giving Credit where Credit is Due
    • Rule of Thumb: Keep Things Separate
    • Dealing with Multiple Tables
    • Simple Data Relationships
    • Many-to-Many Relationships
  6. A Content Management System
    • The Front Page
    • Managing Authors
    • Deleting Authors
    • Adding Authors
    • Editing Authors
    • Magic Quotes
    • Managing Categories
    • Managing Jokes
    • Searching for Jokes
    • Adding Jokes
    • Editing and Deleting Jokes
    • Content Formatting and Submission
  7. Out with the Old
    • Regular Expressions
    • String Replacement with Regular Expressions
    • Boldface and Italic Text
    • Paragraphs
    • Hyperlinks
    • Matching Tags
    • Splitting Text into Pages
    • Putting it all Together
    • Automatic Content Submission
  8. MySQL Administration
    • Backing up MySQL Databases
    • Standard Backups Aren’t Enough
    • Database Backups using mysqldump
    • Incremental Backups using Update Logs
    • MySQL Access Control
    • Using GRANT
    • Using REVOKE
    • Access Control Tips
    • Locked Out?
    • Checking and Repairing MySQL Data Files
  9. Advanced SQL
    • Sorting SELECT Query Results
    • Setting LIMITs
    • LOCKing TABLES
    • Column and Table Name Aliases
    • GROUPing SELECT Results
    • LEFT JOINs
    • Limiting Results with HAVING
  10. Advanced PHP
    • Server-Side Includes with PHP
    • Increasing Security with Includes
    • Semi Dynamic Pages
    • Handling File Uploads
    • Assigning Unique File Names
    • Recording Uploaded Files in the Database
    • Email in PHP
  11. Storing Binary Data in MySQL
    • Binary Column Types
    • Storing Files
    • Viewing Stored Files
    • The Complete Script
    • Advanced Considerations
    • MySQL Packet Size
    • PHP Script Timeout
  12. Cookies and Sessions in PHP
    • Cookies
    • PHP Sessions
    • A Simple Shopping Cart