Ad:

PHP Discussion Thread
Marked Solved
Views: 1095

Mar 9th, 2009

send email on mysql db update

Expand Post »

i am trying to get this code to work but there is something wrong with the array (not to good at these). the main part of the code works it is sending out the email but only ever to one registered user.

here is the code i have so far.

PHP Syntax (Toggle Plain Text)
	$query = "SELECT email FROM emails";
	$result = mysql_query($query) or die(mysql_error());
 
	while($row = mysql_fetch_array($result)) {
 
	$contactemail = $row['email'];
 
 
 
 
	// Contacts
	//$replyName = $merc_replyId;
	//$replyEmail = $merc_replyAddress;
 
	$replyName = "PiPonliine";
	$replyEmail = "info@piponline.info";
 
	$contactname = "";
 
 
	// Subject
	$subject = "Website Update";
 
	// Headers
	$headers = "MIME-Version: 1.0" . PHP_EOL;
	$headers .= "Content-type: text/html; charset=iso-8859-1" . PHP_EOL;
	$headers .= "From: ".$replyName." <".$replyEmail.">" . PHP_EOL;
	$headers .= "BCC: ".$contactname." <".$contactemail.">\r\n" . PHP_EOL;
 
 
	mail($contactemail, $subject, $message, $headers);
	}
  echo "$contactemail";
  echo "<h2>Email notification sent</h2>";
  echo "<h2>1 record added</h2>";
 
  mysql_close($con);
	$query = "SELECT email FROM emails";
	$result = mysql_query($query) or die(mysql_error());

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



	// Contacts
	//$replyName = $merc_replyId;
	//$replyEmail = $merc_replyAddress;
	
	$replyName = "PiPonliine";
	$replyEmail = "info@piponline.info";

	$contactname = "";
	

	// Subject
	$subject = "Website Update";

	// Headers
	$headers = "MIME-Version: 1.0" . PHP_EOL;
	$headers .= "Content-type: text/html; charset=iso-8859-1" . PHP_EOL;
	$headers .= "From: ".$replyName." <".$replyEmail.">" . PHP_EOL;
	$headers .= "BCC: ".$contactname." <".$contactemail.">\r\n" . PHP_EOL;
	

	mail($contactemail, $subject, $message, $headers);
	}
  echo "$contactemail";
  echo "<h2>Email notification sent</h2>";
  echo "<h2>1 record added</h2>";

  mysql_close($con);

Similar Threads

send email on mysql db update in PHP
Using PHP/HTML to update informationin MySQL in PHP
How to pre-select checkboxes in form? in PHP

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

Permalink

Mar 9th, 2009

Re: send email on mysql db update

[QUOTE=kevin wood;821441]i am trying to get this code to work but there is something wrong with the array (not to good at these). the main part of the code works it is sending out the email but only ever to one registered user.

Hi..
i dont know the exact solution....but, try to do this...

1) if there is any id in database, try to using id by incrementing.......
2) try to use FOREACH instead of while......

this is just try, i dont know the exact way.....

ahmksssv

Reputation Points: 11

Solved Threads: 7

Junior Poster in Training

Offline

84 posts
since Feb 2009

Permalink

Mar 9th, 2009

Re: send email on mysql db update

a foreach loop will need to start with a while loop and i do not see the need to use the id of the table as i only need to loop through the email address and user these to send the email.

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

Permalink

Mar 10th, 2009

Re: send email on mysql db update

@Kevin wood, Your script seems fine.
Try this.

php Syntax (Toggle Plain Text)
	$query = "SELECT email FROM emails";
	$result = mysql_query($query) or die(mysql_error());
 
	while($row = mysql_fetch_array($result)) {
 
	$emailaddress[] = $row['email'];
	}
 
 
	// Contacts
	//$replyName = $merc_replyId;
	//$replyEmail = $merc_replyAddress;
	$i=0;
	foreach($emailaddress as $contactemail) {
	$replyName = "PiPonliine";
	$replyEmail = "info@piponline.info";
 
	$contactname = "";
 
 
	// Subject
	$subject = "Website Update";
 
	// Headers
	$headers = "MIME-Version: 1.0" . PHP_EOL;
	$headers .= "Content-type: text/html; charset=iso-8859-1" . PHP_EOL;
	$headers .= "From: ".$replyName." <".$replyEmail.">" . PHP_EOL;
	$headers .= "BCC: ".$contactname." <".$contactemail.">\r\n" . PHP_EOL;
 
 
	mail($contactemail, $subject, $message, $headers);
	$i++;
	}
  echo "$contactemail"; //this will print only 1 email address, which is the last one
  echo "<h2>Email notification sent</h2>";
  echo "<h2>".$i." mails sent</h2>";
	$query = "SELECT email FROM emails";
	$result = mysql_query($query) or die(mysql_error());

	while($row = mysql_fetch_array($result)) {
	
	$emailaddress[] = $row['email'];
	}


	// Contacts
	//$replyName = $merc_replyId;
	//$replyEmail = $merc_replyAddress;
	$i=0;
	foreach($emailaddress as $contactemail) {
	$replyName = "PiPonliine";
	$replyEmail = "info@piponline.info";

	$contactname = "";
	

	// Subject
	$subject = "Website Update";

	// Headers
	$headers = "MIME-Version: 1.0" . PHP_EOL;
	$headers .= "Content-type: text/html; charset=iso-8859-1" . PHP_EOL;
	$headers .= "From: ".$replyName." <".$replyEmail.">" . PHP_EOL;
	$headers .= "BCC: ".$contactname." <".$contactemail.">\r\n" . PHP_EOL;
	

	mail($contactemail, $subject, $message, $headers);
	$i++;
	}
  echo "$contactemail"; //this will print only 1 email address, which is the last one
  echo "<h2>Email notification sent</h2>";
  echo "<h2>".$i." mails sent</h2>";

This definitely works. (I tried with 3 email addresses)

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Mar 10th, 2009

Re: send email on mysql db update

thank you for the reply i ended up getting it working late last night with a similar piece of code. thank you again for the reply.

kevin wood

Reputation Points: 27

Solved Threads: 1

Posting Whiz

Offline

347 posts
since Feb 2008

Permalink

Mar 10th, 2009

Re: send email on mysql db update

You are welcome.. Cheers man!

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: IP Penguin Shower

Next Thread in PHP Forum Timeline: Check out the code ...

DaniWeb Message

Cancel Changes

User Name
Password