CSC 341: The Week beginning Oct. 23

• Homework:
  
  Create the quote database described in MySQL Introduction (presentation)
  
  Due: Oct. 30
  
  
• Monday:
  
  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:
  
  Need to schedule Test 2
  
  Go back to array-object sorting that was not gotten to last week.
  
  
  • 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/). (GOT THIS FAR!)
  • 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
  
  
  
• Friday:
  
  Lab: Northwind Customer datatable
  In your XAMPP/MAMP use the SQL script contained in NorthwindMaster.zip to create and populate the tables of the Northwind database. First you must create the database, the script will not create the database. Then with that (empty) database selected, navigate to the SQL tab, paste in the script, and click Go.
  
  Make a PHP page that connects to the Northwind database, selects all of the Customer data, and places that data into a table with the datatable functionality (pages, searching and sorting).