My Address Book SQL (version 1.1)

Please read everything but email me if
(1) you do not understand
(2) you get it running (so I can check it out and put up a link to your site)
In this README:
REQUIRES    back to top
  • 1. web server (only tested on UNIX and LINUX)
  • 2. Perl 5.8.0 (may work with others)
  • 3. MySQL
  • 4. DBI perl module
  • SUMMARY    back to top
    This Address Book script is meant to be a single-user address book, capable of holding information about the user's friends and family, such as addresses, phone numbers, email addresses, webpage, and notes about the contact. This can be used as a multi-user list, like a member directory, but there is only one username and password for changing information (adding and editing contacts). It is more suited to be a directory for viewing only by members, to be maintained by a single admin.
    FEATURES    back to top
  • Add an unlimited number of contacts.
  • Easy to use and read.
  • Specify your own colors.
  • Use your own template.
  • DISTRIBUTION / LICENSE    back to top
    This software is released under the GPL. Please see the included LICENSE file. Copyright (C) 2003 Erin Spiceland This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Use this script at your own risk! I make no warranties that it is hack proof!
    INSTALLATION    back to top

    Installation is easy:

    1. Put all of these files under your cgi-bin (or other executable web directory). If you just unzip the zip file inside the cgi-bin folder, it will create a classifieds folder inside the cgi-bin directory.

    2. Now give all cgi and pm files executable permissions. To do this from commandline on a UNIX/Linux server, do "chmod 755 *.cgi protected/*.cgi". If you do not have commandline access or are on a Windows server, you should have access to a control panel of some sort which will allow you to change the permissions of these files.

    3. Edit lib/ to match your needs. This file holds all the information about My Address Book that might vary from server to server. It also has many options like fonts and colors that you can change to customize your site. There are several things that are very important for you to change if you want My Address Book to work. The names of these variables are $database, $database_user, and $database_password. It is essential that you find out from your admin your database name, user, and password for this script to work.

    4. You may need to modify the first line of index.cgi to point to where perl is located on your server.
    #!/usr/bin/perl (most common)
    #!/soft/script/bin/perl (for users in
    5. Create your MySQL table. You can do this from commandline using this command from within the cgi-bin/addressbook folder:
    $ mysql <your database name here> < makecontactstable <hit enter here>
    You're done!
    Fire up your browser and point it at the index.cgi script. Good Luck! Email me if you use it!
    HOW TO USE    back to top

    Just point your browser at it. Click "View All" to view all contacts at the same time, or choose a letter to view all contacts with last name starting with that letter. Click "Add Contact" to add a new contact.


    If you get an internal server error, run it from command line so that you can see what is going wrong by doing this:

    [erin@fuzzymonkey] $ ./index.cgi
    Looking at the output of this command can often give a hint at what is going wrong. If the permissions are wrong, you'll often get "bash: ./index.cgi - Permission denied." When emailing for help, be sure to include the output of this command in order to give us a better idea of what is happening.
    CHANGES    back to top

    10.12.2003 Version 1.1 Fixed a bug that messed up the display of search results.

    09.14.2003 Version 1.0 First release of My Address Book!

    TODO    back to top
    I need to do/need help with the following items
  • Add capability for letting each contact update their own listings, but no other listings.
  • Anything else you want me to add... just email me.
  • Send questions or comments to

    Mike and Erin Spice