Mailing List in PHP
In this section we will create a form for the user
to fill in and also we will create a script to log the
results into our email database . So without any further
ado lets create our form.
Here is the code .
<form action = "joinnewsletter.php"
method = "post">
<table>
<tr><td>
Name : </td>
<td><input type = "text" name = "name">
</td></tr>
<tr><td>
Email :
</td>
<td><input type = "text" name = "email">
</td></tr>
<tr><td>
<input type = "submit" value = "join"></td>
<td><input type = "reset" value =
"clear"></td></tr>
</table>
</form>
Which will produce our form . Now we will store the
user submitted details into our database . Call this
joinnewsletter.php and enterthe following code .
<?php
//make a connection
$connection = mysql_connect("localhost" ,
"iainhendry" , "iain06")
or die("cannot make connection");
//select our database email
$db = mysql_select_db("email" , $connection)
or die("cannot find database");
//insert the values of our form into our database
$sql_query = "INSERT INTO email VALUES (\"$name\",\"$email\")";
$results = mysql_query($sql_query);
//display a thank you message and a link
echo ("Thank you for subscribing to our newsletter<br>");
echo ("<a href = 'index.htm'>Back to index
page</a>");
?>
Now enter some data in the form and press submit (preferrably
valid data) . Now we will check our table using MySQL
, at the command prompt enter this .
SELECT * FROM email;
Here was what was displayed when I entered a coupl
of my ffa submission emails addresses.
As you can see the email addresses and name has been
added.
<Top
| Back
|
