Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts.
This time, I have decided to try to host my own site using WAMP server and everything seems to be up-n-running nicely. I've used a html/css template which is fairly simple whilst still having some fancy features included and I've pretty much figured out how to edit that to my tastes.
This is purely for my own fun/learning. I'm making a website which lists information about TV series. So my database will be called "Shows". It will have 6 fields (id, genre, title, imageurl, description, httplink).
What I want to do is generate my own 'article template' which will use all 6 of those data to fill some fields i include in the html (if this is even possible??? I am not sure, but I'm quite experienced in coding games/apps in c#/java and I used databases sometimes in those games so I'm hoping the technique is somewhat similar!?)
So what I currently have is a) a self-hosted website, confirmed available to public already b) html index landing page with css customised to my liking (inside the html I have made one 'section' which holds my article template.
So far, my article template looks like this:
<!--Article One -->
<section class="wrapper style1">
<div class="inner">
<header class="align-center">
<h2>DUMMY TITLE FIELD</h2>
<!-- will need to pull these fields including image url from database -->
<img src="http://xyz.image.url/images/123.jpg">
<p>DUMMY DESCRIPTION FIELD, DUMMY DESCRIPTION FIELD, DUMMY DESCRIPTION FIELD, DUMMY DESCRIPTION FIELD, DUMMY DESCRIPTION FIELD, DUMMY DESCRIPTION FIELD, DUMMY DESCRIPTION FIELD</p>
</header>
</div>
</section>
So , I want the user to be able to sort by genre for example, and I want to automatically fill the articles with all the shows from my database with that genre. And of course this includes creating the above html code on the fly but replacing the debug text with actual variables so that it can change it to the database text (I hope that makes some sense!!)
Really, I'd just like to know the name of this process, so I can google a good current guide (unless of course you can easily type it to me which would be even better for me!), also sorry if this has already been asked here. I've been searching about for all types of html/css/apache/php/mySql tutorials and I'm getting a bit confused.
Really hope someone can help. Many thanks