Storing users contact info

Storing users contact info

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.

Back to index , Forward to section 2