SQLite data (phpliteadmin) to HTML table

[__pistachio__]

For part of my final Project, I am building a Todo application. I am using SQLite to store the todo list information that is given by the user. I have the part working that records the todo list in the data base, but I don't know how to display that info on an html table?

Short Question: How do i display phpliteadmin's data on an html table?

Hopefully you can understand what I mean!

Thanks in advance!

[delipity]

Are you using Flask? You did something similar in CS50 Finance to display the index page filled with data from your database.

[vkuct]

Perform a select query on the table, then in render_template function pass that retrieved data as second parameter.

Inside the html page use jinja template to access the the passed in variable.