Jump to content


Photo

Send email after sign up


  • Please log in to reply
3 replies to this topic

#1 Eskimo

Eskimo
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 27 May 2006 - 07:48 AM

I have a form on my website linked to a MySQL database. The form works perfectly, adding the correct data into the rows. However, I want to add some PHP coding to automatically send an email to the person who signs up. In this email I would prefer several of the details they have supplied in the form to be included. Similar to what you receive when you sign up at certain forums, with your username, password and whatnot.

I have absolutely no idea how to do this, any takers? [img src=\"style_emoticons/[#EMO_DIR#]/huh.gif\" style=\"vertical-align:middle\" emoid=\":huh:\" border=\"0\" alt=\"huh.gif\" /]

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 27 May 2006 - 01:45 PM

Start by looking at the manual section for php's mail function - [a href=\"http://ca.php.net/manual/en/ref.mail.php\" target=\"_blank\"]http://ca.php.net/manual/en/ref.mail.php[/a]
Legend has it that reading the manual never killed anyone.
My site

#3 Eskimo

Eskimo
  • New Members
  • Pip
  • Newbie
  • 7 posts

Posted 28 May 2006 - 09:24 AM

I have managed to get an email send when the user clicks submit. However, I am having trouble adding into the email the autonumber that is generated for each field (the ID number). Since this is not a field the user types in the form I cannot just se a variable.

I think I need to use a query of sorts but I'm not sure which one. Ideas?

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 28 May 2006 - 05:28 PM

Retrieve the LAST_INSERT_ID() from MySQL into a PHP variable, and then make the necessary substitution in your e-mail template.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users