Jump to content

php email problem getting email address from mysql


computel

Recommended Posts

php email problem getting email address from mysql

 

Here is the email i see sitting on my hosting server. as you can see the to: field is blank and not getting the emails from mysql database.

 

Return-path: <>

Envelope-to: hidden@chevette.websitewelcome.com

Delivery-date: Wed, 14 Jul 2010 15:47:32 -0500

Received: from mailnull by chevette.websitewelcome.com with local (Exim 4.69)

id 1OZ8rc-0000WU-IV

for hidden@chevette.websitewelcome.com; Wed, 14 Jul 2010 15:47:32 -0500

Auto-Submitted: auto-replied

From: Mail Delivery System <Mailer-Daemon@chevette.websitewelcome.com>

To: hidden@chevette.websitewelcome.com

Subject: Mail failure - no recipient addresses

Message-Id: <E1OZ8rc-0000WU-IV@chevette.websitewelcome.com>

Date: Wed, 14 Jul 2010 15:47:32 -0500

A message that you sent contained no recipient addresses, and therefore no

delivery could be attempted.

------ This is a copy of your message, including all the headers. ------

To:

Subject: test

 

 

The user signs up and thier email_address & name get stored in the games_newsletter table.

 

here is the php code that sends the emails out.

 

 
<?
require_once("../conn.php");
require_once("../includes.php");
require_once("access.php");
require_once("AdminNavigation.php");
if(isset($_POST[s1]))
{
$q2 = "select * from games_newsletter ";
$r2 = mysql_query($q2) or die(mysql_error());
   
while($a2 = mysql_fetch_array($r2))
{
  $to = $a2[email];
  $subject = $_POST[sub];
  $message = $_POST[MyMessage];
  $headers = "MIME-Version: 1.0\n"; 
  $headers .= "Content-type: text/plain; charset=iso-8859-1\n";
  $headers .= "Content-Transfer-Encoding: 8bit\n"; 
  $headers .= "From: $_SERVER[HTTP_HOST]$dir <$aset[ContactEmail]>\n"; 
  $headers .= "X-Priority: 1\n"; 
  $headers .= "X-MSMail-Priority: High\n"; 
  $headers .= "X-Mailer: PHP/" . phpversion()."\n"; 
  mail($to, $subject, $message, $headers);
  $i++;
}
$error = "$i messages was sent";
}
//get the number of registered for the newsletter
$q2 = "select count(*) from games_newsletter";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);

if($a2[0] == 0)
{
echo "<br><br><center><span class=RedLink>There are no registered members, yet!</span></center>";
exit();
}
?>
<script>
function CheckMail() {
  if(document.f1.sub.value=="")
  {
   alert('Enter the newsletter subject line, please!');
   document.f1.sub.focus();
   return false;
  }
  if(document.f1.MyMessage.value=="")
  {
   alert('Enter the newsletter text, please!');
   document.f1.MyMessage.focus();
   return false;
  }
}
</script>
<center>
<span class=BlackLink>
  There are <?=$a2[0]?> newsletter subscribers.
</span>
</center>
<br>
<form method=post onsubmit="return CheckMail();" name=f1>
<table align=center width=500>
<tr>
<td></td>
<td><b>Newsletter</b><br><?=$error?></td>
</tr>
<tr>
<td align=right>Subject:</td>
<td><input type=text name=sub size=36></td>
</tr>
<tr>
<td align=right valign=top>Message:</td>
<td><textarea name=MyMessage rows=10 cols=50></textarea></td>
</tr>
<tr>
<td>&nbsp</td>
<td><input type=submit name=s1 value="Send" class="sub1"></td>
</tr>
</table>
</form>
<?
require_once("admin_footer.php");
?>
[/sub]

 

I have spent the whole day on this and it doesn't work. I have a members email and it sends out the emails no problem and from what I could see the only diffents in the two php files were the select from * tables and that is it.

 

thank you in advance

Link to comment
Share on other sites

Figured it out myself. all I did was change the email_address to email in the games_newsletter table and made a change to the subscription form and it all worked out. strange I have no programming or PHP experience but it goers to show sometimes just trying things can fix it.

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.