jponte Posted February 4, 2010 Share Posted February 4, 2010 Hi, I'm very new to PHP and MySQL but I was thrown into this project. I was able to figure most of it out and I'm able to pass all object from the HTML form to arrays in PHP and then send them to the MySQL DB. They now ask me they want the info in the DB but also they want the same info emailed. What is the best way to go about that: - From the form email abnd then add to DB - From the form Add to DB and then email confirmation with the info The second seems to most logic as I already have everything going from the form to the DB. However, I do not have an SMTP server running in the server so I do not know how to send the email. I have the script FormToEmail.php but I do not know if it can be used. Thanks for your help. Jack P Link to comment https://forums.phpfreaks.com/topic/190982-send-form-data-to-mysql-and-to-email/ Share on other sites More sharing options...
schilly Posted February 5, 2010 Share Posted February 5, 2010 id go with the second option and send the email if you successfully enter the info into the db. use the mail function in php to send the email. www.php.net/mail most servers should have the mail function set up. Link to comment https://forums.phpfreaks.com/topic/190982-send-form-data-to-mysql-and-to-email/#findComment-1007128 Share on other sites More sharing options...
Hussam Posted February 5, 2010 Share Posted February 5, 2010 The second option is more logical because the data may not be entered for whatever reason. I will actually send the data to the database first. then I will grab it again just to make sure lol, I am kinda nerd, then I will collect the data in an HTML format and put it in the message variable and send it to the email I need using mail() function. This example is from php.net and it works just fine: <?php // multiple recipients $to = '[email protected]' . ', '; // note the comma $to .= '[email protected]'; // subject $subject = 'Birthday Reminders for August'; // message $message = ' <html> <head> <title>Birthday Reminders for August</title> </head> <body> <p>Here are the birthdays upcoming in August!</p> <table> <tr> <th>Person</th><th>Day</th><th>Month</th><th>Year</th> </tr> <tr> <td>Joe</td><td>3rd</td><td>August</td><td>1970</td> </tr> <tr> <td>Sally</td><td>17th</td><td>August</td><td>1973</td> </tr> </table> </body> </html> '; // To send HTML mail, the Content-type header must be set $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; // Additional headers $headers .= 'To: Mary <[email protected]>, Kelly <[email protected]>' . "\r\n"; $headers .= 'From: Birthday Reminder <[email protected]>' . "\r\n"; $headers .= 'Cc: [email protected]' . "\r\n"; $headers .= 'Bcc: [email protected]' . "\r\n"; // Mail it mail($to, $subject, $message, $headers); ?> Link to comment https://forums.phpfreaks.com/topic/190982-send-form-data-to-mysql-and-to-email/#findComment-1007320 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.