Use AJAX and PHP to Build your Mailing List
An elegantly designed site filled with engaging content is worth very little without an interested audience. An opt-in mailing list is one of the most effective methods of making contact with your audience and driving repeat traffic to your site. If visitors enjoy and trust your site, they’re likely to trust you with their email addresses — after all, they’ll want to be informed of new products, articles, or other relevant information. This is a great way to build relationships with your site’s users, and encourage them to come back to your site again and again.
In this article, we’ll learn to use AJAX to accept subscriptions to your mailing list without having to refresh the page; with this approach, your signup process will be quick and painless. Our AJAX sign up form will also be able to accept subscriptions from visitors who don’t use modern, AJAX-capable browsers.
This article assumes that your mailing list is stored in a MySQL database, but as long as you have the necessary code to add addresses to your own mailing list, it should be easy for you to adapt the code presented in this article to your own signup process.
The Big Picture
Our mailing list signup system has three key components:
- An HTML form inside a PHP page receives the visitor’s email address.
- JavaScript will listen for the form submission, which will trigger the AJAX call to the server with the email address.
- A simple PHP page on the server will receive the address. It will check the email address for errors, then store the address in a MySQL database. A success or error message will be sent back to the HTML page for user feedback.
We’ll also ensure that this signup functionality is accessible to all, by writing a PHP-based sign up for users who don’t have JavaScript enabled in their browsers.
To simplify the AJAX coding in our system, we’ll use the popular JavaScript library Prototype to listen for form submission, and to handle the AJAX messages. If you need a primer on Prototype, check out Dan Webb’s articlesPainless JavaScript Using Prototype and The JavaScript Library World Cup.
Form Proceeds Function
Our first step is to build the form that will receive the email address; then, we’ll connect to the JavaScript files to deliver the functionality. Here’s what the form looks like:
<form id="addressForm" action="index.php" method="get">
<fieldset>
<legend>Join our mailing list!</legend>
<p>
<input type="text" name="address" id="address" />
<input type="submit" value="Sign Up" />
</p>
<p id="response"><?php echo(storeAddress()); ?></p>
</fieldset>
</form>
The form itself is quite simple. We simply have a text field to accept the user’s email address, and a submit button to trigger the AJAX functionality. The ID of the form will be critical, as it will allow for our JavaScript to listen for a submission.
Notice in the form the paragraph that contains the output of a PHP function called storeAddress? This is the heart of our accessible signup form. When the page is loaded for the first time,storeAddress returns a single non-breaking space so that the paragraph appears empty. Later, when our AJAX functionality is triggered by the user’s submission of an email address, JavaScript will insert a message into this paragraph to let the user know what’s going on. Alternatively, if the user doesn’t have JavaScript enabled in the browser, the form will be submitted, which will cause this page to be loaded again. This action will cause storeAddress to be executed again. And this time, it will return a message for display inside the paragraph.
In the head of the page, we’ll link to the Prototype library with a <script> tag. We’ll also link to mailingList.js, which we’ll look at next:
<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/mailingList.js"></script>
The beauty of this setup is that structure of the page is totally isolated from its functionality, which makes development and maintenance hassle-free.
Using AJAX to Deliver the Address
Inside the js folder, alongside the prototype.js file, is a file called mailingList.js. This file contains the code that drives the AJAX functionality specific to this page. Our first item of business in this file is to add an event listener to the form element’s submit event, which will trigger the AJAX call to the server. However, we can’t do this straight away — we need to wait until the page is loaded, which is signified by the window object’s load event.
To add these event listeners, we’ll use Prototype’s convenient observe method. We first add a listener for the page’sload event. Inside this listener, we attach an event listener to our form’s submit event:
// Attach handler to window load event
Event.observe(window, 'load', init, false);
function init() {
// Attach handler to form's submit event
Event.observe('addressForm', 'submit', storeAddress);
}
Notice that the event listener for our form will call the JavaScript function storeAddress when the form is submitted. This storeAddress function contains the JavaScript to make an AJAX call to our PHP script. Here’s what it looks like:
function storeAddress(e) {
// Update user interface
$('response').innerHTML = 'Adding email address...';
// Prepare query string and send AJAX request
var pars = 'address=' + escape($F('address'));
var myAjax = new Ajax.Updater('response', 'ajaxServer.php', {method: 'get', parameters: pars});
// Stop form from submitting when JavaScript is enabled
Event.stop(e);
}
This function is very simple. It starts by letting the user that something’s going on by displaying an “Adding email address…” message. Next, we collect the information from the form in preparation for sending an AJAX request. Notice how we access the contents of the text field using Prototype’s $F function, which grabs the value of a given form element when supplied with that form element’s ID. We use the JavaScript escape function to convert the user input to Unicode format; this way, its URL is ready for delivery to the PHP script via the GET method.
Then comes the most important part of this function: the creation of a new Ajax.Updater object. When we create anAjax.Updater object, we pass it some parameters, including:
- the ID of the element in which you want to show the response from the server
- the URL of the PHP script
- the data you want to send to the server-side script, and the method of delivery (i.e.
POSTorGET)
The Ajax.Updater will send the email address to the server and wait patiently for a response. When it receives a response, it will display it in place of the “Adding email address…” message we inserted at the start of the method. Finally, we call Event.stop (another function supplied by the Prototype library) to stop the form from actually being submitted to the server.
Set Up your Mailing List Database
Before we can write any PHP to store email addresses, we need a place to put them. This SQL will build a table namedmailinglist for you:
CREATE TABLE `mailinglist` (
`id` INT NOT NULL AUTO_INCREMENT ,
`email` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
);
Included in the code archive is a PHP file called createTable.php, which will create this table for you. However, before you run this file, you’ll need to update the dbConstants.php file with the details of your MySQL database. I suggest you update this file now, as we’ll be using these constants in the next section.
Storing the Email Address
We’ve set everything up to deliver the address to the server; now PHP will finish up the process by storing the address in your database and returning a string to our Ajax object to indicate success or failure. Let’s take a look at theajaxServer.php file to which the email address is sent.
<?php
require_once("inc/storeAddress.php");
echo(storeAddress());
?>
This very simple PHP script calls a function called storeAddress and returns to the Ajax object the message that’s returned by storeAddress. Communicating with the Ajax object is as simple as printing a string.
The first thing storeAddress does is initialize a variable called $message to a non-breaking space. Then, it makes sure the script has received an email address in the query string. If it hasn’t, we’ll leave $message variable set as a non-breaking space. $message will be returned to the caller at the end of this function.
function storeAddress() {
$message = " ";
// Check for an email address in the query string
if( !isset($_GET['address']) ){
// No email address provided
}
Once we are certain we have an email address to work with, we’ll want to make sure it’s a valid address. We’ll use a regular expression to look for some alphanumeric characters followed by the @ symbol, more alphanumeric characters, a period, and some more alphanumeric characters. If this test fails, we’ll set $message to an error message, informing the user that the entered email address was invalid:
else {
// Get email address from the query string
$address = $_GET['address'];
// Validate Address
if(!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@
[a-z0-9-]+(\.[a-z0-9-]+)*$/i", $address)) {
$message = "<strong>Error</strong>: An invalid email address was provided.";
}
If the address passes this test, we’ll store it in the database. To do this, we connect to MySQL, select the database, and run our INSERT query. If the address was stored properly, we set $message to a success message; otherwise, we set $message to an error message.
else {
// Connect to database
$con = mysql_connect(DBHOST ,DBUSER, DBPASS);
mysql_select_db(DBNAME, $con);
// Insert email address into mailinglist table
$result = mysql_query("INSERT INTO mailinglist SET email='" . $address . "'");
if(mysql_error()){
$message = "<strong>Error</strong>: There was an error storing your email address.";
}
else {
$message = "Thanks for signing up!";
}
}
Finally, we return $message to ajaxServer.php:
} return $message; }
Now, load the page, enter your email address, and submit the form — you should see your email address added to themailinglist table without the page reloading. Even if you disable JavaScript, the page will work in a very similar fashion, except that instead of inserting the output of storeAddress into the page dynamically using JavaScript, it’s inserted directly into the HTML in the page’s PHP code.
AJAX really makes signing up for your mailing list a piece of cake. There’s no waiting for the page to reload, which interrupts your visitor’s browsing experience, and there’s no need to exclude those who browse with JavaScript disabled. Prototype makes the process of building AJAX functionality quick and painless, allowing you to keep in close touch with your site’s fans.





Google…
[...]although sites we backlink to beneath are considerably not connected to ours, we really feel they’re essentially really worth a go by means of, so possess a look[...]…
A Blog links to your post…
[...]Just gоt а Blogger account, it works good, so hоw must i find differеnt users blogs I love wіth search. From thе there's а way, however am not ѕeeing it now. Thanks fоr your help.. [...]…
Links…
[...]Sites of interest we have a link to[...]……
Websites you should visit…
[...]below you’ll find the link to some sites that we think you should visit[...]……
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
Related……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Another Website likes your page…
[...]one of оur visitors recently recommended the examples belоw website[...]…
Super Cheap Yankee Candles…
[...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]…
Dreary Day…
It was a dreary day here today, so I just took to messing around on the internet and found…
Discount Yankee Candles…
[...]while the sites we link to below are completely unrelated to ours, we think they are worth a read, so have a look[...]…
TV Lamps…
The Truth behind Television Replacement Lamps….
You should check this out…
[...] Wonderful story, reckoned we could combine a few unrelated data, nevertheless really worth taking a look, whoa did one learn about Mid East has got more problerms as well [...]……
adult social networking…
[...]here are some links to sites that we link to because we think they are worth visiting[...]…
Super Cheap Yankee Candles…
[...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]…
Sites we Like……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
Buy California Exotic Novelties…
[...]the time to read or visit the content or sites we have linked to below the[...]…
Latest news from all around the world, you need to see this !…
[...]blow are some sites that we think it will be helpful and fun to read[...]…
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
Fast Snoring Cures…
[...]there are tons much more 100 % free inbound links to get provided, that you can discover from adhering to[...]…
Great Clips Coupons…
[...]in the following are several web links to online websites I always connect to seeing that we feel they will be really worth visiting[...]…
Found=> recommended your blog…
[...]The information mentioned while іn the article are ѕоme of thе bеѕt availаblе [...]…
buy damansara house…
[...]you will find information that’s relevant to you if you want to buy damansara house[...]…
Links…
[...]Sites of interest we have a link to[...]……
Cure For Tinnitus…
[...]below you’ll find the link to some sites that we think you should visit[...]…
best webhosting…
[...]This could be a nice addition for our blog thanks[...]…
Basketball Drills…
[...]the time to read or visit the content or sites we have linked to below the[...]…
Love It…
nice job much thanks for taken the time to post this info on this blog please keep Up thank you i will visit again…
Gems form the internet……
[...]this is the end of this article. Here you’ll find some sites that we think you’ll appreciate, follow on the links over[...]……
Dreary Day…
It was a dreary day here yesterday, so I just took to messing around online and found…
New ideas ? Great Ideas ? Best Ideas ?…
[...]below you’ll find the link to some sites that we think you should visit[...]…
Found=> New Backlink…
[...]I аm loоkіng bоth for blogs that offer unbiased, balanced commentary on all issues оr blogs that сontаin а liberal оr left-wing slant. Many thаnkѕ.. [...]…
Ipad Stylus…
[...]down the page are several references to websites online which I link to as we believe they’re seriously worth visiting[...]…
Looking around…
I like to browse around the online world, regularly I will go to Digg and follow thru…
Yahoo results…
While browsing Yahoo I found this page in the results and I didn’t think it fit…
Wikia…
Wika linked to this website…
Websites…
[...]%BLOGTITLE%[...]…
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Scratching my head…
A bit of a head scratcher, but overall, an excellent blog post….
Latest chinese tea info ? Hotest tea news ?…
[...]while the sites we link to below are completely unrelated to ours, we think they are worth a read, so have a look[...]…
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Gaziantep Oto Kiralama…
In any case I’ll be subscribing to your feed and I hope you write again soon!…
Genial brief and this post helped me alot in my college assignement. Thank you for your information.
Its our pleasure to known, our site helpful for you.
I would like to exchange links with your site http://www.sourcencode.com
Is this possible?
carisoprodol no rx Polly
xanax 2mg online PhotoShare
tramadol no rx flawlessly
generic viagra online FAQPengenalan
cheap Ultracet online no rx saturday delivery hospitals
tramadol depart
buy Testosterone online canadian no script voice
soma overnight
no rx soma instead
tramadol no prescription shares
cheap meridia online produces
adderall withdrawal consist
tramadol overnight
valium express 00011
pharmacy soma Cason
Percocet withdraws CM9355
cheap ambien cyber