close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Premiere Ticket other Questions...

Thread began 8/31/2011 2:42 am by Sly Verano | Last modified 9/26/2011 7:51 am by Sly Verano | 3099 views | 9 replies

Jason ByrnesWebAssist

  1.) How can the professor create a new classpage.php, for me to able to add the comment system inside that classpage.php.  



you dont create a new physical file. On the classpage.php file, you create a recordset to look up the class by ID.

you would have one page that listed all of the classes with a link top the classpage.php file, that passes a querystring variable. The technique is reffered to as a master details page set:
WScbb6b82af5544594822510a94ae8d65-78b7a.html

  2.) After the professor created the classpage.php, How could the professor add a student to that classpage.php ?

3.) How could the student join to that classpage.php ?  



I think you are missing some basic MySQL relational data concepts that will be needed to get this working.

in a mysql database, all of your tables will have a primary key column.

for the classes table, there will be a primary key column that uniquely identifies the class.

for the student table, there will be an ID column that uniquely identifies the student.

In MySQL you use these ID values to create relationships between the data.

there are 2 basic types of relationships:
1) One to Many
2) Many to Many

One to many relationships are pretty easy, but many to many relationships are more difficult.

With assigning students to classes, you are talking about a many to many relationship.

the idea with a many to many relationship is to create a linking table.

for example, if you have a students table:

students:
studentID - Primary Key
studentName - text
etc...

and a classes table:
classID - Primary Key
className - text
etc

you would need to create a studentClasses linking table:

studentClasssID - Primary Key
studentClassStudentID - relates to students.studentID
studentClassClassID - Relates to classes.classID

for the professor to assign students to the class, you needs to create a page where the professor selects the student, then selects the class and inserts the student ID and the Class ID to the studentClass table.


for the student to sign up for a class, when they login, their ID will be stored in a session variable, you need to set up a page where the student selects the class, then ID session variable and the Class ID are stored to the studentClass table.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...