The project is about building a script that takes data from a MySQL database and converts it to a .csv file (MS Excel). The database consists of three tables that have been connected to each other. Project have to be done in PHP.
## Deliverables
The project is the following:
I have a database that have three tables:
1. members
2. groups
3. id
1. members include a table of following data; id, firsname, lastname, adress, zip, postal adress, telephone, email and status.
2. groups include a table of following data; id, groupname, status
3. id include a table of following; id, m_id and g_id
Member table is a list of members in the system. Group table is a table the groups in the system. The Id table is used to link members to one or more goups. By this a group can consist of more members and a member can belong to more groups.
This linking is PHP is done with JOIN funktion I think.
What I want you to do is the following:
Make an script, very clear, just basic HTMl coding with forms and necessary tables. No extra markup or CSS -> basic HTML markup.
The script shall to the following:
Fetch the groups that are avaible in the group table and present a list of this in selectbox or a table.
From the selectbox or table chose witch group to fetch information from.
When choosed a group the system shall fetch all members in the member table that are in the group that was selected.
This member details shall now be exported to a .csv file. Only this information shall be exported; firstname, lastname, adress, zip, postaladress.
Then the script shall give the script user a possibility to save the data into a .csv, file that shall be downloadable.
You have to be skilled in MySQL and PHP and interaction between these, like JOIN function.