Using Apache web server, PHP web scripting tool that makes web pages dynamic, AND MariaDB which is very much like MySQL as a database.
Depending on which Linux you use, the location of the web site's pages to be seen vary.
On OpenSuSE Leap 15.1, there is a place in the directory: /srv/www/htdocs/.
Too many ways to do it, but once you figure it out, you're golden.
See your website in a browser with the address http://localhost/web_site_name in some Linux flavors and a different address in other linux flavors which I personally don't know.
There is tons and tons of help with website building in the support forum for your choice of Linux.
There are packages with the 3 applications called Apache, MariaDB, and PHP on Linux called LAMP. Search for LAMP to install when installing your flavor of Linux, or follow the MANY instructions for installing LAMP on your flavor of Linux. BTW, if you don't want to jump into the Linux world, you can download WAMP for Windows which can let you do the same thing on Windows.