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.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community