Submit form, save in Database and email it also

keram617

One last question I hope

The same form from previous question, what I am trying to do is to have the info be inserted into a table but at the same time I want it to be emailed before or after it goes into the database. This way the person on the other end of it is aware of the data that went into the database, and they can do whatever they want with it.
I would like to have all field be emailed at the same time, format is not an issue.

Thank you again for your help

Mark

bradgrafelman

What specifically can or can't you do? It's not like PHP immediately clears out the $_POST array after you use it once, so simply do whatever INSERT'ing into your DB that you desire and then build an e-mail message (either using PHP's internal [man]mail/man or, for better functionality, a 3rd-party class such as Pear::Mail, PHPMailer, XPertMailer, etc. etc.).

keram617

Well
I can set it up so the data is saved into database after clicking on "submit" button, but what I would like to do is either right before it is saved into database or right after for that info (which was entered into the fields) to be emailed to specific email address.

bradgrafelman

So.. what have you tried? Like I said, it's as simple as building an e-mail message and sending it after (or before) the code that inserts the data into your database.

keram617

Honestly I have not tried anything yet since I am not sure which direction to pursue it.
Basically I dont know which method would be better and where could I find into as to how to implement it into my form.
I am fairly new to PHP, still learning.
Thank you for being patient with me

keram617

I have been looking on the web for this answer and so far I have had no luck with it

what I am really trying to do is to:
when you press the SUBMIT button to have the data that is in the fields be emailed to specific email address and then entered into a database so it is logged.

I have done it before with ASP but dont remember how I did it, I think it had something to do with three websites, one was the form, the other was the email and third was the data entry into database.

Thank you for any help

Mark

dagon

keram617;10958038 wrote:
Honestly I have not tried anything yet

Tried nothing and it doesn't work - are you surprised at this result? :rolleyes:

Sacreed

dagon;10958059 wrote:
Tried nothing and it doesn't work - are you surprised at this result? :rolleyes:

Lol, Dagon. At least hes asking 😃

keram617;10958038 wrote:
Honestly I have not tried anything yet

First off keram617, mess around with the mail() for a little bit(I mess around with coding for 1-2hrs) then tell us what you don't understand and post what errors your getting.

If you need a mail() tut go here: http://www.w3schools.com/php/php_mail.asp

The way I would set it up would be like this:
1. The information gets filled in.
2. It inserts the information into the database.
3. This is where the mail() comes in, this page saying: Thanks for filling out the form. Your information as been email to you, please click here(link) to log in.

P.S: Make sure to use the if,else statement to check if there is any unfilled out blanks so it won't automatically send them to the next page because then some of there information won't be sent..

Btw, to redirect someone if all there information is filled out it would look something like:

If ($Example !== "") 
{
header('Location: Page.php')
}
 else
{
echo 'You didn't fill in all the fields.';
}

Note: You will need to define your $example before the if and else statement.
That would look something like this:

$example = $_POST['example'];
If ($Example !== "")
{
header('Location: Page.php')
}
else
{
echo 'You did not fill in all the fields.';
}

keram617

dagon;10958059 wrote:
Tried nothing and it doesn't work - are you surprised at this result? :rolleyes:

It cracks me up how you focus on the first part of the entire line, and omitted tje second part, where I said that I dont know which way to start.
But oh well, guess some people just cant help themselves.

keram617

Sacreed
thank you for taking your time to point me in direction where i can start working on some stuff, I will be playing with this portion of the code now and see what results I get

Thank you for taking your time to reply

Keram

Sacreed;10958071 wrote:
Lol, Dagon. At least hes asking 😃

First off keram617, mess around with the mail() for a little bit(I mess around with coding for 1-2hrs) then tell us what you don't understand and post what errors your getting.

If you need a mail() tut go here: http://www.w3schools.com/php/php_mail.asp

The way I would set it up would be like this:
1. The information gets filled in.
2. It inserts the information into the database.
3. This is where the mail() comes in, this page saying: Thanks for filling out the form. Your information as been email to you, please click here(link) to log in.

P.S: Make sure to use the if,else statement to check if there is any unfilled out blanks so it won't automatically send them to the next page because then some of there information won't be sent..

Btw, to redirect someone if all there information is filled out it would look something like:
If ($Example !== "") 
{
header('Location: Page.php')
}
 else
{
echo 'You didn't fill in all the fields.';
}
Note: You will need to define your $example before the if and else statement.
That would look something like this:
$example = $_POST['example'];
If ($Example !== "")
{
header('Location: Page.php')
}
else
{
echo 'You did not fill in all the fields.';
} 

Sacreed

keram617;10958120 wrote:
Sacreed
thank you for taking your time to point me in direction where i can start working on some stuff, I will be playing with this portion of the code now and see what results I get

Thank you for taking your time to reply

Keram

No problem. If you need more help involving anything I gave you or need with errors just post them here and I will see what I can do to fix them for you 😃