formfields.com

[formfields]

This tutorial assumes that you already have a web hosting account with PHP and that you have completed the setup instructions at http://www.formfields.com/FORMfieldsArea/tutorial1.php

In this tutorial we will create series of simple forms that will collect a Name and Email address from a new contact, store this information in your database and also send this information to you in an email. For this example, we will assume that your website domain name is www.mysite.com and that your email address is info@mysite.com.

--------------

CREATING THE FORMS AND DATABASE TABLE:
- Go to http://www.formfields.com/FORMgenArea
- Click Next.
- Step 1: click Next.
- Step 2: Enter New Contact and click Next.
- Step 3: click Add Field.
- Select Field Type: PersonNameField, Name: name, Label: Person's Name, Required: REQUIRED, Field Help: Please enter your complete name. Then click Save.
- Click Add Field.
- Select Field Type: EmailAddrField, Name: email, Label: Email Address, Required: REQUIRED. Then click Save.
- Step 4: click Next.
- Step 5: enter On Submit Email the Form To: info@mysite.com, check On Submit Insert Form Data Into Database. Optional: check On Submit Display Confirmation Screen. Click Next.
- Step 6: Click to download newcontact.php, newcontact_table.sql, create_newcontact_table.php, and cp_newcontact.php to your local hard drive.
- Use an FTP client to upload newcontact.php, newcontact_table.sql, create_newcontact_table.php, and cp_newcontact.php to www.mysite.com in the directory /FORMfields/forms/. (Please see http://ftphelp.secureserver.net/index.html for tutorials on how to use FTP clients. You can download most of these FTP clients for free by doing a google search for each FTP client).
- Visit http://www.mysite.com/FORMfields/forms/create_newcontact_table.php
- Use an FTP client to delete http://www.mysite.com/FORMfields/forms/create_newcontact_table.php
- Now you can put a link on your website to the form at http://www.mysite.com/FORMfields/forms/newcontact.php. Also, you, the administrator, can use http://www.mysite.com/FORMfields/forms/cp_newcontact.php to administer your database data for this form.

[formfields]

EXPORTING DATA:

Adding Test Data:
- You can use the form at http://www.mysite.com/FORMfields/forms/newcontact.php to submit data just like a regular user would. Or, you can go to http://www.mysite.com/FORMfields/forms/cp_newcontact.php and click on New Record to insert data as an administrator.

Exporting The Data:
- Go to http://www.mysite.com/FORMfields/forms/newcontact.php and click on Click here to download newcontact.txt. Then save this file to your local hard drive.
- Open MS Excel and select File->Open and open vernonsgrocerycomregistration.txt. Click Next, Next, Finish.
- Some values may show up as "#####" or may appear to be incorrectly formatted. To fix this, just increase the width of the column accordingly.

[formfields]

IMPORTING DATA:
- Go to http://www.mysite.com/FORMfields/forms/newcontact.php and click on Click here to download newcontact.txt. Then save this file to your local hard drive.
- Open MS Excel and select File->Open and open vernonsgrocerycomregistration.txt. Click Next, Next, Finish.
- Some values may show up as "#####" or may appear to be incorrectly formatted. To fix this, just increase the width of the column accordingly.
- Edit your file and then click File->Save and then Yes.
- Go to http://www.mysite.com/FORMfields/forms/newcontact.php and browse for newcontact.txt in the Upload Field box. Then click Upload Now.