[RESOLVED] Update status THEN email notify

moonbrat

Sorry to be a brat again...I don't mean to be...but my mind ain't with me and I'm banging my head on the keyboard (theoritcally speaking), because I'm trying to get my script to SEND a mail to notify of an update to just 1 user from the db...

what I mean is:

If someone has their approval status as N for not approved, and I change it to Y, is approved via a form to update my database, I want it to send to the user I've updated...

So this is a snippet of my script...the update part:

   $query = "UPDATE $table2 SET approved = 'Y' WHERE
      approved = 'N' LIMIT 1";
   $result = mysql_query($query) or problem('Can not approve affiliate.' . mysql_error());
return $result;

//note from moonbrat: $approve is reading the FORM NAME//

   if($approve) {

$to = $obj->email;
$message="Hello $obj->username;

You have been approved approved by $settings[admin_name] to be an affiliate with $settings[site_name]. Your username and password are shown below. DO NOT lose this email as you may need to refer to it if you need to update your information at: $settings[site_url]

Affiliate Details:

Name: $obj->username;
Password: $obj->pw;

Regards,
$settings[email_name].

";
$subject = "Affiliation Approved!\n";
$headers = "From: $settings[email_name] <$settings[admin_email]>\n";
$headers .= "Reply-To: $settings[email_name] <$settings[admin_email]>\n";

mail($to,$subject,$message,$headers);
 }

I don't get any errors, it works perfect, BUT the email WONT send when updated, can anyone suggest what I can do to get it to send? I know my php reads the mail() functions because when I want something to send to me on someone signing up, it works no problems....because I've used it elsewhere in my script just not with update...

Sorry, my mind's just not with me and I've been at this all night...the damn thing won't do what I want it to do!

-Moonbrat

NogDog

Try changing the string endings as follows so that your mail headers will all have the requisite "\r\n" separators, plus to add the X-Mailer header:

$subject = "Affiliation Approved!";
$headers = "From: {$settings['email_name']} <{$settings['admin_email']}>\r\n";
$headers .= "Reply-To: {$settings['email_name']} <{$settings['admin_email']}>\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();

mail($to,$subject,$message,$headers);

moonbrat

Nope didn't work sigh I know my php sendmail thingy whatever it does for php works, because when I insert a member to test it, I (as admin) get a notification that someone joined...but I'd like for it to do the same thing for a member from ME on approval instead of manually emailing them....

I need some sort of way to get my script to recognise $to as the $email from the db belonging to the person just approved (e.g. use of $username or $id).
It's just not working....
I got it working ONCE then I broke it...been at it ever since...sigh....

Oh and the email FIELD is printed on my screen as it's echo'd from my database as $obj->email but defined in my script as something like: mysql_fetch_array($row). I use the form ONLY for the approve/delete member, so I don't have an email field for the form e.g. input name=email.

I can show you the complete file for this page of my script if you want to see where I may have gone wrong.

NogDog

Your code sample does not show anything that would create the $obj object. Also, when creating your message string, you may need to enclose your "complex" variables in curly braces (to help the parser know where the variable name begins and ends:

"Hello {$obj->username};

You have been approved approved by {$settings['admin_name']} to be an affiliate with {$settings['site_name']}.
...etc...";

Lastly, adding the following to the beginning of your PHP code may help to give you some more debug information:

<?php
ini_set("display_errors", 1);
error_reporting(E_ALL);

moonbrat

no matter what I do, I can't get it to email, I think it's because it's not correctly finding the $to part of my email code...which grabs the new approved member's email address from the database on approval....if I didn't have to send a welcome letter to my new approved member, I'd cut it out....

It's driving me bonkers >_<

I'm not getting any errors...it's just not sending....

NogDog

Where do define and populate $obj?

moonbrat

NVM fixed it. I found I had the $to reading in the wrong area so it couldn't send if it had nothing to read....

$to=$row->email wasn't sitting under the result, it was sitting under returned $result...works now ^_