How do I create a web site populated from an SQL database

Question

0.00/5 (No votes)

See more:

I have a web site written in HTML, with pages generated from an SQL database on my PC, which I then upload using FileZilla. This has the advantage that pages load rapidly in a Web browser since the pages are static and no database queries are needed.

I want (as an exercise) to create the same web site but dynamically at runtime. For example, one page contains a list of items. The list of items is generated from the database using an SQL query. The user clicks on an item, and it takes them to a page describing the item with photos. The page is automatically generated from the database using an SQL query.

Two questions:

1) I want to use HTML5, CSS and JavaScript. Which technology do I use for the SQL queries and formatting the results in HTML?

2) At present I use an Sqlite database. I want to transfer to a proper multiuser database such as SqlServer. Is there a good free relational database I can use? My web site is currently hosted on a Linux server, although I can change to a Windows server if that makes any difference.

What I have tried:

I haven't tried anything yet, I need to know the technology to use!

Posted 25-Jun-20 1:50am

Leif Simon Goodwin

Updated 13-Dec-20 23:48pm

Add a Solution

3 solutions

Solution 2

Quote:
1) I want to use HTML5, CSS and JavaScript. Which technology do I use for the SQL queries and formatting the results in HTML?

Basically, you need to generate pages on fly on server side, you need to master a language to make the link between your database and the html pages.
PHP is a common answer to this task
you can get started here: PHP Tutorial[^]
The whole site is a tutorial about web techniques: W3Schools Online Web Tutorials[^]

Posted 25-Jun-20 2:27am

Patrice T

Solution 1

You can't unfortunately. You'll need to learn some kind of server-side technology that runs on the server which can access a database and return html to the client. If you want to move to Microsoft and SQL Server I'd suggest looking into asp.net and MVC.

Posted 25-Jun-20 2:08am

F-ES Sitecore

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Leif Simon Goodwin · Accepted Answer · 2020-12-13T23:48:00

In case anyone has the same question, I ended up using Asp.Net Core, and this is what I recommend for anyone like me with WPF experience. The markup is HTML with embedded C# code that can read and write to databases and generate mark up quite easily. And it is type checked. It's powerful and easy to learn.