Back to DFS's Workshop Page

DFS's PHP & MySQL Workshop Agenda

This workshop is designed so that participants can work at their own pace with the aid of the workshop leaders and their assistants.

1. Introductions
2. Overview
3. HTML Review
   • Hello World: Click on link and then view the source
   • Short & Simple HTML Tutorial
4. Linux General
   • Booting
   • Login
     
   • Shell:
     • Opening
     • Command-Line Interpreter
     • man progname: on-line program documentation
     • whoami: find out who you are logged in as
     • who: find out who is logged in on your machine
   • File System I
     • which progname : find out which copy of a program is running
     • pwd : Print Working Directory -- find out where you are in the directory tree
     • ls : LiSt; find out the contents of a directory
     • cd : Change Directory
   • File System II
     • mkdir ~/public_html/test_html : MaKe DIRectory
     • cp : CoPy a file
     • rm : ReMove (delete) a file
5. Text Editor: vi [10]
   Creating Hello World in HTML
   • Get into test_html: cd; cd public_html/test_html
   • Getting in & out: vi helloworld.html; :w; :wq
   • Inserting: i or A; ESC to terminate
   • Deleting: x; dd; dw; d$
   • Replacing: r; cw; c$
   • Copying: yy then p
   • Searching: /item
   • Editing a second file: :e
6. PHP Scripting Language
   1. Create a pseudo PHP script & view in Mozilla
      cd ~/public_html; mkdir test_php
      cp test_html/helloworld.html test_php/helloworld.php
   2. Create your first real script and run it from the Command Line
   3. Testing your scripts from the Command Line
      1. Hardset values inside the script
         Problem: The Quadratic Formula I
      2. Command Line arguments passed to the script
         Problem: The Quadratic Formula II
      3. Interactively testing the script
         Problem: The Quadratic Formula III
   4. Edit the file helloworld.php to embed PHP code in an HTML document
   5. Generate a full HTML document using PHP
   6. Use a string variable
   7. Use a pair of functions
   8. Use a pair of functions in a separate file
   9. Simple Numeric Variables
      1. Using hardset values
      2. Read values from a file
      3. Use values passed to the script
         Use GET instead of POST to see values being passed
      4. Establishing default values
      • Problem: The Quadratic Formula IV
      • Problem: Working with a Rectangle
      • Problem: Counting in Four Bases
      • Problem: Addition and Multiplication Charts in Various Bases
   10. Simple String Variables
       • Read unknown number of lines from a file
       • Problem: Madlib Without Using Functions
       • Problem: Madlib Using Functions & Global Variables
       • Problem: Madlib Using Functions & Arguments
   11. Problem: A Simple Concordance
   12. Random Values
       • Generating Random Values
   13. Arrays
       1. Arrays I: Traditional One-Dimensional
          • Problem: Odd Numbers With Unique Digits
          • Problem: Tabulating Dice Rolls
          • Problem: Tabulating Dice Rolls II
          • Problem: Binary Addition
          • Problem: Binary Subtraction
          • Problem: Binary Multiplication
       2. Arrays II: One-Dimensional with String Index
          • Problem: Word Frequency Analysis of a Text
       3. Arrays III: Using Two-Dimensional Arrays
          • Problem: Random Pictures
          • Problem: Binary to Octal Conversion Proof
          • Problem: Binary to Hexadecimal Conversion Proof
       4. Passing an Array
   14. Passing Information Between PHP Scripts
       1. Passing Numeric Values Using a Form
       2. Passing String Values Using a Form
       3. Using Options in a Form
       4. Passing an Array
   15. Recursion
       • Recursive Factorial
       • Problem: Quinary Money Addition
       • Problem: Cash Register
       • Problem: Animals Game
       • Problem: Navigating a Directory Tree
   16. Creating Graphics
       1. Creating a Simple Picture
          • Problem: Calculating and Drawing a Hypotenuse
          • Problem: Working with a Rectangle II
       2. Drawing a Graph
          • Problem: Drawing Parabolas
          • Problem: Drawing Center of Gravity
       3. Problem: Making Thumbnails
   17. Larger Projects
       • Project: Table/Array/File
         1. Problem: Tabulating Dice Rolls
         2. Problem: Displaying Data from a File in a Table
         3. Problem: Appending Data to a File
         4. Problem: Sorting Data from a File
         5. Problem: Editing a Record in a File
         6. Problem: Deleting a Record from a File
       • Project: Simulating Register Arithmetic
         1. Problem: Addition
         2. Problem: Subtraction
         3. Problem: Multiplication
       • Project: Creating a Picture Website
         1. Problem: Navigating a Directory Tree
         2. Problem: Making Thumbnails
         3. Problem: Showing Thumbnails
         4. Problem: Editing File Info
         5. Problem: Creating an index.html File
   18. Reference
       1. Conditionals
          • Single- and Double-Option if Statements
          • Multiple-Option if Statements
       2. Loops
          • The Basics: The do-while & while Loops
          • The Basics: The for Loop
       3. Functions
          • Function Basics
          • An Include File
       4. Files
          1. Read values from a file
          2. Read unknown number of lines from a file
          3. Read information from a file into an array
             • Problem: Quadratic Formula V
             • Problem: Sports Standings
       5. Making an HTML Page Dynamic: An Eight-Step Process
       6. Accessing System Information
       7. Binary and Other Numeration Systems
       8. Debugging
7. Introduction to Data Bases
   1. MySQL Introduction Using phpMyAdmin
   2. Joel Philip's Beginner MySQL Tutorial [local]
      This tutorial is a simple way of learning to use the mysql program.
      This site has been having difficulties lately; so I made local copies.
      1. Create a database in MySQL [local]
      2. Create a table and fill it with data [local]
      3. Using the INSERT and SELECT commands [local]
      4. Dump lots of data in the table [local]
      5. Retrieve the data we put in our table [local]
      6. Delete and modify data in our table [local]
      7. A basic PHP script [local]
   3. Interactive SQL Training
      1. Table Basics
      2. Selecting Data
      3. Creating Tables
      4. Inserting into a Table
      5. Updating Records
      6. Deleting Records
      7. Drop a Table
      8. SQL Interpreter
   4. Problem: Random Pictures II
   5. Advanced Interactive SQL Training
      1. Intro
      2. SELECT Statement
      3. Aggregate Functions
      4. GROUP BY clause
      5. HAVING clause
      6. ORDER BY clause
      7. Combining conditions and Boolean Operators
      8. IN and BETWEEN Conditional Operators
      9. Mathematical Operators
      10. Table Joins
      11. SQL Interpreter
   6. Complete Project, a How-To: Creating, Editing & Displaying Data for a Glossary DB
   7. Problem: Selecting, Editing & Displaying Data from the Outfitters DB