prevent students from registration

Hello

I have a small system which students can register for courses

the problem when someone is registered on a course, he can register in any course that has the same date lets say.

I have a date start and a date end for a course.

I register users using :


public function register($student, $course)
    {
       
        CourseRegister::create([
            'student'=>$student,
            'course'=>$course
            ]);
      
        
        return redirect()->back();
    }

How I can prevent students from registering in courses that have the same date?

tykus

7 years ago

Best Answer

Level 104

You can add a validation to check if the User is already registered on another course on that date:

public function register($student, $course)
{
    $overlap = CourseRegister::where('student', $student->id)
        ->where('end', '>', $course->start)
        ->where('start', '<',  $course->end)
        ->exists();

    if ($overlap) {
        // cannot register
    }

    CourseRegister::create([
        'student'=>$student,
        'course'=>$course
    ]);
      
        
    return redirect()->back();
}

*** Using student and course as foreign key columns goes against the convention of having a _id suffix; you might find naming the relations awkward as a result...

2 likes

Cronix

7 years ago

Level 67

You might want to turn that into an actual validation rule (or use a rule closure) so you can tell the student what was wrong in a nice way: https://laravel.com/docs/5.7/validation#using-closures

1 like

Please or to participate in this conversation.