Ytukyg

I want to know that how can I get that how many days are left in course duration.

course-duration is just a column and hold an integer in database like 30.

I want to compare course-duration with created_at and return me that left days in laravel.

id  username  course   course-duration(days)    created_at

---------------------------------------------------------------------

1   krish     SSB      14                       2018-11-19

---------------------------------------------------------------------

2   Brij      SSB      30                       2018-11-18

---------------------------------------------------------------------

3   Sagar     SSB      90                       2018-11-15

I want to get remaining days of the course after comparing course-duration with created_at.

You can get the remain days like this:

DB::statement("SELECT (course-duration - DATEDIFF(NOW(), created_at)) remained FROM your_table");

You can use Carbon to get the value of days between created_at and now

$diff_from_now = Carbon::parse($course->created_at)->diffInDays();

$course_duration = $course->duration;

$remaining_days = $course_duration- $diff_from_now;

Try this one

   Select sub(course-duration - DATE(created_at)) as left_days from table_name;

Just define a method in your Course model to calculate remaining days of each course:

class Course extends Model

{



    public function remainingDays() {

        return $this->course-duration - $this->created_at->diffInDays(Carbon::now());

    }



}

And to get remaining days of every course:

$course->remainingDays();