PHP/MySQL Teaching Session

• Lecture notes: Powerpoint slides in pdf
   
• links referred to in lecture:
  
  • live/helloworld.php
     
  • live/phpinfo.php?teacher=ben
     
  • live/gettest.php?name=ben+wheeler&email_addr=brw12@columbia.edu&age=22
     
  • live/viewprofs.php
    Note: Because "profs" and "depts" tables have already been created, results for viewprofs.php will not match what they should be at that point in the lecture slides.  
  • source (open with browser and View Source)
     
  • live/viewprofs2.php  
  • source (open with browser and View Source)
     
  • live/viewprofs3.php  
  • source (open with browser and View Source)
     
• PHP/MySQL Flash interaction
  • live/reminder.php
    New "working" version! If it doesn't work at first, try reloading.  
  • source (open with browser and View Source) 
  • http://www.mekhaye.net/teach/phpmysql/reminder.html
    Simplified, non-database-interactive version so that you can see the Javascript more clearly (open with browser and View Source)
     
  • .fla source file used for flash movie
    Download and open in Flash 4 or Flash 5 to view structure and syntax  
  • .swf flash movie file (after publishing)
    Don't know why you'd want this, but here it is
     
• Online resources:
  
  • http://www.php.net
    Includes tutorial, full manual, function list/search, FAQ, installation guidelines
  • http://www.mysql.com
    Home for MySQL, including installation guide
  • http://hotwired.lycos.com/webmonkey/programming/php/
    Webmonkey page on PHP -- highly reccomended
  • http://hotwired.lycos.com/webmonkey/backend/databases/
    Webmonkey page on databases -- highly reccomended
  • http://www.w3schools.com/sql/sql_intro.asp
    Very clear introduction to SQL
  • http://www.sqlcourse.com/index.html
    Course in SQL with live practice database
  • http://www.devshed.com
    Good for both PHP and SQL.
  • http://www.hotscripts.com
    Source for pre-written code to perform many functions