CODEWITHSUNDEEP
databaselaravelemaillaravel-5sendmail
Dhivya Priya
Dhivya Priya

Reputation: 63

Send email to all the records in the table using where condition in laravel

I am novice to laravel.I need to send email to all the records in the table using where condition(where exam_id=1). Each record will get the email message is name and email of its own.Already stored in the table.Can any own suggest for this?

Advance thanks

       public function sendmail(Request $request) {

        $email = DB::table('student')->select('email','exam_id')->where('exam_id','=','1')->get();
          $email= mysql_query("SELECT email FROM student WHERE exam_id='1' ;"); 
           $title = $request->input('title');
           $content = $request->input('content');
      if(mysql_num_rows($email))
        {
         while($elist_result = mysql_fetch_array($email))
            {
           Mail::send('email', ['title' => $title, 'content' => $content],function ($message) 
             {
             $message->from('[email protected]', 'dhivya');
             $message->to('[email protected]');
                $message->cc($elist_result);
            $message->subject("Hello");

             }  );
               }
          }
             return response()->json(['message' => 'message send successfully']);
              }

Upvotes: 1

Views: 1483

Answers (2)

Dhivya Priya
Dhivya Priya

Reputation: 63

public function sendmail(Request $request) {

        $email = DB::table('student')->select('email','exam_id')->where('exam_id','=','1')->get();

        $title = $request['title'];
        $content = $request['content'];


        foreach($email as $email) {
           Mail::send('email', ['title' => $title, 'content' =>   $content],function ($message) 
             {
             $message->from('[email protected]', 'dhivya');
             $message->to($email->email);
             $message->subject("Hello");

             });
        }

     return response()->json(['message' => 'message send successfully']);
}

Upvotes: 1

Martin
Martin

Reputation: 1279

I'm seeing that you are sticked to clear PHP and it's wrong while you are working on Laravel framework.

public function sendmail(Request $request) {

        $emails = DB::table('student')->select('email','exam_id')->where('exam_id','=','1')->get();

        $title = $request['title'];
        $content = $request['content'];


        foreach($emails as $email) {
           Mail::send('email', ['title' => $title, 'content' =>   $content],function ($message) 
             {
             $message->from('[email protected]', 'dhivya');
             $message->to($email->email);
             $message->subject("Hello");

             });
        }

     return response()->json(['message' => 'message send successfully']);
}

Take a look at your code edited by me and try it.

Upvotes: 0

Related Questions