Support the ongoing development of Laravel.io →
posted 8 years ago
Queues
Last updated 1 year ago.
0

how sad, no one reply...

0

Table 1: tbl_send_email_queue

Table 2: tbl_send_email

Step 1: setup cron job which execute one file or in our case execute route each day's 1st minute.

Step 2: Hear you have to write script which get current date and compate it to admin defiend date if it's match then procced bellow steps.

Step 3: after user successfull registration, insert mail content and email id in tbl_send_email_queue table with send_email_flag=false.

Step 4: while procession step 1 script select all email from tbl_send_email_queue and move it to tbl_send_email and make send_email_flag=true

Stpe 5: now setup another cron job which execute one file or in our case execute route every 15 minute.

Step 6: for step 5 cron job script select 10 email from tbl_send_email table with send_email_flag=false, and execute mail script for that 10 emails.

10 email because of reduce server load.

Last updated 8 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

destrutorx destrutorx Joined 13 Jan 2015

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.