Scoochi2 has already covered the basics.
As an examples, you would have a MySQL back-end database, sitting on a Linux Server with PHP server-side processing script to create the UI.
This setup is commonly called LAMP (Linux, Apache, MySQL, PHP) and is both free and very powerful.