CIS 627 (Web Database Services Development) Week 7

Updates, validation and more

1. Explaining First Friday Calculation (based on a student question)
   
   

   Possible resources:

   • FirstFriday.htm
2. Adding header row to top of each page in the pdf table (based on a student question)
   
   

   Possible resources:

   • MakeStateCapitalTable_PDF_2.zip
3. Just Jeditable
   
   

   Possible resources:

   • Jeditable: Edit in place plugin for jQuery
   • Jeditable_Demo.php Jeditable_Demo.zip
4. Combining Jeditable functionality with datatable functionality and a database UPDATE
   
   

   Possible resources:

   • State_Capital_Jeditable_Data_Table.zip
   • Editable Tables with jQuery (this youtube video shows how to do something similar without using the Jeditable plugin)
   • 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.
5. Using jQuery Validation plugin
   
   

   Possible resources:

   • jQuery_Validation_demo.zip Demos using the jQuery Validation plugin to validate a form on the client side and also validates the data ofn the server side. It uses the file and folder structure obtained from downloading and unzipping the jQuery Validation plugin by clicking the download link at http://jqueryvalidation.org/ The index.html file in the demo folder has a more elaborate example that is similar to what is shown in the youtube video linked to below.
   • jQuery Validation Plugin (youtube video)
6. Encrypting passwords
   
   

   Possible resources:

   • PHP with MySQL Tutorial #124 - Encrypting passwords
   • PHP with MySQL Tutorial #125 - Salting passwords
   • PHP with MySQL Tutorial #126 - Adding password encryption to CMS
   • PHP with MySQL Tutorial #127 - New PHP password functions
7. Assignment
   
   
   • Make a Jeditable Datatable that displays the offices of the classicmodels database. The officeCode (id) 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.
   • Update the Week 5 PHP page you made that generates a PDF displaying a table 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.
   • In a Word document, define the following:
     
     1. Hash function
     2. Rainbow table
     3. Salt a password