Announcement

Collapse
No announcement yet.

Sending email via php script

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sending email via php script

    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

  • #2
    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.
    Navaldesign
    Logger Lite: Low Cost, Customizable, multifeatured Login script
    Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
    DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
    Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

    Comment


    • #3
      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!

      Comment


      • #4
        Re: Problem sending email via php script

        Sorry,

        change to

        $mailto = $userId;

        I also added "From:" that was missing
        Navaldesign
        Logger Lite: Low Cost, Customizable, multifeatured Login script
        Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
        DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
        Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

        Comment


        • #5
          Re: Problem sending email via php script

          Navaldesign,

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

          Regards

          Comment

          Working...
          X