Mailing List in PHP
This example will show how to create a database , then
create a table in this database and then log a users
email address and name in the database . This will be
the basics of creating a newsletter system using PHP
and MySQL.
First of all we will create our database using MySQL
, enter the following at the command prompt.
CREATE DATABASE email;
USE email;
CREATE TABLE email(id int DEFAULT'0' NOT NULL auto_increment,
name VARCHAR(75) , email VARCHAR(50),
PRIMARY KEY(id));
Now we will check that everything is Ok by entering
the following
DESC email;
That is perfect just what we are looking for , in the
next part we will create our form that users fill in
and also the script for storing this information in
our database.
<Top
| Back
|
