PHPEX04

Main Page >> Web Application Development >> Workbook >> Mini-task 04

This week you have learnt to retrieve data from an existing database/table. But let's work with YOUR database:

• Register for a Mysql database if you haven't already done so.
• Using the phpMyAdmin administration page, create a simple table (people, products, films, bands, etc.) For this example I have created a Films table:

• Still using the phpMyAdmin administration page, insert some data in your table, for example:

• Finally, create a single webpage that connects to your database, retreive the data from the table above, and displays it in an unordered list:
  • Alien
  • Aliens
  • Alien 3
  • Predator
  • Seven
  • Sin City

• Want to try something a little more difficult? Try displaying the film names and duration in a 2-column HTML table!

Alien	110 mins
Aliens	130 mins
Alien 3	100 mins
Predator	100 mins
Seven	100 mins
Sin City	100 mins