CSC220 Homework 7 2010

The goal of this assignment is to create a database for the project and a form to store KML data in the database. This will be an alternative to having the kml files stored via email.
It is due Friday 11/12 evening, at midnight, as I was a day late putting this assignment together.

Addendum

• --D. Thiebaut 15:50, 7 November 2010 (UTC) Added more information to item 2 of Introduction

Introduction

• The project page is being updated regularly. Fantastic! Keep it up!
• For this assignment I would like you to define, as a group, the format of the html form and the format of the database, and put together some php code that will take information from the form and store it in the database. When I say as a group, I mean that you can perform contributions as an individual, or with homework partner, and you post this contribution to the project page, and in the shared database for all to share. BTW, one good way to figure out when the class page is being updated is to add it as a URL to watch in Google Reader. If you are not using Google Reader yet, do it now! It's a great tool. :-)

• While I would like you to be free to organize the look and feel of your individual forms, you should do so in such a way that the name of the fields in the form should be the same for everybody, and the name of the tables in the database, the name of their fields, and their types, the same as well.
• The database section of the project page is here.
• The form section of the project page is here.

A Form for inputing KML data

• Update the project page section regarding the html form, and define what you feel we need to have for fields. Give the name of each field, and a one line description of what it is for.
• If you want to use additional forms or html pages, describe them in the project page. You may find that somebody has already described a field or a form you do not want to use. Then don't use them!
• Priority is given to the first person to define an item and documents it in the form. We can figure out a mechanism for changing terms, names and organization later, when we're together as a group.
• Refrain from presenting pictures of your form until the assignment is over, to let your creativity not be influenced by a particular look and feel.

Database

• Similarly, create a complete schema for the project database.
• The database is called `220a_project` on our mysql server, and you should all have access to it.
• I recommend we use `220a_project` as a template, and that you use a copy of all its tables in your own database for working on the tables. So to make your php code work with the `220a_project` database instead of the `220a-xx` database, all we'll have to do is to select a different database after we have connected to the server.
• Update the project page with the structure you need.
• Feel free to add tips and code on the project page to help you work with this situation where the format of your database is constantly changing...

Authoring

• Sign your addition using the signature icon on the mediawiki edit page. This is a good way for you to figure out who posted what, in case you have questions about why/how something work, if the description is not clear enough. --D. Thiebaut 16:47, 6 November 2010 (UTC)

Php

• Write some php code that allows you to use your form to store information in the database.
• You are free to use only one self-reloading form, or an html form and a php processing program.
• Call them hw7.htm and hw7.php (or just hw7.php for the self-reloading form).
• Make sure you use an accessinfo.php file for your credentials.

Submission

submit hw7  whatever-file-you-have-created-for-this-assignment