PHP and SQL Databases

  1. Getting Started

    1. Documentation
    2. Introduction
    3. Installation and Configuration
    4. Hello World
      Exercise I

  2. PHP Language

    1. Basics: Tags, Comments, etc
    2. print and echo
      Exercise II
    3. Variables and Data Types
    4. Operators
      Exercise III
    5. Operations on Strings
    6. Arrays and Associative Arrays
      Exercise IV
    7. Control Statements and Loops
      Exercise V
    8. Functions
      Exercise VI
    9. File IO and Filesystem functions
    10. Operation System (OS) Calls
      Exercise VII
    11. File Including: include and require
      Exercise VIII Solution
    12. Date and Time
      Exercise IX
    13. Objects
      Exercise X
    14. HTML Forms and Feedback
      Exercise XI
    15. Uploading Files
      Exercise XII

      Project: Hash Table

  3. Advanced PHP Topics

    1. Miscellaneous Functions
    2. Controling the Output Buffer
    3. Email
    4. Images and Graphics
    5. Movies
    6. Cookies and Session Management
    7. Redirection
    8. Security and Save Mode
    9. Performance and Profiling
      Project: Tron

  4. PHP Interface to SQL Databases

    1. Installation Issues
    2. Connect to DB
      Exercise I
    3. Executing SQL Statements: query
      And Fetching Results
      Exercise II
    4. Getting Info about Query Results
    5. Handling SQL Errors
      Exercise III
    6. Copy: PHP-Array <-> DB-Table
      Exercise IV
    7. Working with Large Objects (Blobs)
    8. Persistent Connections
    9. Database Security
    10. PEAR and DBs
    11. DB Functions: Overview
    12. Example: User Log IN
      Exercise V

Literature

Online Tutorials and Manuals