First Design Post

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
abionifade
Forum Commoner
Posts: 34
Joined: Thu Apr 18, 2002 5:32 pm

First Design Post

Post by abionifade »

okay, here goes:

I got a a database which consists of a student table and an options table. Theory is that a student should be able to choose optional modules ( which are predefined in the options table ) during their academic year and thus have these modules assigned to them.

I have created another table called student options which will consist of the student name/ID along with the many options assigned to them (manually assigned entries via the web interface).

Im just racking my brains as to how to create a decent (intuitive), hassle free interface which will allow me to assign students these modules. My brain is dead from programming all day today and im wondering if you guys have any suggestions as to how i can lay this one out.


-Abi :roll:
User avatar
Phirus
Forum Commoner
Posts: 37
Joined: Thu Apr 18, 2002 4:10 pm
Contact:

Post by Phirus »

Can you give us more info...

May be able to put something together 4 ya

PhIrUs
User avatar
Phirus
Forum Commoner
Posts: 37
Joined: Thu Apr 18, 2002 4:10 pm
Contact:

Post by Phirus »

If you are worried about storing all of the options, what you could do Is explode the options into a string and store it in one field.

PhIrUs
User avatar
Ruiser
Forum Newbie
Posts: 8
Joined: Wed Apr 24, 2002 11:04 pm
Contact:

Post by Ruiser »

I've done something similar to this before.

I have a list of users who need access to certain items. I can add new items to an items table and users to a user table. I also have a UsersItems table.

On the first page, I have a list of all the users. Each user is a link to the next page that passes along the user id. then on that page I have a list of all the items along with checkboxes next to each one. you check off which check boxes you want this user to have access too, then click submit and it passes along the user id and all the checkbox values. the next page creates a record in the db for each item with the associated user id in the UsersItems.

You could also go in reverse and list all the items first, click one and it lists all the users who you want to have access to this item.

Hope that helps. I can post an example if you'd like to see it.
User avatar
abionifade
Forum Commoner
Posts: 34
Joined: Thu Apr 18, 2002 5:32 pm

Post by abionifade »

Hi,

could you post your example?

I think what you have achieved is exactly what I am attempting to do.

Thanks Ruiser.

-Abi
Post Reply