Sending email via php script

[Skipper02]

I have written the following lines of code so that if a user forgets his/her password it can be retrieved from the database and mailed to the user at the email that is stored in the database. When I am executing the page I am getting the following error message:

Failed to connect to mail.studykitchen.com:465 [SMTP: Invalid response code received from server (code: -1, response: )]

My code is as follows:

<?php
if (isset($_POST['Email'])) {
$db_host= "localhost";
$db_user = "XXXX_YYYYY";
$db_password = "ZZZZZZ";
$db_name ="XXXX_StudyKitchenData";
$db = mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name, $db);
$userId = $_POST['Email'];
$sql = "SELECT Password FROM UserDetails WHERE Email = '$userId'";
$result = mysql_query($sql, $db);

// The above lines of code has been used in my other pages and it works fine

if (mysql_num_rows($result) == 1) {
require_once "Mail.php";
$from = "Webmaster-StudyKitchen<webmaster@studykitchen.com>";
$to = "'$userId'";
$subject = "StudyKitchen Password";
$body = "Your study kitchen password is '$result' ";
$host = "mail.studykitchen.com";
$port = "465";
$username = "webmaster@studykitchen.com";
$password = "AAAAA";

// I created the above password while creating webmaster mail account. This is not my cp password

$headers = array ('From' => $from,
'To' => $to,
'Subject' => $subject);
$smtp = Mail::factory('smtp',
array ('host' => $host,
'port' => $port,
'auth' => true,
'username' => $username,
'password' => $password));
$mail = $smtp->send($to, $headers, $body);
if (PEAR::isError($mail)) {
echo("<p>" . $mail->getMessage() . "</p>");
} else {
echo("<p>Your password successfully sent!</p>");
}
}
mysql_close($db);
}
?>

Please help!

I am a VodaHost customer and my domain name is www.studykitchen.com

Thanks

[navaldesign]

Re: Problem sending email via php script

Why do you need to use smtp authentication ?
And, you have code missing in rtreiving the password from the DB.

Use this:

<?php
if (isset($_POST['Email'])) {
$db_host= "localhost";
$db_user = "XXXX_YYYYY";
$db_password = "ZZZZZZ";
$db_name ="XXXX_StudyKitchenData";
$db = mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name, $db);
$userId = $_POST['Email'];
$sql = "SELECT Password FROM UserDetails WHERE Email = '$userId'";
$result = mysql_query($sql, $db);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$Password = $row[Password];
// The above lines of code has been used in my other pages and it works fine
if (mysql_num_rows($result) == 1) {
$mailto = $userId;
$mailsubject = "StudyKitchen Password";
$mailbody = "Your study kitchen password is '$Password' ";
$mailheader = "From: Webmaster-StudyKitchen<webmaster@studykitchen.com>\r\n"
. "MIME-Version: 1.0"."\r\n"
. "Content-Type: text/plain; charset=utf-8"."\r\n"
. "Content-Transfer-Encoding: 8bit"."\r\n"
. "X-Mailer: PHP v".phpversion();
if(!mail($mailto, $mailsubject, $mailbody, $mailheader))
{
echo "<p>Mail not sent for unknown reason </p>";
}
else {
echo"<p>Your password successfully sent!</p>";
}
}
mysql_close($db);
}
?>

Didn't test it, but it should work.

[Skipper02]

Re: Problem sending email via php script

General, unfortunately the code did not work. It echoed the statement, "Mail not sent for unknown reason". Could you please take a look at it?

Thanks so much!

[navaldesign]

Re: Problem sending email via php script

Sorry,

change to

$mailto = $userId;

I also added "From:" that was missing

[Skipper02]

Re: Problem sending email via php script

Navaldesign,

Hats off to you, Sir!! The code worked. Thank you so much.

Regards