Technical term for application that creates database websites?

iudtuvm

You know those online database websites such as those that allow people to create food and fitness logs? On these logs you can use a drop down menu to select the food item and automatically add it to your daily intake. Or you can enter a new food item into the database if it's not already there etc.

Clear as mud yet? Good

What's the technical term for the programming languages/applications/design process/? used to create them

EDIT: PS I'm assuming they're called database websites...

jakswan

Cor that sounds like a simple question until I started typing:)

Normally the database is separate from the website. So you have a website that sends commands to the database for the data.

In the case of a drop down you'd send a command to the database asking for records in the database normally via an SQL language.

Can't post links but check out webmonkey they do some great tutorials.

You would normally use more complex coding language that HTML I either PHP or ASP.

I'm not a coder though only learnt the theory stuff.

crampo_2

Server Side Programming: Everything that takes place on the server. So this would be where the database tasks are taken place. Usually The database would be programmed in SQL either Microsoft SQLSever or MYSQL. The Front end would be programmed in ASP/ASP.net or PHP. I use IIS7 (built into the latest windows & windows server Os's), Adobe Dreamweaver, Microsoft SQL Server 2008 and ASP Programming.

ahillsy

No need to call them "database websites" - saves you one word each time A general term would be "dynamic" (where the content of the site can be dynamic, pulled in from a source like a database) as opposed to a "static" site (e.g. pure HTML site - to get more content, you edit the HTML). If talking to someone about a site, you could say "it's database driven" or "it's backed by a database.

The common programming languages used to create database-driven sites include: ASP, ASP.NET and PHP - which are server-side programming languages. i.e. the code you write is executed on the server where the site is hosted and the result is content/HTML being sent down to the client browser, so that part of the code doesn't run on the visitor's machine. You can then have client-side code (e.g. javascript) that does run in the visitors browser on their machine - this helps give a richer user experience (e.g. retrieve data from the server without refreshing the whole page).

A database is a separate entity to the website itself. The website is merely a user interface to provide interaction with that database. So a database can be used to provide data to a website, to a mobile app, to an application you install on your computer etc etc. Common databases include: MySQL (cheap as chips, commonly paired with PHP / Linux hosting), Sql Server (not cheap, Microsoft, Windows hosting, common paired with ASP.NET/ASP), Access (*shiver*, wouldn't consider this for a website tbh even if only for a small site), Oracle (££££££££'s)....