PHPEX04

From mi-linux
Revision as of 11:00, 18 July 2011 by In9352 (talk | contribs)
Jump to navigationJump to search

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:

Mysql-table-example01.gif

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

Mysql-table-example02.gif

  • 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