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, etc.) | + | *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: | ||
[[IMAGE:Mysql-table-example02.gif]] | [[IMAGE:Mysql-table-example02.gif]] | ||
Revision as of 09:57, 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.
- 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 administration page, for example:
