CSC 341: The Week beginning Apr. 2

• Homework:
  
  None
  
  
• Monday:
  
  Easter break
  
  
• Wednesday:
  
  Test 2 -- Part B
  
  
• Friday:
  
  StateCapitalInfoFromAbbr.zip Shows a prepared, parametrized query. Uses the GET method to allow the user to supply the parameter value (a state abbreviation). Results displayed as JSON
  
  CombineDropdownAndJSONCreate.zip Replaces text input of previous example with a drop-down select made from querying database. Controls input so user does not enter an improper state abbreviation.
  
  AddSupplier.zip Simple Add a supplier to the Northwind database -- no field validation
  
  jEditable and Update query
  Jeditable_Demo.php Jeditable_Demo.zip
  State_Capital_Jeditable_Data_Table.zip
  State_Capital_Jeditable_Data_Table_2.zip Adds datatable code to make a column invisible.
  State_Capital_Jeditable_Data_Table_3.zip Adds code on the response page to ensure that the field name is legitimate.
  
  Not done yet