Email sign up box?

Could someone please show me or point me in the right direction on how to put a simple email sign up box on my website, all i want is name and email address?
Thanks in Advance

If you just want a point in the right direction (rather than a step-by-step), your best bet would be to use PHP and MySQL. If you've got some cheapo hosting (like we all do ), then 99% chance you've already got all you need.

Make a new MySQL table with fields ID, Name, Email.
Make a form with two input boxes and a submit button, with the form POSTing off to another page (or the same page - up to you!).
Take the POSTed data, and INSERT it into your table.

Reply if you'd like it in more detail, sounds like you're willing to learn though.

wow, I'm kind of new to this, I'm in the UK and have a little website which gets about 200 visitors a day and would quite like to get hold of email address so that I can send info every so often. I use Dreamweaver and am very much a novice

where do i start with a MySQL table?

thanks

##--[ SQL ]--##




##--[ HTML FORM ]--##




##--[ PHP ]--##



That is a very rough example and any info in CAPS should be changed by yourself. The PHP should be saved to a file called process.php and saved in the same directory as your form.

thanks for that
where does the sql code go?
thanks

if you have PHPMyAdmin then you can put it in the code box to create the table, or you can put it in a php script like this



and then just run that script one time, and the table should be there.

As stated, if you using PHPMyAdmin you can use the SQL command prompt to create the table from there.

Personaly that is the best and easiest way to do it.

thanks guys

I've used the html bit but there is no submit button?

Lol, woops ...

goodness do you sleep?

Thanks for that

which bits of the php do i have to change

sorry for being a simpleton

I have my SQL table and i have my HTML and have the php but not working
i guess i need to correct something on php?

currently get this message

Parse error: syntax error, unexpected $end in /home2/shareth/public_html/Free/process.php on line 25


Thanks

Yes, but only when I`m at work ...


Paste the code from your process.php file, as the code I gave did not contain a variable $end.

You will need to amend the following:

username for your DB - name you use to log into PHPMyAdmin
DB name - the name of the DB not that table
DB pass - password you use to log into PHPMyAdmin

hopefully one last thing my username

is that
1) the username i use to get into my general control panel (when i go from control panel into sql it doesn't ask for user and password)
2) or the username i set up inside SQL
and i guess the same goes for password

I really appreciate your help
thanks

The username and password that you need to place into the PHP code is the username and password you set up "inside SQL" as you put it, otherwise known as phpMyAdmin.

No worries, let us know if you get stuck.

this is my php obviously changed the passwords and usernames to protect the innocent - still getting error

<?PHP

$db_host = 'localhost';
$db_user = 'str';
$db_name = 'str_STR';
$db_pass = 'str';

$db = mysql_connect("$localhost", "$str", "$str")
or die ("Error connecting to database.");

$connect = mysql_select_db("$str", $db)
or die ("Couldn't select the database.");


$email = $_POST['email'];
$name = $_POST['name'];

if(!empty($email) && (!empty($name))) {
$query = mysql_query("INSERT INTO email addresses (email, name) VALUES ('$email', '$name')")
or die ("Could not insert new data : " . mysql_error());

echo ("THANKS FOR YOUR SUBMISSION !");

?>