Difference between revisions of "PHPEX04"
From mi-linux
Jump to navigationJump to search(25 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
This week you have learnt to retrieve data from an existing database/table. But let's work with YOUR database: | This week you have learnt to retrieve data from an existing database/table. But let's work with YOUR database: | ||
*[[MySQL|Register]] for a Mysql database if you haven't already done so. | *[[MySQL|Register]] for a Mysql database if you haven't already done so. | ||
− | * | + | *Using the [[PhpMyAdmin|phpMyAdmin]] administration page, create a simple table (people, products, films, bands, etc.) For this example I have created a Films table: |
− | |||
− | [ | + | https://mi-linux.wlv.ac.uk/wiki-images/PHPEX04-01.png |
+ | |||
+ | *Still using the [[PhpMyAdmin|phpMyAdmin]] administration page, insert some data in your table, for example: | ||
+ | |||
+ | https://mi-linux.wlv.ac.uk/wiki-images/PHPEX04-02.png | ||
+ | |||
+ | *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 (<nowiki><UL></nowiki>): | ||
+ | **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: | ||
+ | |||
+ | {| border="3" cellpadding=3 cellspacing=3 | ||
+ | |Alien||110 mins | ||
+ | |- | ||
+ | |Aliens||130 mins | ||
+ | |- | ||
+ | |Alien 3||100 mins | ||
+ | |- | ||
+ | |Predator||100 mins | ||
+ | |- | ||
+ | |Seven||100 mins | ||
+ | |- | ||
+ | |Sin City||100 mins | ||
+ | |} | ||
+ | |||
+ | '''Important: you should commit your mini-task code to your Git project.''' | ||
+ | |||
+ | = Ready to move on? = | ||
+ | |||
+ | All done? Let's [[PHP112|move on]]! |
Latest revision as of 11:07, 20 September 2023
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 (<UL>):
- 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: you should commit your mini-task code to your Git project.
Ready to move on?
All done? Let's move on!