Difference between revisions of "PHPEX04"
From mi-linux
Jump to navigationJump to search| Line 11: | Line 11: | ||
[[IMAGE:Mysql-table-example02.gif]] | [[IMAGE:Mysql-table-example02.gif]] | ||
| − | *Finally, create a single webpage that connects to your database, retreive the film names from the table above, and displays | + | *Finally, create a single webpage that connects to your database, retreive the film names from the table above, and displays them in an unordered list (<UL>): |
**Alien | **Alien | ||
**Aliens | **Aliens | ||
Revision as of 10:12, 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 film names from the table above, and displays them in an unordered list (
- ):
- Alien
- Aliens
- Alien 3
- Predator
- Seven
- Sin City
Important: make sure that your page's HTML is compliant!
- Want to try something a little more difficult? Try displaying the name and duration of all films in a 2-column HTML table, as follow:
Alien 110 mins Aliens 130 mins Alien 3 100 mins Predator 100 mins Seven 100 mins Sin City 100 mins Important: make sure that your page's HTML is compliant!
