Difference between revisions of "PHPEX04"
From mi-linux
Jump to navigationJump to search| Line 22: | Line 22: | ||
{| border="3" cellpadding=3 cellspacing=3 | {| border="3" cellpadding=3 cellspacing=3 | ||
| − | |Alien||110 | + | |Alien||110 mins |
|- | |- | ||
| − | |Aliens||130 | + | |Aliens||130 mins |
| + | |- | ||
| + | |Alien 3||100 mins | ||
| + | |- | ||
| + | |Predator||100 mins | ||
| + | |- | ||
| + | |Seven||100 mins | ||
| + | |- | ||
| + | |Sin City||100 mins | ||
| + | |- | ||
| + | |||
|} | |} | ||
Revision as of 10:09, 18 July 2011
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 |
