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.
*Create a simple table (people, products, etc.)
+
*Using the [[PhpMyAdmin|phpMyAdmin]] administration page, create a simple table (people, products, films, bands, etc.) For this example I have created a Films table:
*Insert some data in your table using the [[PhpMyAdmin|phpMyAdmin]] administration page
 
  
[img|Mysql-table-example02.gif]
+
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:

PHPEX04-01.png

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

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 (<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!