This is a pretty broad question so bear with me here. I'll try to make it as understandable as possible haha. Alright, so lets imagine I have an SQL database on my web server named diary, and I have a table in the database called entries. The table has the following properties:
- Column: entry_id (TEXT)
- Column: entry_name (TEXT)
- Column: entry_content (TEXT)
Now, this is what I want to do. I want to be able to fetch data from the database, and display a list of all of the database entry names so I can read entries from a list. Clicking on the entry will forward me to a new web page that will display the entry content (or the entry text) for the diary entry.
I hope I'm not making this too difficult to understand, but I actually can't find any examples on how to display database data on a web page (perhaps because I'm making this far too complicated, but hey ho)
If anybody can give me some pointers (I'm not asking for complete code snippets here; that's not how one learns) then I'll be greatly thankful. Thank you!