Struggling on how to solve this is issue in my laravel project

You could simply achieve this by adding one or two columns to your table, because all you really need is a way to filter by the term and year.

So if you add the columns term and year you could do..

// Get the student
$student = Student::find(1);

// Get the 2nd term of 2017 with classes and grades
$terms = $student->terms()
    ->with(['classes', 'grades'])
    ->where('year', 2017)
    ->where('term', '2')
    ->first();

You could also query the Term model to get all students, classes and grades for a specific term.

$term = Term::with['students', 'classes', 'grades'])
    ->where('year', 2017)
    ->where('term', '3')
    ->first();

@SaeedPrez ok ... but after each them the subjects results and the fees values will reset cos.. student fees might increase or decrease... subjects will differ also is would not always be 2017 it could 2020 .you understand i don't know if i am making sense .. and after the end of that terms i don't want to loose the student's previous data such as schools subjects score and all those you get it..

@rojonunoo

but after each them the subjects results and the fees values will reset cos..

You'll need to have results, classes, fees, etc in different tables. So when you add a new term, then you can add new classes with new fees to that term.

student fees might increase or decrease...

When you add a student to a class, you can save the current fee in the pivot table if you only want the fee to change for new students.

subjects will differ also is would not always be 2017 it could 2020

Of course, no problem.

and after the end of that terms i don't want to loose the student's previous data such as schools subjects score and all those you get it..

You shouldn't unless you change/deleted the data.

With all that said, I don't know much about your project, but I have a picture in my head what a project like yours should look like. It can be a bit complex with all the relationships and whatnot.

@ SaeedPrez i see yea man it seems pretty complex i might just have to take it step by step .. thanks alot i see myself having a lot of questions is it possible fo r me to keep bothering you along the line if you don't mind pleaseee... you have already been of great help and i appreciate it honestly

@ SaeedPrez so for the first part you saying i can't have my subjects and results to be in the same table . cos i was thinking i was only going to have a Subject tabe Schema:: subject_name and subject_score

but you saying i have a different table for score and subjects right?

@rojonunoo

is it possible fo r me to keep bothering you along the line if you don't mind

You're way better off if you just post your questions on this forum for a couple of reasons..

• There are more knowledgeable people than me here
• My schedule is very unpredictable, some days I won't have time at all so you'll get much faster response

so for the first part you saying i can't have my subjects and results to be in the same table . cos i was thinking i was only going to have a Subject tabe Schema:: subject_name and subject_score but you saying i have a different table for score and subjects right?

I would probably do it with many to many relationships and also save some extra data in the pivot tables. But like I mentioned earlier, it's a bit complicated on the relationship side and it can of course be done in different ways. So if you have an idea how to do it, then go for it.