Search the Community
Showing results for tags 'pearmail'.
Found 1 result
-
Hello I have a mysql database with filds like Name , DEPT ,and DOB the table name is emp and database name is EMPMASTER i have pear mail working script using gmail smtp and a Mysql query that shows todays birthday , My question is how to mix these two codes to mail output of that Mysql query in mail ? please suggest. following is the php code and my sql query. <?php // Pear Mail Library require_once "Mail.php"; $from = '<user@user.com>'; $to = '<user@user.com>'; $subject = 'Hi!'; $body = "Hi,\n\nHow are you?"; $headers = array( 'From' => $from, 'To' => $to, 'Subject' => $subject ); $smtp = Mail::factory('smtp', array( 'host' => 'ssl://smtp.gmail.com', 'port' => '465', 'auth' => true, 'username' => 'user@gmail.com', 'password' => '123@123' )); $mail = $smtp->send($to, $headers, $body); if (PEAR::isError($mail)) { echo('<p>' . $mail->getMessage() . '</p>'); } else { echo('<p>Message successfully sent!</p>'); } ?> SELECT * FROM emp WHERE MONTH(dob) = MONTH(NOW()) AND DAY(dob) = DAY(NOW());
