r0ck1t
01-16-2004, 08:46 AM
Hi all,
I am preparing to write an application for a site where teachers/tutors and students of scholls in my region can interact online. Students can recieve help on homework questions they are having trouble with, stuff like that, and the teachers can reply to it.
Due to online privacy regarding youth here in Australia, and the fact that I like to run a strict site, I do not wish to divulge email addresses to anyone (only the administrator, me, can see them - it is that way across the whole site).
I will collect email adressess from teacher and the students will hand theirs over when they sign up. I don't want a form where the student fills out the question and it email the teacher because then the teachers will need to keep the emails they are recieving, possibly from several students on different subjects and/or questions, and that can just be an organisational pain in the ***. I would like to keep the messages in a database and email the appropraite person when a question/reply has been made so they can check it.
I could then display the questions and answers similar to a forum layout so that it is possible to follow the flow of the conversation.
Furthermore this would need to be hidden from other users, would it be wise to make it password protected? The student enters a password and the teachers gets it emailed to them.
I figure it would need 2 tables in the database, one for storing the initial question, the date it was made, the students id, the teacher's id who they are asking, the password and of course the the question id.
The other would have the replys, the question id they are matched with the teacher/ student's id, and a reply id and date.
Any suggestions and opinions on how I could tackle this would be much appreciated!!
Thanks,
-r0ck1t-
I am preparing to write an application for a site where teachers/tutors and students of scholls in my region can interact online. Students can recieve help on homework questions they are having trouble with, stuff like that, and the teachers can reply to it.
Due to online privacy regarding youth here in Australia, and the fact that I like to run a strict site, I do not wish to divulge email addresses to anyone (only the administrator, me, can see them - it is that way across the whole site).
I will collect email adressess from teacher and the students will hand theirs over when they sign up. I don't want a form where the student fills out the question and it email the teacher because then the teachers will need to keep the emails they are recieving, possibly from several students on different subjects and/or questions, and that can just be an organisational pain in the ***. I would like to keep the messages in a database and email the appropraite person when a question/reply has been made so they can check it.
I could then display the questions and answers similar to a forum layout so that it is possible to follow the flow of the conversation.
Furthermore this would need to be hidden from other users, would it be wise to make it password protected? The student enters a password and the teachers gets it emailed to them.
I figure it would need 2 tables in the database, one for storing the initial question, the date it was made, the students id, the teacher's id who they are asking, the password and of course the the question id.
The other would have the replys, the question id they are matched with the teacher/ student's id, and a reply id and date.
Any suggestions and opinions on how I could tackle this would be much appreciated!!
Thanks,
-r0ck1t-