DBasics Web Address Book CGI Script

Listing of URLs

CGI Installation
& Customization
A listing of CGI programmers who have scripts available and may be available for both custom and installation work

A listing of CGI programmers who have scripts available and may be available for both custom and installation work

Programmer Listing
This is where programmers seeking outsourced jobs can list themselves which appears at http://www.getscript.com/programmers/

This is where programmers seeking outsourced jobs can list themselves which appears at http://www.getscript.com/programmers/

Programmer Signup

Request for Quotes

Customer Support

Customer Support

Tech Forums

View Recent Hits

Message Board
Hosting Service

Hosting Signup

Freebie Scripts

Server Error Script

Bad Link Finder

Environment $vars

Tutorials

Search Engine Tips

Other Services

Advertising Rates
Counter Service for those who cannot run CGI scripts on their own server

HWCounter Service
For those interested in earning 25� credit towards the purchase price of any of any our scripts by linking to GetScript, just cut and paste our coding on any of your pages. Then each time a visitor clicks on the link we will add another 25� credit to your current balance.

For those interested in earning 25� credit towards the purchase price of any of any our scripts by linking to GetScript, just cut and paste our coding on any of your pages. Then each time a visitor clicks on the link we will add another 25� credit to your current balance.

Link and Earn
A detailed report of when, who and where your links to us came from.

Link Reporting
We offer a extensive viewing of events Today in History for each day of the year including birthdays which are linked to InfoSeek.

Today in History
What type of script would be useful for your type of web site?

And Survey Said
Each day, 2,300 missing children are reported to local police and entered into the FBI's computer system.

Missing Children

CGI / Perl
Bookstore

[Click on Book]

Please Support Our Sponsor Above. Thanks!

[Home] [Company] [Hosting] [Scripts] [Support] [Forums]
[Purchase] [Freebies] [Tutorials] [Services] [Advertising]

Last Updated: Friday, 21-Jul-2000 14:22:50 EDT

Many sites would like to incorporate databases, such as address books, product catalogs, reference databases and such into their pages. More than likely you've been seeing prices of $600.00 or more for online database programs that are too cumbersome and technical to use. We have a script that is easy to install and works with comma delimited text formatted databases. Our Address Book script was designed specifically for use with thePro CD's Select Phone database export function but works with any popular database or spreadsheet exporting function supporting semi-colon delimited text exporting.

You should have previous experience in installing CGI scripts on your server. If you do not, you will most likely not be able to install this one. You should be able to FTP files and change the permissions of your files. You should also be familiar with the use of <FORM> tags and other common HTML elements.

Working Demo In Step 5

[Click Here] to purchase any of our [Scripts]!


[Go Here] or [Here] for Installation/Customizations! DBasics's Associate Programmers Available For Installation/Customization Needs.

For installation either email us or call (573) 374-2322

Download ZIP URL	/protected/address_book/addressbk.zip
Self-Extracting ZIP	/protected/address_book/addressbk.exe
Online Instructions	/database/
Technical Support	/support.html
Script Demo	/database/#DEMO

Estimated Installation Time: 15-30 Minutes

Step 2 - Address Book Database Format

If you are using Pro CD's Select Phone, this should be simple. Using the CD's export function, the formatting of the address book file is complete. But if you are putting your own database online, you'll need to make sure it's comma-delimited formatted as follows:


"name","address","city","state","zip","phone","other"
"Anchor Point","","Anchor Point","AK","99556",""
"Alaska Journal","","Anchorage","AK","99599",""
"Bank Of Commerce","PO Box","Anchorage","AK",""
"Anchorage Chamber Of Commerce","441 W 5th Ave",""

The following fields are to be included in the comma-delimited format:

Name - Company/Organizations Name
Address - Complete Street Address used in linking with MapQuest
City - Also used in linking with MapQuest
State - Also used in linking with MapQuest
Zip Code - Self-Explanatory
PHonE Number Must be formatted XXX-XXX-XXXX
Other This can be the SIC (Standard Industry Code) from ProCD, substitute with email address, web site URL's or use as a one line comment field.

Step 3 - Modifications To database.cfg

The address book database's physical path on your server
$database = "/usr/home/httpd/htdocs/database/chamber.dat";

The HTML <BODY> formatting including BACKGROUND and COLOR
$header = "<html> <head><title>Title of Your Address Book</title> </head><body BACKGROUND=/old?u=http%3A%2F%2Fgetscript.com%2Fdatabase%2F%5C&y=1999"http://www.yourdomain.com/images/backgrnd.gif\" BGCOLOR=\"#FFFFFF\" TEXT=\"#000000\" LINK=\"#005500\" VLINK=\"#550000\" ALINK=\"#000055\">";

The title line of the search and results screen and/or logo image placement using HTML <IMG SRC= /old?u=http%3A%2F%2Fgetscript.com%2Fdatabase%2Fformatting.%3C%2FFONT&y=1999>
$title = "<P><CENTER><H1>Title of Your Address Book</H1></CENTER></P>";

HTML formatted page footing. Recommended uses are return link formatting, image map menu bar placement, copyright/ disclaimer notes. When in doublt, use what you are currently placing at the bottom of your web site pages. The below illustrates the use of using an image maps menu graphics.
$footer = "<P><CENTER> <A HREF=/old?u=http%3A%2F%2Fgetscript.com%2Fdatabase%2F%5C&y=1999"http://www.yourdomain.com/image.map\"> <IMG SRC=/old?u=http%3A%2F%2Fgetscript.com%2Fdatabase%2F%5C&y=1999"http://www.yourdomain.com/images/menu.gif\" ISMAP></A> </CENTER></P>";

The OTHER field type: 1=email 2=webpage 3=searchfield 4=comments 5=blank The OTHER field is automatically HTML formatted to be linked if email or webpage url (1 or 2). If searchable field (3), will use the results from the <INPUT TYPE=RADIO NAME="OTHER" VALUE="criteria"> form. If left blank (5), there's no special formatting or display.
$otherfld = 5;

Step 4 - Install (FTP) The Scripts

It's now time to place the 3 files online. Be sure that the database.pl and database.cfg reside in the same directory. The database file is referenced in the $database variable in the database.cfg file so the location of the database may be other than the script.

Be sure you chmod a+x database.pl and chmod a+r database.cfg file. Also you should make sure that the database is world readable.

Step 5 - The Database Form

You can link directly to the database script without putting <FORM> tags on your page. You'll receive a generic entry form by linking directly to the script.

Working Demo: Here's the standard form fields: You can search by entering partial/complete criteria in any of the fields below. To search for local listing to you, it's recommended you enter either telephone area code or zip code. This particular DEMO will provide you a listing of Chambers of Commerce listings.

Name   : 
Address: 
City   :  State  Zip 
Phone #:  (Enter the 3 Digit Area Code)

NOTE: If you're using the "OTHER" field you can add a <INPUT TYPE=TEXT NAME=OTHER> field to the <FORM>

You may want to customize the form and place it on your page. By doing so, you can limit the search criteria your viewers enter.

<FORM> fields used should follow the following format:

<FORM METHOD=POST ACTION="/old?u=http%3A%2F%2Fwww.yourdomain.com%2Fpath_to%2Fdatabase.pl&y=1999"> - The <FORM> METHOD

<INPUT TYPE=TEXT SIZE=20 NAME="NAME"> - Name Field

<INPUT TYPE=TEXT SIZE=20 NAME="ADDRESS"> - Address Field

<INPUT TYPE=TEXT SIZE=20 NAME="CITY"> - City Field

<INPUT TYPE=TEXT SIZE=2 NAME="STATE"> - State Field

<INPUT TYPE=TEXT SIZE=10 NAME="ZIP"> - Zip Code Field

<INPUT TYPE=TEXT SIZE=3 NAME="AREACODE"> - Telephone Area Code Field

<INPUT TYPE=TEXT SIZE=20 NAME="OTHER"> - Optional Other Field

It's recommended that if you have a large database, that you not use the STATE field as a searchable field or the results returned might be too large.

We've Displayed Pages to Visitors Today.

(DBasics Software's ICQ# 4652929)