PHP mail() and Arrays?

Anon

Hi there all,

Hoping someone can help me with this. Ive searched for a while and cant seem to find anything on this topic.

I have a website where people upload aviation photos to. The uploaded photos then go into a 'queue' (ie: the information is inserted into a 'queue' table.

I then review the photos to see if they are accpetable for the site. If i click on the "accept" button, the information gets inserted into a temp database, one of the fields in the database is 'status'. Should the photos be accepted, then the word 'accepted' is inserted into the field. Should the photo be reject, then the word 'rejected' is inserted into this field.

What i then want to do is have a "process batch" type of thing, where i press a button (or a link) which sends an email out to all of those records waiting in this temp table, and then clears the temp table out. Now here is the bit i dont understand.

Clearly, there may be people in the temp table that have more than one photo that they have uploaded in that session. So what i want to try and do is have an email that looks something like the following.

Dear Name,

your photos have been processed.

Photo "filename" was "status"
Photo "filename" was "status"
Photo "filename" was "status"
Photo "filename" was "status"

Etc....

i can get it to send an email per entry by using the following code.

$get_info = ("select * from temp where email = '$email'");
$get_info_result = mysql_query($get_info) or die("Couldn't get image.");

{
if ($data = mysql_fetch_array($get_info_result)) {
do {

$msg = "Hi $data[name]\n\n";
$msg .= "We checked out your shot/s. See how they went below.\n";
$msg .= "-----------------------------------------------------------------------\n";
$msg .= "$data[orig_image_name] has been $data[status]\n";

$recipient = "<?echo $data[email] ?>";
$subject = "Rwy34.com photo status feedback.";
$mailheaders = "From: Rwy34.com uploads<> \n";
$mailheaders .= "Reply-To: admin@rwy34.com\n\n";
mail($recipient, $subject, $msg, $mailheaders);

} while ($data = mysql_fetch_array($get_info_result));

} else {

etc etc.........

but what i actually want it to do is put all the info into the one email.

Im sorry for such a long post. Hopefully i have provided all the required information needed for someone to be able to assist me with this one.

Regards

Dave

Anon

So in other words what you're wanting to do is:

1) Build the headers and put the introductory text into the message before the loop starts.

2) Get the appropriate details from the database.

3) Run through the returned details in a loop, filling in the rest of the message as you go.

3) After the loop, put any remaining text into the message.

4) Send the mail.

Anon

howdy Grumbler!

heh.....thats a nice simple way of putting it.

Yes, thats what i am wanting it to do.

Thankyou for clarifying that.

Any ideas?

Dave

Anon

Greeting from South Africa!

I'm no php genius, but I would suggest putting the answer of your sql query into a 2 dimentional array.

This way you can run through the array adding enties to the mail.

ps I suggest an extra field in the second dimension as a status control, i.e. has it been added yet?

Good Luck!

ps. Could you please advise me as to why PHP4 might not be reading php.ini file
I have posted the full question under installation.

Thank you

wshost

Sounds like you need another database field such as their name or session id or something unique to them. This way you can do a query for each person and loop it.

Anon

Dave, Grumbler answered your question without actually providing the code. Just move the header stuff outside the do while and just build the body with the do while something like:

// Set it up outside the loop
$msg = "Hi $data[name]\n\n";
$msg .= "We checked out your shot/s. See how they went below.\n";
$msg .= "-----------------------------------------------------------------------\n";
$msg .= "$data[orig_image_name] has been $data[status]\n";

$recipient = "<?echo $data[email] ?>";
$subject = "Rwy34.com photo status feedback.";
$mailheaders = "From: Rwy34.com uploads<> \n";
$mailheaders .= "Reply-To: admin@rwy34.com\n\n";

// Then iterate through the data
while ($data = mysql_fetch_array($get_info_result)) {
$msg .= $data . "\n";
}

// Then mail it
mail($recipient, $subject, $msg, $mailheaders);