Ajax Poll Script
Ajax Poll Admin
Ajax Poll DX
Address Book Script
Form2DB
PayPal IPN + eProduct Delivery Script
Ajax Likes-Dislikes Counter
Text Ad Script
Lead Follow-Up Database Script
Ajax ContactUs Script
URL Shortening Script
AdFreely -Ad Board Script-
Protect HTML Script
Fade-In Slideshow

Address Book Script

Ver 1.18 ( Security patch applied )
AB201-118

Download
Address Book
Address Book
  • First Name
  • Last Name
  • Company
  • Tel
  • Fax
  • Cell
  • Email
  • Street1
  • Street2
  • City
  • State
  • Zip
  • Address Book Mini
    Address Book Mini
  • First Name
  • Last Name
  • Department
  • Contact Email
  • Telephone Number
  • Contact Book Mini
    Contact Book Mini
  • Full Name
  • Full Address
  • Mobile No
  • Email ID/ Facebook ID
  • Comments
  • Company Directory
    Company Directory
  • Business Name
  • First Name
  • Last Name
  • Tel
  • Cell
  • Email
  • Street1
  • Street2
  • City
  • State
  • Zip
  • Country
  • Note
  • Customer List
    Customer List
  • First Name
  • Last Name
  • Home Phone
  • Home Phone2
  • Mobile Phone
  • Other Phone
  • Primary Phone
  • Business Phone
  • Anniversary
  • Birthday
  • Categories
  • Email
  • Email Display Name
  • Home Street
  • Home Street2
  • Home City
  • Home State
  • Home Zip
  • Note
  • Year
  • ... 2 more fields
    : Scripts generated by Address Book Script Builder
    : Scripts generated by Form2DB Builder

    This is a free Address Book PHP script with a MySQL database. This script allows users to search, view, add, edit, and delete address entries from a web browser. Each user can have a different login username.

    It's very easy to add/remove fields to/from the script. In fact, I've seen others using this script to store something totally different from addresses.

    You can customize Address Book Script online and/or manually.

    To manually customize it, please see Customization Quick Guide.

    To customize online, use Address Book Builder, which guides you through the steps of building a custom version of Address Book Script. To start Address Book Builder, click this link.

    License

    GPL

    Demo

    Installation Guide

    Quick Feedback to Tom, the developer

    If you have any suggestions or find any problems, please leave them as a comment down below. we'd appreciate the feedback!

    Name:
    Subject:
    Comment:
    Email: (Will not appear online)
    Posted by Matteo
    1418829662

    Use this simple and fantastic script for the management of tourism facilities in Italy. I wanted to know if the number of contacts that can be put to max 9999 or I can go further. Thank you very much
    Posted by Tom
    1419087659

    >I wanted to know if the number of contacts that can be put to max 9999 or I can go further.

    If you mean the maximum number of records you can put into the script, then there is no limit.

    OK, ... Read More
    Posted by Jorma Hytönen
    1418655979

    So, If I copy all button images from staff/images/buttons/eng/ to staff/images/buttons/fin and make new button images include Finish language. Where I can tell AddressBook to find new images? In case ... Read More
    Posted by Tom
    1419087434

    >In case that I do not want overwrite English button

    Please just overwrite English buttons. You can always get the English buttons from the zip package and restore them in the folder.
    Posted by Jorma Hytönen
    1418652372

    How can I use custom CSS? So, change look and feel from blue something else. Is there anything else that modify page.css and repaint all buttons.
    Posted by Tom
    1419087264

    >Is there anything else that modify page.css and repaint all buttons.

    No. That's all you need to do!
    Posted by Mike
    1418641097

    Hello. I just created my phonebook script with your builder. But if it possible how can i do so that everyone can enter to contacts and see their information without login, but just administrator ... Read More
    Posted by Tom
    1419087121

    To remove the login feature, please read the following article:

    http://www.phpkobo.com/article--m2635
    Posted by mercy
    1418599819

    please tell me i dont want guests to change anything on the database what do i do?
    Posted by Tom
    1419086896

    To prevent non-administrators from adding/editing/deleting records, open web/staff/app/cls_ps_(--table-name--).inc.php and add
    if ( !$this->sys->IsAdmin() ) exit;
    after
    case 'edit_inp':
    The ... Read More
    Posted by Jeppe Jensen
    1418593567

    Hi Tom

    Couldnt find out how to reply - so put my thanks here:
    Thanks for a great script, for making it public and for helping with the question! It works perfect now :-)

    best regards and a happy ... Read More
    Posted by Tom
    1419086608

    You are welcome :)
    Posted by don
    2014-12-09

    (1064) You have an error in your SQL syntax near 'NAMES utf8' at line 1
    Sorry, you got an error. Please check your database settings and click Setup again.
    Posted by Tom
    1419086196

    >You have an error in your SQL syntax near 'NAMES utf8' at line 1

    It shouldn't happen. There seems to be some problems in MySQL server. Probably, nothing is working there. Ask your web administrator ... Read More
    Posted by Corey
    2014-12-08

    i corrected my errors in the question to make more sense.

    Thank you for you your time and effort in developing this wonderful resource.

    My question:

    on the edit contact page ... Read More
    Posted by Tom
    2014-12-12

    This article explains how to get a plain text (instead of an input box) on detail page:

    http://www.phpkobo.com/link--m2072
    Posted by Corey
    2014-12-06

    Thank you for you your time and effort in developing this wonderful resource.

    My question:

    on the edit contact page (tpl.contacts.detail.inc.php) i have added a separate ajax Facebook style ... Read More
    Posted by Jeppe Jensen
    2014-12-03

    Hi

    Thanks for a very nice script!!

    I am trying to adjust the out of members search and details view by using the suggestion given here: http://www.phpkobo.com/link--m2072

    It works perfectly in my ... Read More
    Posted by Tom
    2014-12-12

    In search page, please use the following code to display raw text.
    <?php echo $hm->Zb('rs:def:medlemsnummer='); ?>
    Notice that there is '=' after rs:def:medlemsnummer
    Posted by Carlo
    2014-12-03

    Hi Tom
    i want to show Zero result , when i get the first page means after logging .
    Posted by Tom
    2014-12-12

    >i want to show Zero result , when i get the first page means after logging .

    It's been requested several times. I really want to write a tutorial about it but I haven't had a chance.

    This is ... Read More
    Posted by Albert
    2014-12-01

    Hi Tom,
    Again thank you kindly for letting us use your application (Address Book).

    I found out how to change my username and password from within one of the forms but now I have forgotten them. ... Read More
    Posted by Tom
    2014-12-04

    > From which file can I change the Username and Password

    Passwords are stored in the database. The table name is tbl_staff.
    Posted by Jorma Hytönen
    2014-11-29

    How about MD5 hash of passwords. In where and how?
    Posted by Tom
    2014-12-04

    >How about MD5 hash of passwords. In where and how?

    Open web/staff/app/cls_sys_base.inc.php and find the following lines.
    ... Read More
    Posted by Jorma Hytönen
    2014-11-28

    True awesome, I used Address Book Script as SMS messaging service to store contact information
    Posted by Tom
    2014-12-04

    I'm glad you like it!
    Posted by Ken Anklovitch
    2014-11-13

    Thanks very much Tom
    That is exactly what I wanted to do.
    Ken
    Posted by Tom
    2014-11-21

    You are welcome!
    Posted by Ken Anklovitch
    2014-11-04

    Hi Tom
    I tried
    XA_SIZE_SB=>40,
    I got this error message.
    Notice: Use of undefined constant XA_SIZE_SB - assumed 'XA_SIZE_SB'

    Thanks
    Ken
    Posted by Tom
    2014-11-08

    >XA_SIZE_SB=>40,
    >I got this error message.

    Oh sorry, I meant "XA_SB_SIZE"
    Posted by Bob Hammersley
    2014-10-30

    I have used address book for some time and it works well with PHP 5.2 but my host now no longer supports PHP 5.2 - The scripts are not running on PHP 5.4 the login index.php page throws 22 errors. I ... Read More
    Posted by Tom
    2014-11-08

    Hi, Please download the latest version and replace web/staff/index.php with the corresponding file from the downloaded zip package.

    On the top of web/staff/index.php, you can find the error ... Read More
    Posted by Ashwinkumar
    2014-10-28

    Hello Tom,
    I am using your script with many modification into it. I have almost 13000 contacts on my addressbook and have manually added few on my google contacts. I was wondering if I can syncronise ... Read More
    Posted by Tom
    2014-11-04

    Hi, that's an interesting feature. Thanks for your suggestion!
    Posted by Ken Anklovitch
    2014-10-25

    Hi again Tom
    In regards to my previous post regarding the input box in the search criteria. I am changing the XA_SIZE=>40, in df.fl.addresses.inc.php but it doesn't change the size. The field is ... Read More
    Posted by Tom
    2014-11-04

    >I am changing the XA_SIZE=>40

    Try this
    XA_SIZE_SB=>40,
    If the "XA_SIZE_SB" line doesn't exist, just add the line to the array.
    Posted by Ian Haney
    2014-10-25

    Hi

    I love this script, just started to use it, was just one quick one, is there a way to make a record popup with the full information, for example if I click on their first name, it pop up's with ... Read More
    Posted by Tom
    2014-11-04

    Hi,

    >is there a way to make a record popup with the full information,

    Currently there isn't a feature like that in the script, but certainly it's possible to add it using javascript.
    Posted by Ken Anklovitch
    2014-10-24

    Hi Tom
    Is there a way to make the input boxes in the Search Criteria area bigger?

    Thank you
    Ken
    Posted by Tom
    2014-10-30

    Hi Ken,

    >Is there a way to make the input boxes in the Search Criteria area bigger?

    You can change the font size of the input boxes. To do so, open the template ( ... Read More
    Posted by Nicola
    2014-10-23

    Hi Tom! Great! All works fine!
    Now I have two script foderl, one for staff and the other one for the guest!
    There is a possibility to esclude a guest user from the staff script?
    Posted by Tom
    2014-10-28

    Hi,

    >There is a possibility to esclude a guest user from the staff script?

    I'm not sure if I really understand your question but staff folder has the login page, so guests shouldn't be able to ... Read More
    Posted by Gabriele
    2014-10-23

    Hi tom

    first tks for your great script :-)

    now my question,
    following your suggestion i have copied the staff folder to "guest" and modifief the search page shirinking search criteria to ... Read More
    Posted by Tom
    2014-10-28

    Hi,

    >well, my question is how can i add a link in the blue ribbon to redirect people to "staff " folder where they can and add / delete records after a succesfull logon ???

    You can modify ... Read More
    Posted by AYNFT
    2014-10-16

    Hi tom

    is there a way to make contact list visible with out a login credentials to guests drectly
    Posted by Tom
    2014-10-20

    To remove the login feature, open web/staff/app/cls_sys_base.inc.php, and find $spec_sys_base array. It looks like this:
    ... Read More
    Posted by Nicola
    2014-10-14

    Hi Tom!
    There is a possibility to add a guest group at the other groups (administrator, staff)?
    I need a guest login for people that have to consult the adress book without the ability to modify or ... Read More
    Posted by Tom
    2014-10-20

    First, copy the staff folder and rename it as something like "guest" The "guest" folder now works exactly the same way as "staff" folder does. Feel free to remove anything you don't need from the ... Read More
    Posted by Peter
    2014-10-13

    Hello
    where can i change what top menu links are showing at normal user and administartor, example hide the about tab for normal users, and only show this tab for administrators??
    Posted by Tom
    2014-10-20

    You can find the code for the top menu in staff/include/tpl.body.header.inc.php. Use the following condition to excute code for admin only.
    ... Read More
    Posted by Ken Anklovitch
    2014-10-12

    Hi Tom
    I just figured out my previous question. This little program is perfect for my contacts.

    Thanks very much
    Ken
    Posted by Tom
    2014-10-13

    Great!
    Posted by MA
    2014-10-09

    Hi Tom is there anyway to remove the active and the id options from everything?
    Posted by Tom
    2014-10-13

    There isn't an easy way to remove it in the current version. I should make those fields optional. Thanks for your feed back!
    Posted by Allyn
    2014-10-09

    Found the answer - to disabling the delete button
    Posted by Tom
    2014-10-13

    OK!
    Posted by Daniel
    2014-10-09

    Hey Tom saw a few request for an export. I was able to create my own export function using PHPExcel. I am very beginer with PHP and managed to create a very nice custom output. You can find my ... Read More
    Posted by Tom
    2014-10-13

    Thanks for the link! I'll take a look at it when I get a chance.
    Posted by Ken Anklovitch
    2014-10-07

    Hello Tom

    Does the address script work with PHP 5.4 ?

    Thank you
    Ken
    Posted by Tom
    2014-10-08

    Hi Ken,

    >Does the address script work with PHP 5.4 ?

    Yes!
    Posted by Carlos
    2014-10-01

    Hi Tom,
    its possible ad the Popup info to see adressinfo per java or css? in you homepage its this exact. Or any function for see the completinfo wenn the move the Mouse in the tableadress?

    Best ... Read More
    Posted by Tom
    2014-10-02

    The popup is written in javascript. You can find many javascript libraries on the net. Put "javascript modal dialog box" in search engines and you will hit many solutions.
    Posted by Plugger
    2014-09-30

    Great script

    Showing records 1 - 20 of 35

    is it possible to have this set to 50 or 100

    thanks
    Posted by Tom
    2014-10-01

    >is it possible to have this set to 50 or 100

    Yes. Open /web/staff/app/df.fieldlist.inc.php and find code like this:
    ... Read More
    Posted by babeloo
    2014-09-25

    Thanks for your replie.
    I tried but it doesn't work : it doesn't open thunderbird, it opens a web page with an error message.
    Posted by babeloo
    2014-09-25

    Hello

    I have a column for e-mail addresses.
    Please, could you help me to make them clickables ?

    Thanks a lot.
    Posted by Tom
    2014-09-25

    Hi, this article will help you.
    http://www.phpkobo.com/link--m2072
    Posted by Angel
    2014-09-24

    one more question is there a way to put a login just for administrators?
    Posted by Tom
    2014-09-24

    >is there a way to put a login just for administrators?

    OK, you already removed the login feature from the staff folder. Just rename it to "guest" or something and use it for guests.

    Now, get the ... Read More
    Posted by Angel
    2014-09-24

    I removed the login window and when I click on the log off buttom displays this error

    Location : cls_ps_frame/CVPageSet::GetFieldListAttri
    Message : Fieldset () does not exist in spec_fieldsets : ... Read More
    Posted by Tom
    2014-09-24

    >I removed the login window and when I click on the log off buttom displays this error

    Since you already removed the login feature, you don't need to log off. Please remove the log off link so that ... Read More
    Posted by Ajit
    2014-09-22

    Can I change staff folder name?
    Posted by Tom
    2014-09-22

    >Can I change staff folder name?

    Yes, you can rename it to any name you want.
    Posted by ron
    2014-09-19

    It appear to be a very difficult task to import from another CSV file, how can this be done. I need to know this priorto getting into this.
    Posted by Tom
    2014-09-19

    Hi, it doesn't have the import feature yet. Maybe in the next version!
    Posted by babeloo
    2014-09-19

    Hello

    I can't tell you how you helped me !
    Thanks, thanks, thanks and thanks again. You're great !
    Posted by Tom
    2014-09-19

    I'm glad to hear that!
    Posted by Carlos
    2014-09-12

    Hi Tom, thx for reply,
    Ok. can me plese tel me the code for the hide te Note: Display in the Adresses previue? In you adresses demo no show the text in listing. Make create and show . this is right ... Read More
    Posted by Tom
    2014-09-13

    >can me plese tel me the code for the hide te Note:

    If you want to write it yourself, I'd suggest reading web/codelib/sys/CField.inc.php. This file contains php class implementations for all the ... Read More
    Posted by PK-OSO
    2014-09-11

    ...Or maybe I can use my own list of users to be authenticated using the Sript by itself? The problem with this option is that We are about 200 users. :-D
    Posted by Tom
    2014-09-11

    >Or maybe I can use my own list of users to be authenticated using the Sript by itself?

    The staff table can hold 200 users easily. Why not go ahead?
    Posted by PK-OSO
    2014-09-11

    Hi Tom, thank you again for this app and your help...

    This time I´d like to know if there is a way to create an authentication mechanism maybe based on the MySQL BD created with the AB App or maybe ... Read More
    Posted by Tom
    2014-09-11

    >LDAP server

    I had some chance to implemenent it when my client showed interest but unfortunately the plan didn't materialize. Now I have to wait for the next chance!
    Posted by PK-OSO
    2014-09-08

    Hi there,

    My question at this time is: How many values are possible to add on a dropdown list field? 20? 50 ? 100? No limit?

    Thank You
    Posted by Tom
    2014-09-08

    >How many values are possible to add on a dropdown list field? 20? 50 ? 100? No limit?

    Basically there is no limit but the script has to load all the values before displaying it, so many values will ... Read More
    Posted by Gary
    2014-09-03

    Hi,

    Can we export the content to xls format?
    Posted by Tom
    2014-09-04

    >Can we export the content to xls format?

    Sorry, not yet in the current version. I plan to add a csv export feature in a future version, which should allow users to transfer data to Excel.
    Posted by PK-OSO
    2014-09-03

    Hi there,
    This is an excellent and very easy to use AB app. This time we need to hide/show some fields (Columns) and rename them. We have two separates GUI, one for ADMIN users (Edit access) and the ... Read More
    Posted by Tom
    2014-09-04

    Hi,

    in the templates ( any files that starts with "tpl." ), you can use IsAdmin function to hide things from non-Admin users like
    ... Read More
    Posted by Nicole Taylor
    2014-09-02

    How many and what files do I need to edit to add or change the field names?

    For example ID Agendy Type Agency Name Contact Address etc
    Posted by Tom
    2014-09-03

    Hi,

    >How many and what files do I need to edit to add or change the field names?

    You can find all field labels in web/codelib/cfg/res.eng.app.inc.php.
    Posted by doki
    2014-08-31

    Hi,

    Thanks for the script, this is the best script i found the suits my need. Thank you.

    I have one question, How can i customize the script to make it validate if the data is already exist in the ... Read More
    Posted by Tom
    2014-09-01

    Hi, there is code that prevents users from registering the same username twice. You can find it in web/staff/app/cls_ps_staff.inc.php. See the CheckUsernameConflict( &$def, $id ) function. You may ... Read More
    Posted by Ashwinkumar
    2014-08-30

    Hello Tom,
    I am using your script with many modification into it. I have almost 13000 contacts on my addressbook and have manually added few on my google contacts. I was wondering if I can syncronise ... Read More
    Posted by Tom
    2014-08-31

    OK I'll see if there is API interface for Gmail contact. Thanks for your feeback!
    Posted by Whitney
    2014-08-27

    I wanted to use the address book locally - it keeps bring it up into Dreamweaver and will not run -
    Posted by Tom
    2014-08-27

    Hi Whitney,

    >I wanted to use the address book locally

    In order to use a web application like Address Book, you need to install a web server in your computer. If you are new to web servers, I ... Read More

    Customization Quick Guide

    Important Note: The guide assumes that the table name in the script is "Address"

    Yes, it always used to be that way. ( for 4 years! )

    But the thing has changed. Address Book Builder v1.1 or later allows users to choose any name for the table, so the table name is no longer always "address."

    Before you start reading the guide, it's good idea to make sure what table name is used in your script. To do so, use phpMyAdmin to check the table names. There should be two tables. one is "staff", which stores the staffs data. And the other one holds your data.

    Monday, August 12, 2013

    Address Book Script: Converting a Text Field to a Date Field

    To convert a text field to a date field, open web/codelib/asc/df.fl.(table-name).inc.php, and find the text field that you want to modify.

    The following example is a typical text field definition:

    (example)

    'last_name'=>array(
    XA_CLASS=>'CVText',
    XA_CAPTION=>RSTR_LAST_NAME,
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>36,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
    

    Edit the value of XA_CLASS and XA_SEARCH, and add XA_FORMAT line like shown below:

    'last_name'=>array(
    XA_CLASS=>'CVDateTime',
    XA_CAPTION=>RSTR_LAST_NAME,
    XA_FORMAT=>'Y-m-d H:i:s',
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>36,
    XA_SEARCH_OP=>'s%',
    XA_SEARCH_OP=>'s=',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
    

    Lastly, change the data type of the field in the MySQL database from VARCHAR to DATETIME.

    Wednesday, April 24, 2013

    Address Book Script : Editing options in a dropdown listbox

    To edit the options of a dropdown list box generated by Address Book Builder, open web/config/config.selection.inc.php in a text editor. In the following example, three options are defined for the "State" dropdown list box.

    (example)

    define( 'SEL_STATE', "
    S1001=California
    S1002=New York
    S1003=Florida
    " );
    

    The format of options are a list of key-value pairs. The keys are stored in the database and the values are shown in the dropdown list box. You may freely add new key-value pairs to the list. Please make sure that all keys are unique and that the length of the key is equal to or less than the length of the field in the database.

    (example)

    Key=Value
    Key=Value
    Key=Value
    ...=.....
    ...=.....
    ...=.....
    ...=.....
    

    You are free to edit values any time you want. The changes are immediately reflected in the dropdown list box.

    On the other hand, editing a key may require extra works. If you have already created some records in the database, you must also change the corresponding keys in the records.

    Tuesday, March 26, 2013

    Address Book Script : Setting the id attribute of an input box

    Sometimes, you may need to specify the id attribuets of input boxes. You can set an id attribute by passing it in "$hm->Zb()."

    (example)

    <?php echo $hm->Zb('rs:def:first_name', ZB_ATTR, array( "id" => "enter-your-id-here" ) ); ?>
    

    Monday, March 25, 2013

    Address Book Script : Installing multiple copies in the same database

    If you try to install multiple copies of Address Book Script, table name collisions occur. In order to avoid it, you can change the table names before running the installation script. Change the table names in web/install/sql/sql.txt, which will be used to create tables in the database by the installation script. Also, you need to change the table names in web/codelib/cfg/config.table_name.inc.php.

    Sunday, March 24, 2013

    Address Book Script : changing the default sorting order

    To change the default sorting order, open web/staff/app/df.fieldlist.inc.php in a text editor and edit XA_INIT_ORDER_BY

    (example)

    'addresses' => array(
    XA_CLASS=>'cls_fl_addresses',
    XA_SPEC_FILE=>'df.fl.addresses.inc.php',
    XA_TABLE_NAME=>TBL_ADDRESSES,
    XA_ID_NAME=>'addresses_id',
    XA_INIT_ORDER_BY=>'addresses_id DESC',
    XA_INIT_PAGE_SIZE=>20
    ),
    

    Saturday, March 23, 2013

    Address Book Script : Template Path
    Search Page:
    Path: web/staff/tpl.(table-name).search.inc.php
    Detail ( Add New / Edit ) Page:
    Path: web/staff/tpl.(table-name).detail.inc.php

    Top
    Editing a Field Label

    You can often reuse existing fields by changing labels. For example, you can use the Cell field as the Office Tel# field by changing the caption of Cell to Office Tel#. To do so, follow the step below

     Step 1 
    Find the following code in web/codelib/cfg/res.eng.app.inc.php.
    define( 'RSTR_CELL', 'Cell' );
    Make the following modification (the BLUE text) like shown below. (1 location)
    define( 'RSTR_CELL', 'Office Tel#' );
     Done! 
    Note: The procedure above does not change the name of the field in the database.

    Top
    Making a Field Required or Optional

    You can easily make fields required or optional. For example, to make the email field required, follow the step below

     Step 1 
    Find the following code in web/codelib/asc/df.fl.address.inc.php.
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
    Make the following modification (the BLUE text) like shown below. (1 location)
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>24,
    XA_REQUIRED=>true,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
     Done! 
    To change it back to "optional", set it to "false" like XA_REQUIRED=>false,

    Top
    Changing Size of Input Box

    You can easily change the size of input box in the New/Edit page. For example, to change the size of the input box of the email field from 24 to 48, follow the step below

     Step 1 
    Find the following code in web/codelib/asc/df.fl.address.inc.php.
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
    Make the following modification (the BLUE text) like shown below. (1 location)
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>48,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
     Done! 

    Top
    Resizing Column Size (Field Size)

    Do you need to make the size of a field larger/smaller? The following guide will show you an example for changing the size of a field. In this guide, you change the size of the email field from 100 chars to 200 chars.

     Step 1 
    Use phpMyAdmin to change the size of "email" field of the table, tbl_address to 200 chars.

    If you prefer to use a sql statement, use the following command:
    ALTER TABLE `tbl_address` CHANGE `email` `email` VARCHAR( 200 ) DEFAULT NULL;
     Step 2 
    Find the following code in web/codelib/asc/df.fl.address.inc.php.
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
    Make the following modification (the BLUE text) like shown below. (1 location)
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>200,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
     Done! 

    Top
    Copying a Field

    Do you need another field similar to an exsiting field in the script? If so, the following step-by-step guide will help you. In this guide, you will add a copy of the email field to the script. Let's call it "email2."

     Step 1 
    Use phpMyAdmin to create a new field named "email2" in the table, tbl_address. The attributes of the email2 field should be exactly the same as the email field except the name.

    If you prefer to use a sql statement to create the email2 field, use the following statement:
    ALTER TABLE `tbl_address` ADD `email2` VARCHAR( 100 ) NULL AFTER `email`;
    		
     Step 2 
    Find the following code in web/codelib/asc/df.fl.address.inc.php.
    'email'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>RSTR_EMAIL,
    XA_SIZE=>24,
    XA_REQUIRED=>true,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
    Copy the code above, paste it after the original, and make the following modifications (the BLUE text) shown below. (2 locations)
    'email2'=>array(
    XA_CLASS=>'CVEmail',
    XA_CAPTION=>'My New Email2',
    XA_SIZE=>24,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(sr)(fd)'
    ),
     Step 3 
    Find the following code in web/staff/tpl.address.detail.inc.php.
    <tr>
    <td class='column_caption'>
    <?php if ( $b_reg || $b_edit ) { ?><span class="required"></span><?php } ?>
    <?php echo RSTR_EMAIL; ?> :
    </td>
    <td class='column_value'><?php echo $hm->Zb('rs:def:email'); ?>
    </td>
    </tr>
    Copy the code above, paste it after the original, and make the following modifications (the BLUE text) shown below. (2 locations)
    <tr>
    <td class='column_caption'>
    <?php if ( $b_reg || $b_edit ) { ?><span class="required"></span><?php } ?>
    My New Email2 :
    </td>
    <td class='column_value'><?php echo $hm->Zb('rs:def:email2'); ?>
    </td>
    </tr>
     Done! 
    Log in the staff area and check the detail page of one of address records. You will see the email2 field and it's ready to use!

    Optionally, you can add the email2 field to the Search page.
    To add it as a search criteria, see Adding a Search Criteria.
    To display it in the Search Results table, see Adding a Field to Search Results table.

    Top
    Adding a Search Criteria

    The following steps guide you add a search criteria to the Search page. Let's use the street1 field as an example.

     Step 1 
    Find the following code in web/codelib/asc/df.fl.address.inc.php.
    'street1'=>array(
    XA_CLASS=>'CVText',
    XA_CAPTION=>RSTR_STREET1,
    XA_SIZE=>40,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(fd)'
    ),
    Insert the BLUE text like shown below. (1 location)
    'street1'=>array(
    XA_CLASS=>'CVText',
    XA_CAPTION=>RSTR_STREET1,
    XA_SIZE=>40,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sp)(fd)'
    ),
     Step 2 
    Find the following code in web/staff/tpl.address.search.inc.php.
    <!-- [BEGIN] Main Form -->
    <div id="main_div">

    <?php include(INC_FORM_BEGIN); ?>

    <?php include(INC_BODY_INFO); ?>

    <!-- [BEGIN] Search Criteria -->
    <?php echo $hm->SectBegin( RSTR_SEARCH_CRITERIA ); ?>

    <div style='overflow:auto;'>
    <table width='99%'>


    Insert the BLUE text like shown below. (1 location)
    <!-- [BEGIN] Main Form -->
    <div id="main_div">

    <?php include(INC_FORM_BEGIN); ?>

    <?php include(INC_BODY_INFO); ?>

    <!-- [BEGIN] Search Criteria -->
    <?php echo $hm->SectBegin( RSTR_SEARCH_CRITERIA ); ?>

    <div style='overflow:auto;'>
    <table width='99%'>

    <tr>
    <td align="right"><?php echo RSTR_STREET1; ?> : </td>
    <td align="left"><?php echo $hm->Zb( 'sp:def:street1' ); ?></td>
    <td align="right">&nbsp;</td>
    <td align="left">&nbsp;</td>
    <td align="right">&nbsp;</td>
    <td align="left">&nbsp;</td>
    </tr>



     Done! 

    Top
    Adding a Field to Search Results table

    The following instruction explains how to display a field in the Search Results table. We use the street1 field as an example.

     Step 1 
    Find the following code in web/codelib/asc/df.fl.address.inc.php.
    'street1'=>array(
    XA_CLASS=>'CVText',
    XA_CAPTION=>RSTR_STREET1,
    XA_SIZE=>40,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(fd)'
    ),
    Insert the BLUE text like shown below. (1 location)
    'street1'=>array(
    XA_CLASS=>'CVText',
    XA_CAPTION=>RSTR_STREET1,
    XA_SIZE=>40,
    XA_REQUIRED=>false,
    XA_MIN_CHAR=>0,
    XA_MAX_CHAR=>100,
    XA_SEARCH_OP=>'s%',
    XA_LIST=>'(sr)(fd)'
    ),
     Step 2 
    Find the following code in web/staff/tpl.address.search.inc.php.
    <tr class='data_table_caption'>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:address_id'); ?> <?php echo RSTR_ADDRESS_ID; ?></th>
    <th><?php include(INC_SR_SELREC_HEADER); ?></th>
    <th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
    <th><?php echo RSTR_ACTIVE; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
    <th><?php echo RSTR_CITY; ?></th>
    <th><?php echo RSTR_STATE; ?></th>
    <th><?php echo RSTR_EMAIL; ?></th>
    </tr>


    Insert the BLUE text like shown below. (1 location)
    <tr class='data_table_caption'>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:address_id'); ?> <?php echo RSTR_ADDRESS_ID; ?></th>
    <th><?php include(INC_SR_SELREC_HEADER); ?></th>
    <th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
    <th><?php echo RSTR_ACTIVE; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
    <th><?php echo RSTR_CITY; ?></th>
    <th><?php echo RSTR_STATE; ?></th>
    <th><?php echo RSTR_EMAIL; ?></th>
    <th>Street1</th>
    </tr>

     Step 3 
    Find the following code in web/staff/tpl.address.search.inc.php.
    <?php while( $hm->zb('@rs:def:begin_table') ) { ?>
    <tr>
    <td style='text-align:right;'><?php echo $hm->Zb('rs:def:address_id'); ?></td>
    <?php include(INC_SR_ID_PARAM); ?>
    <?php include(INC_SR_SELREC); ?>
    <?php include(INC_SR_EDIT_BTN); ?>
    <td style='text-align:center;'><?php echo $hm->Zb('rs:def:active'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:first_name'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:last_name'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:city'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:state'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:email'); ?></td>
    </tr>

    Insert the BLUE text like shown below. (1 location)
    <?php while( $hm->zb('@rs:def:begin_table') ) { ?>
    <tr>
    <td style='text-align:right;'><?php echo $hm->Zb('rs:def:address_id'); ?></td>
    <?php include(INC_SR_ID_PARAM); ?>
    <?php include(INC_SR_SELREC); ?>
    <?php include(INC_SR_EDIT_BTN); ?>
    <td style='text-align:center;'><?php echo $hm->Zb('rs:def:active'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:first_name'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:last_name'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:city'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:state'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:email'); ?></td>
    <td style='text-align:left;'><?php echo $hm->Zb('rs:def:street1'); ?></td>
    </tr>

     Done! 

    Top
    Adding Sort Buttons

    This section will explain how to add sort buttons on the header of Search Result Table.

    You already have sort buttons on First Name and Last Name, so let's try the City field.

     Step 1 
    Find the following code in web/staff/tpl.address.search.inc.php.
    <tr class='data_table_caption'>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:address_id'); ?> <?php echo RSTR_ADDRESS_ID; ?></th>
    <th><?php include(INC_SR_SELREC_HEADER); ?></th>
    <th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
    <th><?php echo RSTR_ACTIVE; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
    <th><?php echo RSTR_CITY; ?></th>
    <th><?php echo RSTR_STATE; ?></th>
    <th><?php echo RSTR_EMAIL; ?></th>
    </tr>


    Insert the BLUE text like shown below. (1 location)
    <tr class='data_table_caption'>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:address_id'); ?> <?php echo RSTR_ADDRESS_ID; ?></th>
    <th><?php include(INC_SR_SELREC_HEADER); ?></th>
    <th><?php include(INC_SR_EDIT_BTN_HEADER); ?></th>
    <th><?php echo RSTR_ACTIVE; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:first_name'); ?> <?php echo RSTR_FIRST_NAME; ?></th>
    <th nowrap='true'><?php echo $hm->Zb('ob:rs:def:last_name'); ?> <?php echo RSTR_LAST_NAME; ?></th>
    <th><?php echo $hm->Zb('ob:rs:def:city'); ?> <?php echo RSTR_CITY; ?></th>
    <th><?php echo RSTR_STATE; ?></th>
    <th><?php echo RSTR_EMAIL; ?></th>
    </tr>

     Done! 

    Monday, March 4, 2013

    Bug Fix : Address Book Builder 1.2

    Description: This is a bug introduced in Address Book Builder v1.2. In some builds, some of data columns of the search result table get cut off. ( Thank you for reporting, Mikitty! )
    Status: Fixed

    Thursday, February 28, 2013

    Pickup Center Update : Popup Info Card

    Added popup info cards to Pickup Center. When you hover the mouse cursor over a script box, a small window pops up and displays the list of fields used in a script.

    Friday, February 22, 2013

    Address Book Builder v1.1 Update

    Address Book Builder was updated to v1.1. The new version of Address Book Builder allows you to choose a field type from an input box, textarea, checkbox and dropdown listbox.

    Also, you can name the table as you like. ( In the previous version, the name of the table is always "address" )

    Monday, January 21, 2013

    Address Book Builder v1.0 Now Available Online

    Address Book Builder allows you to generate a web-based Address Book Script ( PHP + MySQL ), which you can install on your web site.

    Just enter a title and a list of fields you would like to have. Address Book Builder will generate the PHP code for you.

    Since you can specify fields freely, the application is not limited to address books. You can use Address Book Builder to create scripts that store a member list, customer list, employee list or any lists you can imagine.

    Friday, December 14, 2012

    A new section, 'Adding Sort Buttons' was added to Customization Quick Guide

    Sunday, December 9, 2012

    The new section, 'Editing a Field Label' was added to Customization Quick Guide

    Tuesday, December 4, 2012

    An easy alternative way to upgrade Address Book Script v1.16 to v1.17

    To upgrade Address Book Script v1.16 to v1.17, you don't need to reinstall the entire script again.

    Download this zip file and replace "web/codelib/asc/df.fl.address.inc.php" in your copy of Address Book Script (v1.16) with "web/codelib/asc/df.fl.address.inc.php" in the zip package.

    Monday, December 3, 2012

    Address Book v1.17

    Bugfix: Fix duplicate string resources.