If you need any help with any of this, just say so.
First things first. You will need a table in MySQL with the columns:
id, firstname, lastname, email.
The ID column needs to be set as unique, primary key and auto_increment. They all need to be not_null.
Then you will need an input form. I have prepared a very simple noe - feel free to expand on it:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Sign up for our Newsletter</title>
<style type="text/css">
#labels {
position:absolute;
line-height:1.5;
}
#inputs {
position:absolute;
left:8em
}
#all {
position:absolute;
top:75;
}
</style>
</head>
<body>
<h1 align="center">Sign up for our Newsletter</h1>
<form action="news.php" method="POST">
<span ID="all">
<div ID="labels">
<LABEL for="first">First Name</LABEL><br>
<LABEL for="last">Last Name</LABEL><br>
<LABEL for="email">Email Address</LABEL><br>
</div>
<div ID="inputs">
<input name="first" id="first" class="values" type="text" value=""><br>
<input name="last" id="last" type="text" class="values" value=""><br>
<input name="email" id="email" type="text" class="values" value=""><br>
</div>
<span>
</form>
</body>
</html>
Next, you need the PHP script to actually insert the information. Here's mine. Please note that this does not validate anything.
<?php
if ($email) {
$first = addslashes($first);
$last = addslashes($last);
$username="";
$password="";
$database="";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
//gets id
INSERT INTO newsletter (id, firstname, lastname, email) VALUES ("", $first, $last, $email);
mysql_close();
}
?>
If this will initiate any processing by the server that could be a security risk, can someone please mention it. I'm pretty sure it won't, but its always better to have a second opinion (Dave?)
Once you've uploaded these two pages, you should be able to add email addresses. Do you need a script to send the emails too?