Edit values from multiple rows via a form. Is this possible?

[fmpros]

Hello All,

 

I'm somewhat new to PHP and am trying to figure out the best way to handle a specific process.  Basically, I'm developing an application that will allow a University to create surveys that will then be made available to the students via PHP.  On the backend (which is written in FileMaker Pro) I have setup the following tables:

 

• SurveyDefinition - Used to define the name and general parameters for a given survey
  
• SurveyQuestions - Used to define questions for a given survey.  Each question = 1 row
  
• SurveyStudent - The parent record when a student creates a survey on line
  
• SurveyAnswers - A table used to store the answers to the Surveys - Obviously there will be one row for each question that a survey has defined.
  

 

So, when a student selects a survey to fill out, the system will have to "build" the survey, survey questions and survey answers.  What is the best way to go about providing a UI for users to edit values from multiple rows (records)?  Since each answer represents 1 record or row, I'd like for the students to be able to populate the answers and submit the form from a single page and a single submit button.  Does anyone have an example they could point me to?  I've tried searching the internet for an example but I must be using the wrong terminology (my background is primarily in FileMaker, not PHP).  Any help would be greatly appreciated.  Sorry if I gave too many details! 

 

Best Regards,

John

 

I'm working on project that utilizes a FileMaker database back end and PHP on the front.  The purpose of this project is to provide a University with the ability to define applications that will be served via PHP to the students.  .  In the database, I have tables setup

[.josh]

This tutorial might be of some help.  It's a tutorial about basic database interaction with php.  The example database used is mysql so that probably isn't very helpful, but the example script itself is to list rows and columns from a database table and allow you to edit rows, add them, delete them, etc.. so you can see the form and php concept on that count.

[fmpros]

Thanks CV, I'll give it a read.  Much appreciated.