Basic database project - using SQL, PHP, CSS

Student Project II – Detailed Rubric Grading Criteria 1. PHP Validation: 18% a. Needs Improvement The web application does not perform server -side validation using PHP on all fields (i.e., mandatory and optional) included in the form(s) used to add and/or update records in the database. In addition, validation is limited to verifying if required fields have been filled in or not. There is no validation of the integrity of the data entered by the user (e.g., a Name field accepts numeric characters; an image upload field accepts a .docx file). b. Sufficient The web application performs server -side validation using PHP on all fields (i.e., mandatory and optional) included in the form(s) used to add and/or update records in the database. However, validation is limited to verifying if required fields have been filled in or not. There is no validation of the integrity of the data entered by the user (e.g., a Name field accepts numeric characters; an image upload field accepts a .docx file). c. Accomplished The web ap plication performs server -side validation using PHP on all fields (i.e., mandatory and optional) included in the form(s) used to add and/or update records in the database. Validation both verifies whether required fields have been filled in or not and the integrity of the data entered by the user (e.g., a Name field does not accep t numeric characters; an image upload field does not accept a .docx file). However, error messages regarding data integrity issues are unclear (e.g., “Wrong format for phone number ” – without telling the user what the expected format is). d. Outstanding The web application performs server -side validation using PHP on all fields (i.e., mandatory and optional) included in the form(s) used to add and/or update records in the database. Val idation both verifies whether required fields have been filled in or not and the integrity of the data entered by the user (e.g., a Name field does not accep t numeric characters; an image upload field does not accept a .docx file). Error messages regarding data integrity issues are very clear (e.g., “Phone number should have xxx -xxx -xxxx format ” –telling the user what the expected format is). 2. Store Record : 18% a. Needs Improvement The web application does not store all valid data entered by the user in th e MySQL database. The data entered in some fields is stored while the data entered in some other fields is not. Data that has not been validated is stored in the database. Data is collected from five or less form fields. b. Sufficient The web application stores all valid data entered by the user in the MySQL database. Data that has not been validated is not stored in the database. Data is collected from five form fields. c. Accomplished The web application stores all valid data entered by the user in the MyS QL database. Data that has not been validated is not stored in the database. Data is collected from more than five form fields. The form fields exhibit variety (i.e., at least two different types of input fields). d. Outstanding The web application stores all valid data entered by the user in the MySQL database. Data that has not been validated is not stored in the database. Data is collected from more than five form fields. The form fields exhibit variety (i.e., at least two different types of input fields ). The application demonstrates use of advanced functionality. For example, file upload or AJAX. 3. Retrieve Record(s) : 18% a. Needs Improvement The web application is not able to retrieve all records in the MySQL database.

Changes to the database records (i.e., add, update, or delete records) are not reflected when the user attempts to retrieve records in the database after performing such changes. b. Sufficient The web application is able to retrieve all records in the MySQL database. Changes to the database records (i.e., add, update, or delete records) are reflected when the use r retrieves records in the database after performing such changes . Records retrieved from the database are not displayed in a table format. c. Accomplished The web application is able t o retrieve all records in the MySQL database. Changes to the database records (i.e., add, update, or delete records) are reflected when the user retrieves all records currently in the database. Records retrieved from the database are displayed in a table f ormat. d. Outstanding The web application is able to retrieve all records in the MySQL database. Changes to the database records (i.e., add, update, or delete records) are reflected when the user retrieves all records currently in the database. Records retrie ved from the database are displayed in a table format. The application demonstrates use of advanced functionality. For example, file retrieval or AJAX. 4. Update Record : 18% a. Needs Improvement The web application allows the user to select a record to be update d, but the user is not able to actually update the chosen record. b. Sufficient The web application allows the user to select a record to be updated. Once the user has selected a record to be updated, a form is displayed to the user. After the user has changed the pertinent fields, the record is successfully updated. c. Accomplished The web application allows the user to select a record to be updated. Once the user has selected a record to be updated, a form pre -filled with the data corresponding to the chosen record is displayed to the user. After the user has changed the pertinent fields, the record is successfully updated. d. Outstanding The web application allows the user to select a record to be updated. Once the user has selected a record to be updated, a form pre -filled with the data corresponding to the chosen record is displayed to the user. After the user has changed the pertinent fields, the record is successfully updated. The application demonstrates use of advanced functional ity. For example, file update or AJAX. 5. Delete Record(s) : 18% a. Needs Improvement The web application allows the user to select a record to be deleted, but the user is not able to actually delete the chosen record. b. Sufficient The web application allows the user to select a single record to be deleted at a time . Once the user has selected a single record, that record is successfully deleted. c. Accomplished The web application allows the user to select multiple records to be deleted at a time (i.e., the user has the option to select a single or many records to be deleted). Once the user has selected the pertinent records, those records are successfully deleted. d. Outstanding The web application allows the user to select multiple records to be deleted at a time (i.e ., the user has the option to select a single or many records to be deleted). Once the user has selected the pertinent records, those records are successfully deleted. The application demonstrates use of advanced functionality. For example, file deletion o r AJAX. 6. Semantic Markup: 2.5 % a. Needs Improvement The HTML markup has excessive, unnecessary inclusion of CSS and PHP. In the case of CSS, external style sheets are not used to include CSS as opposed to inline or embedded CSS. In the case of PHP files, PHP script is interwoven with the HTML markup extensively. Include statements in the PHP files to separate markup from script are not used. b. Sufficient The HTML markup has reduced inclusion of CSS and PHP. In the case of CSS, external style sheets are used to include CSS as opposed to inline or embedded CSS. In the case of PHP files, PHP script is interwoven with the HTML markup extensively. Use of include statements in the PHP files to separate markup from script is minimal. c. Accomplished The HTML markup has minimal inclusion of CSS and PHP. In the case of CSS, external style sheets are used to include CSS as opposed to inline or embedded CSS. In the case of PHP files, PHP script is interwoven with the HTML markup minimally. Use of include statements in the PHP files to separate markup from script is extensive. d. Outstanding The HTML markup has minimal inclusion of CSS and PHP. In the case of CSS, external style sheets are used to include CSS as opposed to inline or embedded CSS. In the case of PHP files, PHP script is interwoven with the HTML markup minimally. Use of include statements in the PHP files to separate markup from script is extensive. HTML markup in PHP files is easily distinguishable. 7. Responsive Design: 2.5 % a. Needs Improvement The web application does not have a general design (e.g., top navigation bar, bottom navigation bar, side items) . Some web pages have styling and some do not. Web pages are not responsive to different screen sizes. Some of the functionalities of the web application are not av ailable on devices of different screen sizes. b. Sufficient The entire web application (i.e., all web pages) has a general design (e.g., top navigation bar, bottom navigation bar, side items) . All web pages are responsive to different screen sizes. Some of th e functionalities of the web application are not available on devices of different screen sizes. c. Accomplished The entire web application (i.e., all web pages) has a general design (e.g., top navigation bar, bottom navigation bar, side items) . All web pages are responsive to different screen sizes. All the functionalities of the web application are available on devices of different screen sizes. d. Outstanding The entire web application (i.e., all web pages) has a general design (e.g., top navigation bar, botto m navigation bar, side items) . All web pages are responsive to different screen sizes. All the functionalities of the web application are available on devices of different screen sizes. The HTML markup changes according to the screen size when needed. 8. Navi gation: 5% a. Needs Improvement There are not enough links to allow the user to access all the web pages associated with the various functionalities of the web application. b. Sufficient There are enough links to allow the user to access all the web pages associated with the various functionalities of the web application. c. Accomplished There are enough links to allow the user to easily access all the web pages associated with the various functionalities of the web application. d. Outstanding There are enough links to allow the user to easily access all the web pages associated with the various functionalities of the web application. Excessive, duplicate, and unnecessary links are avoided (i.e., web pages are not crowded with links). Note: Failure to submit all the deliverables of the project as outlined in the Student Project II Guidelines – Submission Instructions will severely affect your grade. Functionalities and characteristics that are not properly documented will not be considered when evaluating your work.