Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
this is my DB user table
users table
id name email
1 James [email protected]
2 Harry [email protected]
3 Diana [email protected]
4 Mey [email protected]
job table
id idUser date jobName
1 1 2017-11-17 JOB A
2 2 2017-11-17 JOB B
3 3 2017-11-18 JOB C
4 4 2017-11-19 JOB D
i want to send notification via email when date in my database = date today..
example date today is 2017-11-17, so system automatically send notification via email to idUser 1 and 2, like this
FOR USER ID =1
YOU HAVE JOB TODAY JAMES,
JOB NAME = JOB A
FOR USER ID =2
YOU HAVE JOB TODAY HARRY,
JOB NAME = JOB B
First step is to create a relationship between the two tables. You can add a "hasMany" method for the jobs in the user model to collect all jobs. https://laravel.com/docs/5.5/eloquent-relationships#one-to-many
Second step is to create a scope method inside your jobs model that fetches all jobs for a user for today. https://laravel.com/docs/5.5/eloquent#local-scopes
Third step is to send the mail with the given data.
*** The Easiest way would be to create a Laravel Scheduler ok. ***
So you can call your function from the schedule command
Open app/console/Kernel.php and under scheduler an example
$schedule->call(function () {
$this->send_job_notifier()
})->daily();
*** Create another function still in the kernel ***
protected function send_job_notifier() {
// get carbon date function here and calculate date differences and match against today
}
I Suggest you use Carbon for your dates, it's included with your laravel instance for docs: Carbon Package
@peacengara and how to send the email??
You can use anything from basic "phpmail" function to the laravel mailer https://laravel.com/docs/5.5/mail
Please or to participate in this conversation.