Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

PHP

Kavish Kansal
Kavish Kansal
2,887 Points
Posted by Kavish Kansal
Kavish Kansal
2,887 Points

I want to create a elearning system in PHP and MySQL. I want to know how to track course progress for each user?

I want to create a elearning system in PHP and MySQL. I want to know how to track course progress for each user?

Can anyone help me understand the database schema for it? It will be a great help!

1 Answer

Riku S.
Riku S.
11,322 Points
Riku S.
Riku S.
11,322 Points

Just an example with very simple four tables, in reality you would probably need lots more based on the required features:

topics table

  • id
  • name

courses table

  • id
  • topic_id
  • name

students table

  • id
  • name
  • etc...

student_courses table

  • student_id
  • course_id

When a student finishes a course, you will store the student and the course id's into sudent_courses table.

Kavish Kansal
Kavish Kansal
2,887 Points
Kavish Kansal
Kavish Kansal
2,887 Points

But how will it help in tracking per topic progress? shall I add json string in student_courses table with a column name, topics?