Click here to Skip to main content
14,576,812 members
Rate this:
Please Sign up or sign in to vote.
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
Updated 25-Jun-20 8:08am
Rate this:
Please Sign up or sign in to vote.

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[^]
   
Rate this:
Please Sign up or sign in to vote.

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.
   
Rate this:
Please Sign up or sign in to vote.

Solution 3

Thanks for the answers. Yes I realise it’s server side tech, I am trying to decide which.
   
Comments
Richard MacCutchan 25-Jun-20 16:08pm
   
PHP/MySQL is quite easy, but I think maybe ASP.NET is more robust. It rather depends on how big the website is.

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100