Category: Working with Databases

Working with Databases

For my second module, I was tasked with creating a webpage that supports the following functionality:

Part1: A button that, when clicked, displays the contents of your database.

Part 2: A form that:

  • Lets you add or remove records from the database.
  • Allows students’ first and last names to be added or deleted from the gradebook.
  • Allows you to enter assignment numbers and assignment scores.

Part 3: A page that allows you to view all the scores for any given student.

Gradebook Database

Welcome to my Gradebook Database! Here you can search by student or assignment, and even sort data by name or score. As an added bonus, if you would like to edit the database, simply click the button below and type in ‘password’ when prompted. This additional layer of security is meant to showcase the functionality that can be added when storing records and other sensitive information in an online format. You can even view all records by clicking the button below.

 

Edit Database   View All Entries

[cdbt-view table=”wp_gradebook” bootstrap_style=”true” enable_repeater=”false” display_list_num=”false” display_search=”true” display_title=”true” enable_sort=”true” display_filter=”false” display_view=”false” draggable=”true” display_index_row=”head-only” footer_interface=”pagination” narrow_operator=”and” sort_order=”created:desc” limit_items=”0″ truncate_strings=”39″ thumbnail_width=”100″ ajax_load=”true”]