Add a comment and email the comment to notify all email addresses in the database

Code:

function get_comment_for_email(){



 //  comments.*  this means every field on the comments table.

 $this->db->select('comments.*, users.username, users.email');

 $this->db->from('comments');

 $this->db->join('users', 'users.userID=comments.userID', 'left');

 //$this->db->where('users.userID', 'comments.userID');

 $this->db->order_by('comments.date_added', 'desc');

 $this->db->limit(1);

 $query = $this->db->get();

 return $query->result_array();

 }

Code:

&lt;?php



class Comments extends CI_Controller {







 function add_comment($entryID){

  date_default_timezone_set('America/Barbados');   //becareful when using this on alive server it may be incorrect









  //if nothing got posted redirect to entryID

  if(!$_POST){

   redirect(base_url().'blogs/an_entry/'.$entryID);



  }



  //check to see that they are logged in

   $user_Type = $this->session->userdata('user_type');

  if(!$user_Type){

   //if not logged in redirect to login page

   redirect(base_url().'users/log_in');

  }





  //load comment model

  $this->load->model('comment');

  $this->load->model('user');

  $this->load->model('blog');



  //create a data array

  $data = array(

    'entry_id' => $entryID,

    'userID' => $this->session->userdata('userID'),

    'comment' =>$_POST['comment'],

    'date_added' => date('Y-m-d H:i:s')

             );

  //execute

  $this->comment->add_a_comment($data);





  //AT THIS POINT EMAILS ARE SENT TO ALL EMAIL ADDRESSES STORED IN THE DATABASE of the last comment added

  //get all the email addresses from User Model

  $emails = $this->user->get_emails();

  $username_and_comments = $this->comment->get_comment_for_email();

  $subjects = $this->blog->get_subjects();



  //Setup gmail email configs

  $email_config = Array(

            'protocol'  => 'smtp',

            'smtp_host' => 'smtp.gmail.com',

            'smtp_port' => '465',

            'smtp_crypto' => 'ssl',

            'smtp_timeout' => '7',

            'smtp_user' => '[email protected]',

            'smtp_pass' => 'password',

            'charset'   =>  'iso-8859-1',   //or 'charset' => 'utf-8'

            'mailtype'  => 'html',

            'wordwrap' => TRUE,

            'starttls'  => true,

            'newline'   => "\r\n"

        );



      



        foreach ($emails as $row) {



         if($row['email']){

         $this->load->library('email', $email_config);

         $this->email->from('my gmail address', 'G.O.T -Season 4 Blog Message');

         $this->email->to($row['email']);

    foreach ($username_and_comments as $row2) {

          $this->email->subject('G.O.T -Season 4 Blog Message');

          foreach ($subjects as $row3) {

         $this->email->message('For the post named:'.$row3['title'] .' '. $row2['username'].'said:' .$row2['comment']);

         }

         }

         $this->email->send();

        // uese print_debugger (below) for tesing email in debug mode

        // echo $this->email->print_debugger();

        

         $this->email->clear();



     }



  } 





  //redirect

  redirect(base_url().'blogs/an_entry/'.$entryID);



  

 

 }





}

Code:

$email_config = Array(

            'protocol'  => 'smtp',

            'smtp_host' => 'smtp.thedomain..com',

            'smtp_port' => '2525',

            'validation' => TRUE,

            'smtp_timeout' => '7',

            'smtp_user' => '[email protected]',

            'smtp_pass' => 'password',

            'charset'   =>  'iso-8859-1',   //or 'charset' => 'iso-8859-1'

            'mailtype'  => 'html',

            'wordwrap' => TRUE,

            'newline'   => "\r\n"

        );

Code:

$email_config = Array(

            'protocol'  => 'smtp',

            'smtp_host' => 'smtp.mydomain.com',

            'smtp_port' => '587',

            'validation' => TRUE,

          //  'smtp_crypto' => 'ssl',

            'smtp_timeout' => '7',

            'smtp_user' => [email protected]',

            'smtp_pass' => 'password',

            'charset'   =>  'iso-8859-1',   //or 'charset' => 'iso-8859-1'

            'mailtype'  => 'html',

            'wordwrap' => TRUE,

          //  'starttls'  => true,

            'newline'   => "\r\n"

        );

Code:

$this->load->library('email');   // This should not be in your foreach loop.



     $config = Array(

            'protocol'  => 'smtp',

            'smtp_host' => 'smtp.mydomain.com',

            'smtp_port' => '587',

            'validation' => TRUE,

          //  'smtp_crypto' => 'ssl',

            'smtp_timeout' => '7',

            'smtp_user' => [email protected]',

            'smtp_pass' => 'password',

            'charset'   =>  'iso-8859-1',   //or 'charset' => 'iso-8859-1'

            'mailtype'  => 'html',

            'wordwrap' => TRUE,

          //  'starttls'  => true,

            'newline'   => "\r\n"

     ); 



     $this->email->initialize($config);