CIS 627 (Web Database Services Development) Week 2

Getting started with MySQL and a little more PHP

1. Work through the exercise outlined in Introduction to PHPMyAdmin slide show presentation. It uses StateCapital.csv
   
   

   Possible resources:

   • MySQL Database Tutorial - 1 - Introduction to Databases (very introductory)
   • MySQL Database Tutorial - 3 - Creating a Database In this tutorial a table is made from a SQL script customers.sql.
   • Beginner PHP Tutorial - 110 - phpMyAdmin Part 1
   • Beginner PHP Tutorial - 111 - phpMyAdmin Part 2
   • Beginner PHP Tutorial - 112 - phpMyAdmin Part 3
2. Introduction to Querying (Includes exercises at the end)
3. Review handling PHP variables and HTML form: text input and select input
   
   

   Possible resources:

   • PHPBells.zip (just variables, zipped up files)
   • Madlib.zip (text input, zipped up files)
   • Magritte.zip (drop-down select input, zipped up files)
4. Introduce handling some new HTML form input: radio buttons and checkboxes
   
   

   Possible resources:

   • HTML form and PHP handler showing radio button input (zipped up files)
   • Second radio button demo (zipped up files)
   • PHP - Radio Buttons (youtube)
   • HTML form and PHP handler showing a list of checkboxes input (zipped up files)
   • Second checkbox demo (zipped up files)
5. PHP Arrays
   
   

   Possible resources:

   • Programming PHP (Tatroe, MacIntyre & Lerdorf) p. 119
   • Learn PHP: Arrays
   • State_drop_down_select.zip
   • http://php.net/manual/en/language.types.array.php and http://php.net/manual/en/function.sizeof.php
   • State_drop_down_select_2.zip
   • http://php.net/manual/en/control-structures.foreach.php
6. Do the radio button exercise found in Radio Button Exercise (Word Document). Also uses HTMLPage1.htm and AgeGroupSalaryRange.txt