how to send a mail to users with their password at a time

[harsha.netpem]

Hello,
I have created the login page and I have imported the excel sheet of 10000 email id’s with their password in mysql. I have created the Password by a script.
So, I need to send the password to all users with welcome message and login link.
So could you please give me the solution for how to send a mail to 10000 users with their password at a time?

[leviathan185]

have you attempted it on your own already? post your code...

[harsha.netpem]

No

[radow]

For mailer, you can use PHPMailer

[leviathan185]

Nobody will just give you the solution. You will at least need to attempt it by yourself first. Google has many tutorials out there. Learning something for yourself that you need to acheive is the best way to learn.

If then you are stuck let us know what exactly you are having trouble with.

[mmcdonald]

You can do this just using PHP and SQL but no one will just give you the code.

I can recommend this link: http://www.htmlgoodies.com/beyond/php/article.php/3855686/PHP-Mailer-Script-Step-by-Step.htm

It takes you through creating a mailer script step by step explaining every step of the way.

You need to connect to your SMTP server and send the emails in a loop. In each loop you are going to need to collect the recipients email address, username and password.

Have fun and good luck!

[mmcdonald]

You can revise this tutorial: http://www.computersneaker.com/php-mail-script/

[minitauros]

I think you're looking for something like this (still to be worked out, of course):

<?php
for($i=0; $i<count($records); $i++)
{
    $record = $records[$i];

    // Set data.
    $password = $record['password'];
    // etc...

    // Mail the user his login info.
    mail(...);

    // You're done!
}

[pritaeas]

@minitauros: Although correct, I don't think most hosts will allow you to send that many emails in such a short period.