Email submit to database
- Thread starter jamesyboy
- Start date
Just a snippet u can worked with:
You can put everything in one .php-file, just copy & paste it.
It doesn't check if someone posts a valid email adress so don't use it on a live-system!
Greetz
PHP:
<?php
if(isset($_POST['mail'])) {
mysql_connect('<YOUR HOST>', '<YOUR DB-USER>', '<YOUR DB-PASS>') or die ('Connection Error');
mysql_select_db('<YOUR DB-NAME') or die ('Couldnt select DB');
$mail = mysql_escape_string($_POST['mail']);
$query = "INSERT INTO mail (id, mail) VALUES (NULL, '$mail')";
mysql_query($query);
header('Location: <YOUR THANK-YOU-PAGE>.php');
} else {
echo '<p>Please insert your email.</p>';
}
?>
HTML:
<form action="" method="post" name="formular">
<fieldset><label>Enter Mail</label><input type="text" maxlength="25" name="mail" value="" /></fieldset>
<input type="submit" name="send" value="Submit email" />
</form>You can put everything in one .php-file, just copy & paste it.
It doesn't check if someone posts a valid email adress so don't use it on a live-system!
Greetz
Last edited:
RootShellvb
Junior Member
- Jan 29, 2009
- 188
- 217
Yup, use JS
string.match() to be sure that the text submitted is an email
string.match() to be sure that the text submitted is an email
seeplusplus
Power Member
- Aug 18, 2008
- 525
- 179
Make sure you filter what the user inputs a great deal, very dangerous without.