Codeigniter using associative array in Email class

Question

I have a certain associative array which contains a list of emails. It's given below:

Array
(
    [0] => Array
        (
            [email] => [email protected]
        )

    [1] => Array
        (
            [email] => [email protected]
        )

    [2] => Array
        (
            [email] => [email protected]
        )

    [3] => Array
        (
            [email] => [email protected]
        )

)

It's being generated from the following controller code:

$data['list_of_emails'] = $this->Trainee_requisition->get_list_of_emails($id);

And the corresponding model code from where the get_list_of_emails($id) method is being accessed:

function get_list_of_emails($id){
        $q = $this->db->query("SELECT `email` FROM `requisition_emails` WHERE `req_id` = $id")->result_array();
        return $q;
}

In the Codeigniter documentations, I've found a way of passing a single dimensional array in the $this->mail->to() method of the Email class, but there is no example of an associative array.

My question is, how can I use the above mentioned associative array in the $this->email->to() method?

My main objective is to generate something like this:

$email_list = array('[email protected]', '[email protected]', '[email protected]', '[email protected]');
$this->email->to($email_list);

Edit:

Although Hassaan's answer is the easiest solution and meets my need perfectly, I'd still appreciate answers which can provide a way to retrieve only one column from a query which has more than one column.

For example, if my query is modified like this:

$q = $this->db->query("SELECT rem.`email`, sr.`is_approve` AS approval_status FROM `requisition_emails` rem INNER JOIN `staff_requisitions` sr ON sr.`id` = rem.`req_id` WHERE rem.`req_id` = $id")->result_array();

but I want only email column to be used from the list, then what is the best possible way?

Edit - 2:

Forgot to mention. PHP version is 5.3.

This is comment after you edited the question. In order to retreive only one column of an array comming from your model, use array_column function, which I used in my answer. — MrD
– MrD, Commented Aug 24, 2015 at 10:10

Hassaan · Accepted Answer · 2015-08-24 09:20:31Z

3

You need to use foreach loop in your view.

Try Example

foreach($list_of_emails as $email)
{
    echo $email."<br />";
    // You can call '$this->mail->to()' to mail.
}

answered Aug 24, 2015 at 9:20

Hassaan

7,7407 gold badges34 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Choudhury Saadmaan Mahmid Over a year ago

I've already used your method, but mail is only sent to the last id, i.e. [email protected] and not to the others.

Choudhury Saadmaan Mahmid Over a year ago

Thanks mate, it's working. The problem was in my further code, I used a die(). That's why, email was always being sent to only one address. Also, I had to put the $this->email->send() inside the foreach().

Choudhury Saadmaan Mahmid Over a year ago

Mate, is it possible for you to update your answer? I have updated my question and looking for yet another small enhancement.

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

As per CI documentation, you can send email to multiple recipients using the following construction:

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

In order to generate this kind of string, do following steps:

Don't touch your model

Use PHP implode and array_column functions to extract email field and to concat all array elements by comma:

$data['list_of_emails']=$this->Trainee_requisition->get_list_of_emails($id);//Get data from model as one dimensional string
$email_list = implode(',',array_column($data['list_of_emails'],'email'));//Implode array elements with comma as separator
$this->email->to($email_list);

You can print $email_list to ensure you have right format by calling var_dump($email_list); exit;.

EDIT (If you are using PHP < 5.5)

Use array_map function, and make the first parameter as anyonimus function. By defining $columnName, you can extract any column you want.

 $columnName = "email";
$result = array_map(
    function ($arrayRow) use ($columnName){
        return $arrayRow[$columnName];
    }
,$data['list_of_emails']);
var_dump(implode(",",$result));
$this->email->to($result );

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 24, 2015 at 9:40

MrD

2,4914 gold badges35 silver badges58 bronze badges

4 Comments

Choudhury Saadmaan Mahmid Over a year ago

In my question, for convenience I've fetched only one column in my query. What if I re-write my query so that it returns more than one column? How can I fetch email then?

MrD Over a year ago

Update is there, please check and try!

Choudhury Saadmaan Mahmid Over a year ago

I'm testing. I'll let you now later. Thanks!

Choudhury Saadmaan Mahmid Over a year ago

array_column() doesn't work for PHP versions earlier than 5.5 . Mine is 5.3.

Narendrasingh Sisodia · Accepted Answer · 2015-08-24 09:30:52Z

1

You can simply array_column as

$new_array = array_column('email');

answered Aug 24, 2015 at 9:30

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Comments

Silent_Coder · Accepted Answer · 2015-08-24 09:36:03Z

1

this should work!

<?php  $array = array(array("email" => "[email protected]"), array("email" => "[email protected]")); $emailList = array_map('current', $array); print_r($emailList);

answered Aug 24, 2015 at 9:36

Silent_Coder

1501 silver badge11 bronze badges

Comments

Keval Rathi · Accepted Answer · 2015-08-24 09:26:16Z

0

Try this may be solve your problem.

$query->result_array();

it will gives single dimensional array

answered Aug 24, 2015 at 9:26

Keval Rathi

9866 silver badges21 bronze badges

1 Comment

Choudhury Saadmaan Mahmid Over a year ago

I think you didn't see my question properly. I've used result_array() method in my model code.

Collectives™ on Stack Overflow

Codeigniter using associative array in Email class

5 Answers 5

3 Comments

EDIT (If you are using PHP < 5.5)

4 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

EDIT (If you are using PHP < 5.5)

4 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related