Needing To Create A Php Script

[abinidi]

Hi TCHers.

 

Ok. Here is my story.

 

My wife is preparing to gather data for her master's thesis, and we want to gather the data online, and have it stored in a database.

 

It seems that a PHP and MySQL database combination would be perfect.

 

Her program is in second language acquisition (specifically how people learn German). Basically I need to create the following:

 

1. A screen where users log in using their student ID number. The Student ID number is checked against a database that ties the ID to a specific treatment. That is the only time that database is used, because you can't be able to link the results to a particular student.

 

2. A screen where users enter biographica information.

 

3. A practice screen where users click a media button, listening for information.

 

4. A text box where users enter all the information they remember from the media on the previous page. This page must have a submit button, and the information is stored in the database.

 

5. Now, based on the treatment number assigned to that users' User ID, users will get one of 8 treatments.

 

Each treatment consists of 4 screens. On the first and third screen, users have the media button where they click to listen to a passage. On the second and fourth screens, users have the text box where they enter the information they remember from the passage.

 

For treatments 3-8 there is an additional element on the first and third screens. It is a button that users click on when they hear a specific grammatical feature in the listening passage. This button is just a counter; it isn't tied to the passage at all. In the end, we just want to know how many times the user heard the grammatical feature. We dont' care when they heard it.

 

The treatments vary based on which listening passage the users get first, and for treatments 3-8, the grammatical feature they are listening for.

 

I think this is pretty easy. I just have never done anything in PHP or in MySQL.

 

So, I'm wondering first if there is a reference where I can go to figure out this stuff to get started, and then second, I'm wondering if there is anybody who would be willing to help me work out the bugs that are sure to arise as I work on this. Because of the number of pages involved, I'm not sure if it would be best to discuss this in the forums or off-list.

 

Anyway, if you have any ideas for me, please let me know. I've only got two weeks until she has to be gathering her data, so I gotta move fast on this one. (Nothing like trial by fire!)

 

Thanks,

 

Paul

[charle97]

you can probably find something at hotscripts.com. i saw some interesting ones under a search of "survey" with a restriction to php.

[abinidi]

A fantastic suggestion. I hadn't thought of that. Thanks Charles!!! I'll let you know if I found what I'm looking for.