CSC 341: The Week beginning Mar. 19

• Homework:
  
  Dinosaurs
  
  Eagles
  
  Due: Mar. 26
  
  
• Monday:
  
  Test 2 -- probably next Monday (3/26) and Wednesday (3/28). Will cover material up to but not including databases, things like classes and objects, JSON, XML, CSV, jQuery tabs and accordions, datatables, image creation. CHANGED SEE BELOW
  
  Php MyAdmin (PMA) Intro (presentation)
  CredentialsAndConnect.zip Goes into htdocs. uses StateCapital.csv
  
  Getting the permissions correct and connecting to the database can be the trickiest part. Start getting this straightened out as soon as possible.
  
  
• Wednesday:
  
  Nor'easter Number 4
  
  
• Friday:
  
  Test 2 -- next Wednesday (3/28) and the following Wednesday (4/4). Will cover material up to but not including databases, things like classes and objects, JSON, XML, CSV, jQuery tabs and accordions, datatables, image creation.
  
  MakeTable_StateCapital.zip Makes an HTML table from results of a database select statement (uses FETCH_NUM).
• MakeStateCapitalTable_2.zip Same as above but uses FETCH_ASSOC and a DESCRIBE statement to make table headers.
• MakeStateCapitalTable_3.zip Adds the data-table (jQuery plugin) functionality to the table. (https://www.datatables.net/).
• MakeStateCapitalDropDownSelect.zip Make an HTML drop-down select element from the results of a database select statement.
• MakeStateCapitalRadioButtons.zip Make an HTML set of radio buttons from the results of a database select statement.
• MakeStateCapitalCheckboxes.zip Make an HTML set of checkboxes from the results of a database select statement.
• MakeStateCapitalOrderedList.zip Make an HTML ordered list from the results of a database select statement.
• StateCapitalFetchAllFETCH_OBJ_JSON_Encode.zip fetches the results of a query all at once instead of record-by-record, makes objects out of the records, converts those objects into the corresponding JSON (JavaScript Object Notation)
• StateCapitalFetchAllFETCH_OBJ.zip Walks through the array of objects and makes a table with headers.
• 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