send email to the particular user selected form dropdown in codeigniter

Question

I have two tables in my database one is users and another one is requirements..so I displayed user names in the requirements form with multiple select dropdown..when admin send requirements from the requirement form...I need to send that requirement to particular users..with selected by the admin from the dropdown..

this is my controller :

 public function requirement() {
     $this->load->model('RequirementModel');
     $data['user']=$this->RequirementModel->getusers();

     $this->load->view('Requirements/requirements',$data);

     $insert=array(
         'role_name'=>$this->input->post('role_name'),
         'vacancies'=>$this->input->post('vacancies'),
         'experience'=>$this->input->post('experience'),
         'jd'=>$this->input->post('jd'),
         'hiring_contact_name'=>$this->input->post('hiring_contact_name'),
         'hiring_contact_number'=>$this->input->post('hiring_contact_number'),
         'user_id'=> implode(',',$this->input->post('user_id'))
     );
     $this->RequirementModel->add_requirement($insert);
 }

Please help me how can we send mail to the particular users.. Thank You

i didn't tried any code yet? i am new to codeigniter..please help me.. — M5533, Feb 08 '17 at 04:47
just get the user's email selected by the admin and to send an email please checkout the article http://stackoverflow.com/questions/18586801/send-email-by-using-codeigniter-library-via-localhost — Happy Coding, Feb 08 '17 at 04:50
i know how to send mail ...but i dont know how to send mail to particular users selected by admin from dropdown list..if u have any idea please explain me the logic — M5533, Feb 08 '17 at 04:53
dude!!! when admin select the user can't you get get the user's id. If yes then use it get the email of selected id. — Happy Coding, Feb 08 '17 at 04:55
how can we get the email form user id by using GET method or is there anything ... — M5533, Feb 08 '17 at 05:24

Happy Coding · Accepted Answer · 2017-02-08T06:27:18.983

This must be your HTML code in your view file.

<select id='user' name="user">
    <option value="">Please Select Name</option>
    <?php foreach($user as $val){ ?>
    <option value="<?php echo $val['id'];?>" ><?php echo $val['name']?></option>
    <?php } ?>
</select>

In your controller you can get user id by POST method $this->input->post('user');

Create a model function to retrieve user email by user id get_user_email_by_id then call the model to get the email of the selected user.

$this->your_model->get_user_email_by_id($this->input->post('user'));

After that you can send the email to the selected user.

Update

You want to send email to multiple number of users, this was not specified by you earlier Try to be specific for the requirement. Get multiple user id in a variable.

$all_users = $this->input->post('user_id');

foreach($all_users as $key)
{
  $get_email = $this->your_model->get_user_email_by_id($key);
  // write function to send email
}

Model Function to get user email by id:

function get_user_email_by_id($user_id) 
{ 
  $this->db->select('*'); 
  $this->db->from('users'); 
  $this->db->where('user_id',$user_id); 
  $query = $this->db->get(); 
  $result = $query->row_array();
  return $result['email'];
}

ok thank you @Happy Coding..today i learn how to send mail..because of you only..thank you thanks alot.. — M5533, Feb 08 '17 at 07:06

send email to the particular user selected form dropdown in codeigniter

1 Answers1