using mail() function for selected emails

netfrugal

I have a list of emails and I want to email only selected people by clicking on a checkbox next to their record.

So I created a nice table that shows all records and a checkbox next to each record with the recordID as the value.

But, I am not sure where to go from here. The next page has the mail() function, but I don't know what to do next.

here's the code on page 1:

<form name="form1" method="post" action="mail-to-some.php">
<tr>
<td class="nicetableheader">REQUESTOR</td>
<td class="nicetableheader">NAME</td>
<td class="nicetableheader">checkbox</td>
</tr>
<?
while ($row = mysql_fetch_array($sql)) {
$recID = $row['recID'];
$name = $row['name'];
?>
<tr>
<td class="nicetablerow"><?php echo $name; ?></td>
<td class="nicetablerow" align="center"><input name="sendto" type="checkbox" value="<? echo $recID; ?>" /></td>
</tr>
<? } ?>

      [COLOR=DarkGreen]<tr>
        <td colspan="16" align="right">[/COLOR][COLOR=DarkOrange]<input class="textbox"  type="submit" name="Submit" value="Submit">[/COLOR]	[COLOR=DarkGreen]</td>
      </tr>	[/COLOR]

</form>

And here's the attempted code on the mail-to-some.php. I am having alot of problems about how to make the query from the db - depending on what records were chosen from the previous page.

include('includes/configure.php');

$sql = mysql_query(" ? ");

while ($row = mysql_fetch_array($sql)) {
$email = $row['email'];

$to = $email;
$mailheaders = "Attention!\n";
$Subject = "My subject";
$msg = "My message\r\n";

mail($to, $Subject, $msg, "From: IT Help Desk", $mailheaders);

}

If I am completely off my rocker on how this is performed correctly, I won't be surprised. but any help will be appreciated!

netfrugal

Or do I have to set up a queue?

konrad

First let's change the name of checkbox from 'sendto' to 'sendto[]'. After submitting the form you've got array containing ids of users you want to send emails to. Now let's get email adresses from db and send messages to users:

<?php
 if (count($_POST['sendto']){
  $ids = implode(',', $_POST['sendto']);
  $sql = 'SELECT email FROM users WHERE recID IN (' . $ids . ')';
  $res = mysql_query($sql) or die($sql . ' ' . mysql_error());
  while ($row = mysql_fetch_array($res)){
    $email = $row['email'];
    .
    .
    .
  }
 }

netfrugal

konrad wrote:
First let's change the name of checkbox from 'sendto' to 'sendto[]'. After submitting the form you've got array containing ids of users you want to send emails to. Now let's get email adresses from db and send messages to users:
<?php
 if (count($_POST['sendto']){
  $ids = implode(',', $_POST['sendto']);
  $sql = 'SELECT email FROM users WHERE recID IN (' . $ids . ')';
  $res = mysql_query($sql) or die($sql . ' ' . mysql_error());
  while ($row = mysql_fetch_array($res)){
    $email = $row['email'];
    .
    .
    .
  }
 }

I gave this a try, and I get a parse error:

"parse error, unexpected '{' in mail-to-some.php on line 2"

I'm testing other ways to see what is causing it. But if you have any ideas what is making the error.....

this is how I added the code:

<?
include('includes/configure.php');

if (count($POST['sendto']){
$ids = implode(',', $POST['sendto']);
$sql = "SELECT * FROM results WHERE recID IN (' . $ids . ')";
$res = mysql_query($sql,$connection);

while ($row = mysql_fetch_array($res)){
$recID = $row['recID'];
$mail = $row['email'];

}

$to = $mail;
$mailheaders = "Attention!\n";
$Subject = "Subject";
$msg = "Message here\r\n";

mail($to, $Subject, $msg, "From: IT Help Desk", $mailheaders);
}

konrad

There's no closing bracket in 2nd line. Should be if (count($_POST['sendto'])) {
Sorry for that...

konrad

I've just seen another mistake - mail function should go inside while loop:

<?php
include('includes/configure.php');

if (count($_POST['sendto'])){
$ids = implode(',', $_POST['sendto']);
$sql = "SELECT * FROM results WHERE recID IN (' . $ids . ')";
$res = mysql_query($sql,$connection);


while ($row = mysql_fetch_array($res)){
$recID = $row['recID'];
$mail = $row['email'];
$to = $mail;
$mailheaders = "Attention!\n";
$Subject = "Subject";
$msg = "Message here\r\n";

mail($to, $Subject, $msg, "From: IT Help Desk", $mailheaders);
} // END while loop
}
?>

anoopmail

u missed a closiiong bracket

if (count($_POST['sendto']){

change to

if (count($_POST['sendto'])){

Weedpacket

konrad wrote:
There's no closing bracket in 2nd line. Should be if (count($_POST['sendto'])) {
Sorry for that...

Note to netfrugal: cut-and-paste code never works. Unfortunately, you have to think about the code.