[SOLVED] POST to mysql database and email results?

[theredking]

Hi, I have a simple html form that POSTs to a mysql database. Can I, and if so, how can I, have it post to the mysql database, and email the form results too.

 

I also have some other html forms that just mail() the results. So I can do both things separately, but I'm not sure how to combine them.

 

I'm still very new to all this...

 

Thank you in anticipation.

[micah1701]

just run them one after the other...something like:

 

<?php

// 1) your script to save everything to database...
...

// 2) then your script to mail the data to someone

$body = print_r($_POST,true); //you'll want to expand on this, but something like:

mail("[email protected]","POST DATA FROM SCRIPT",$body,"FROM: [email protected]");

?>

[roopurt18]

You realize this is a lot like asking, "How can I put on my shoes and tie them too?  I can put on my shoe.  I can also tie my shoe if it's already on my foot.  But I just can't seem to combine them."

 

Basically, you create a form.  On the page that processes it you add code that puts it in the database.  Then you add more code that emails the results.

[theredking]

You realize this is a lot like asking, "How can I put on my shoes and tie them too?  I can put on my shoe.  I can also tie my shoe if it's already on my foot.  But I just can't seem to combine them."

 

Yeh I do realise... But being so new to this, it's a little like trying to put a shoe on and tie it whilst upside down in a dark room, being spun around, and people are poking you with sticks...

 

I'm trying, it's just hard to get my head around combining these things.

 

Thanks

[theredking]

just run them one after the other...something like:

 

<?php

// 1) your script to save everything to database...
...

// 2) then your script to mail the data to someone

$body = print_r($_POST,true); //you'll want to expand on this, but something like:

mail("[email protected]","POST DATA FROM SCRIPT",$body,"FROM: [email protected]");

?>

 

Thank you, I'll give this a go!

[theredking]

Thank you micah1701, that works perfectly!!