Page 1 of 1

Is this possible?

Posted: Wed Nov 27, 2002 11:14 am
by bobo
Hi everybody.

*There should be a subforum for newbies where I would feel more comfortable posting as a, well, newbie ;) ...*

My department (at a major Canadian University) provides services to a large number of students with disabilities. As part of a php-discussion board (phpBB) I would like our students to be able to do the following:

1. Student logs in to his/her account on the discussion board. (this step is covered by phpBB).

2. They follow a link that opens a php-based form that displays their personal information in fields retrieved from our departmental database (Access 97).
For this step, the php-script that creates the form and interfaces with our database should be able to ONLY display the information for that particular student, based on their phpBB login information (probably through some unique number that corresponds to our database indentifiers, for example, student number or file number).

3. After reviewing/updating their personal information from our departmental database, the student clicks on 'Submit' to submit the changes.

Would this be a likely scenario. If so, do you know of any resources that talk about something remotely similar to what we need here.

I would really appreciate any input.
Thanks.
bobo

Posted: Wed Nov 27, 2002 11:48 am
by volka
phpBB itself can be configured to run with msaccess.
config.php wrote:$dbms='msaccess'
db.php wrote:switch($dbms)
{
...
case 'msaccess':
include($phpbb_root_path . 'db/msaccess.'.$phpEx);
break;
...
}
Take a look at the section 3.iv. Installing on MS Access 2000/XP of INSTALL.html in the manual directory.

Can you describe the data you mentioned at step 2.?

Posted: Wed Nov 27, 2002 12:39 pm
by bobo
Thanks Volka.

In answer to your question: (step 2) The data that I want displayed in a php form (so students can change it) would be retrieved from the table "Student Record" which includes many fields. Of all these, I would like the form to display: student name, phone, email, and address information. Students could then change the information on this form and submit the information to update their file in our departmental database.

Please let me know if you need more info.
bobo