CSC 341 (even): The Week beginning Apr. 11

• Homework:
  
  Work through the following tutorials, then send the zipped up files you edited
  PHP OOP Login/Register System: Database Querying (Part 8/23)
  PHP OOP Login/Register System: Database Results (Part 9/23)
  
  
  
  Due: Apr. 19
  
  
• Tuesday:
  
  Test 3 on April 26
  
  PHP makes PDF
  jack.php and jack.zip. Needs fpdf17.zip
  jack_footer.php and jack_footer.zip adds a footer with the page number
  jack_footer_header.php and jack_footer_header.zip adds a header that alternates between author and title on different pages
  jack_footer_header_image.php and jack_footer_header_image.zip adds an image
  MakeStateCapitalTable_PDF.zip takes the results of a query on the state-capital database and displays the results in a table in a landscape-oriented PDF (the comment field is unsatisfying see StateCapital_PDF_table.png)
  MakeStateCapitalTable_PDF_2.zip adds header row to top of each page in the pdf table
  
  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.
  
  Other Resources:
  Programming PHP (Tatroe, MacIntyre & Lerdorf) p. 251-266
  Creating pdf in PHP
  http://www.fpdf.org/en/doc/index.php FPDF documentation
  Jeditable: Edit in place plugin for jQuery
  Editable Tables with jQuery (this youtube video shows how to do something similar without using the Jeditable plugin)
  
  Lab: jEditable Suppliers Make a Jeditable Datatable that displays the supplier of the Northwind database. The SupplierID should be hidden so that the user cannot change that. The remaining fields should be editable and the database should be updated when the user edits the field and hit the Enter key.
  
  Lab: PDF of Northwind Customers Write PHP code that generates a PDF displaying at least five fields of the Customer data in the Northwind database. Add code that places the field names in a table header at the top of each page.
  
  Not done yet.