Web+based+databases

A web based database is a normal relational database but It is one which can be accessed by a web page.

Consider an e-commerce site like Amazon. A user searches Amazon for Lego



Amazon runs a query on its database and passes the information about matching products back to the user to be displayed as a web page. The database contains information about the product name, price, rating, category, image etc.

Generally the web request will be handled by a server-side script (such as PHP) with SQL which will then be used to query the database.



Task
(a) What is the SQL in the script above? (b) What does this SQL do? (c) Describe what you think this script actually does.