PHP Sending Arrays with Mail()

Question

I am trying to send the contents of an array through mail, I have tried the print_r method however do not really like the way it is formatted in the email, so I tried the implode, however currently it is not actually sending the content, rather just "Array Array Array"

This is my code:

<?php 
$con = mysqli_connect("localhost", "user","pw", "db");
if (!$con)
{
 die('Could not connect: ' . mysqli_error($con));
}

$recipient_email = "[email protected]";

$result= mysqli_query($con, "SELECT * FROM subscribers WHERE datetime_registered >=       DATE_SUB(NOW(), INTERVAL 9 DAY)")or die(mysqli_error($con));
$subscribers = array();
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){

    $subscribers[] = array(
    "uid" => $row['id'],
    "name" => $row['name'],
    "email" => $row['email'],
    "ip" => $row['ip'],
    "date_registered" => $row['datetime_registered']
    );


 }


 $headers  = 'MIME-Version: 1.0' . "\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\n";
 $headers .= 'From: '.$recipient_email.''."\n";

 $subject = "Subject";
 $recipient = $recipient_email;
 $content = implode("\n", $subscribers);
 mail($recipient, $subject, $content, $headers);
 ?>

Does anyone know what is going wrong?

Benz · Accepted Answer · 2013-06-14 08:57:03Z

3

When you want to mail an array with print_r, fill the second parameter with true:

print_r($array, true);

See the following link for more information: http://php.net/manual/en/function.print-r.php

answered Jun 14, 2013 at 8:57

Benz

2,33513 silver badges19 bronze badges

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

Comments

ajtrichards · Accepted Answer · 2013-06-01 20:25:56Z

1

It's because the implode function is only imploding your top-level array which is $subscribers. It's not going down to the next level array data.

You could try this:

foreach($subscribers as $subscriber_data){
    $dataset[] = implode(', ', $subscriber_data);
}

$content = implode("\n", $dataset);
mail($recipient, $subject, $content, $headers);

answered Jun 1, 2013 at 20:25

ajtrichards

30.7k13 gold badges99 silver badges102 bronze badges

Comments

Phil Cross · Accepted Answer · 2013-06-01 20:53:29Z

0

Before your $headers variables, use this code:

$newSubscribers = array();
foreach($subscribers as $data)
{
    $newSubscribers[] = implode(', ', $data);
}

$newSubscribers = implode("<br>\n", $newSubscribers);
$subscribers = $newSubscribers;

So your end code should look like this:

...
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){

$subscribers[] = array(
"uid" => $row['id'],
"name" => $row['name'],
"email" => $row['email'],
"ip" => $row['ip'],
"date_registered" => $row['datetime_registered']
);


}

$newSubscribers = array();
foreach($subscribers as $data)
{
    $newSubscribers[] = implode(', ', $data);
}

$newSubscribers = implode("\n<br>", $newSubscribers);
$subscribers = $newSubscribers;


$headers  = 'MIME-Version: 1.0' . "\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\n";
$headers .= 'From: '.$recipient_email.''."\n";

edited Jun 1, 2013 at 20:53

answered Jun 1, 2013 at 20:24

Phil Cross

9,33212 gold badges54 silver badges86 bronze badges

1 Comment

Jamie000012 Over a year ago

Phil this is great thanks, however it is not actually putting it on a new line, how would I get a new line between each subscriber for the email?

Eric Wich · Accepted Answer · 2013-06-01 20:30:18Z

0

The reason it's not working as you'd like is because implode() does not work with associative arrays the way you think it would. I'd recommend:

$subscribers[] = array(
"uid: {$row['id']}",
"name: {$row['name']}",
...
);

Then when you parse this array with implode, with a newline as the delimiter, you will see

"uid: someid
 name: somename
 ....
"

Which I assume is what you're going for. Cheers!

answered Jun 1, 2013 at 20:30

Eric Wich

1,54410 silver badges8 bronze badges

Comments

muni · Accepted Answer · 2015-01-09 05:43:26Z

0

It is very nice you send that array in key value pairs, instead of sending only value..

convert that using following script and send it via your email.

$data = '';
foreach ($subscribers as $key=>$value){
    $data .= $key.'-------'.$value;
    $data.= "\n";
}

send via php mail function..

$headers  = 'MIME-Version: 1.0' . "\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\n";
$headers .= 'From: '.$recipient_email.''."\n";

$subject = "Subject";
$recipient = $recipient_email;
$content = $data;
mail($recipient, $subject, $content, $headers);

answered Jan 9, 2015 at 5:43

muni

1,3602 gold badges19 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP Sending Arrays with Mail()

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related