foreach problems

gilbertsavier · #1 (**permalink**) 07-13-09, 12:33 AM

Hi,
I have a list of names, emails, a checkbox and a message box, the names and emails are from a database. What I am trying to do to select say 5 of the names from the list via the checkbox and send an email to those who I have picked.

I can't seem to get my head around the foreach function, is it that there has to be a foreach function to collect the email addresses and to see which user has been selected or do they come under the same one.

I have tried to do some of the coding myself, but fear I am getting more and more confused, some help would be great. Here is what I have done so far.

---------------
Thanks & regards
Lokananth
Live chat By miOOt

pyr0t3chnician · #2 (**permalink**) 07-17-09, 02:24 AM

Typically the ids of the checkboxes will be able to pull up the data to send the email. You would only need 1 foreach loop if that is the case.

Code:

foreach($checkbox as $id){
//pull up the info from mysql or other info using $id.
//send the email.
}

You might want to play around with checkboxes for a while and see how it is passed as a post variable and how you can manipulate it. I am working with something similar where the user can click a check box, and with the selected ones, they can perform a set of given actions (delete, update, move, etc).

I'm sorry I can't give you exact code because I am not sure exactly what/how you are doing this. Good luck.

job0107 · #3 (**permalink**) 07-17-09, 04:57 AM

Here is a simple program that will send a message to the name/email pairs you have in your database.
One thing to consider though, is the amount of time it will take to send the emails.
If it takes too long then the program may timeout.
So you may want to send only 10 or 20 at a time.
You could set a limit in your query to 10 or 20, then just page through the records if you have more then the limit is set for.

You will need to have a table in your database with columns 'name' and 'email' for the query to work.
Otherwise change the column names in the query to match the column names in the table.
And change the values of
$host
$user
$password
$db
$table
to match your configuration.

PHP Code:


			
<?php
if(!empty($_POST["submit"]))
{
 $subject = "Hello friend";
 $headers  = 'MIME-Version: 1.0' . "\r\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
 $headers .= 'From: job0107@comcast.net' . "\r\n";
 $msg = stripslashes($_POST["msg"]);
 foreach($_POST as $name => $email)
 {
  if($name == "msg" || $name == "submit"){}
  else
  {
   $parts = explode(",",$email);
   $body = "Hello ".$parts[0].",<br />".$msg;
   mail($parts[1],$subject,$body,$headers);
   }
  }
 }
?>
<html>
<head?
<title></title>
</head>
<body>
<form action="#" method="post">
<?php
$host = "localhost"; // mysql host address
$user = "root";      // mysql username
$password = "";      // mysql password
$db = "test";        // mysql database name
$table = "client";   // mysql table name

mysql_connect($host,$user,$password) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());

$sql = "SELECT name,email FROM $table";
$results = mysql_query($sql) or die(mysql_error());
$ct=0;
while($row = mysql_fetch_assoc($results))
{
 echo "<input type='checkbox' name='client".$ct."' value='".$row["name"].",".$row["email"]."'> ".$row["name"]."<br />";
 $ct++;
 }
?>
<br />Message: <textarea name="msg"></textarea>
<p>
<input type="submit" value="Submit" name="submit">
</form>