Difference between revisions of "PHPEX04"

From mi-linux
Jump to navigationJump to search
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, films, bands, etc.) For this example I have created a Films table:
+
*Using the [[PhpMyAdmin|phpMyAdmin]] administration page, create a simple table (people, products, films, bands, etc.) For this example I have created a Films table:
  
 
[[IMAGE:Mysql-table-example01.gif]]
 
[[IMAGE:Mysql-table-example01.gif]]
  
*Insert some data in your table using the [[PhpMyAdmin|phpMyAdmin]] administration page, for example:
+
*Still using the [[PhpMyAdmin|phpMyAdmin]] administration page. insert some data in your table, for example:
  
 
[[IMAGE:Mysql-table-example02.gif]]
 
[[IMAGE:Mysql-table-example02.gif]]

Revision as of 09:59, 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:

Mysql-table-example01.gif

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

Mysql-table-example02.gif