Displaying data from the database

On the previous page you added some records to the person entity. Whilst they were added successfully, it would be nice to see what was actually added.

To do this we will need to do make use of:

  • SQL SELECT statements
  • Python lists
  • Python loops
  • HTML tables

Once finished you will have displayed a similar table to the one below in your browser:

Final table displayed in broswer

Creating the display table script

The video below demonstrates how to SELECT data from the database and display it in a HTML table:


Task 9

Using the information above, display the records stored in the person entity.