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.
Hi, First of all, I assume you didn't modify the code and you are experiencing the problem right after you installed it. (Correct me if my assumption is wrong.) Then there must be some other external ... Read More
I made a guest directory, modified the backend code for removing the opportunity to guests to modify/add/delete the entries, and now I just want to remove the buttons (because if we click ... Read More
Hello dear Tom. You write brilliant script, but i have some problem. I want that users see only "active" records, i do some changes in df.table-name.search file in "active" string like: .... array ... Read More
Tom, this is the best script i have seen! i have a some people asking for 2 changes. 1: automatically add dashed when inputting a phone number. 2. either a popup calendar or a button that will input ... Read More
Great job and thank you for work. I managed to have more than table in the "Address Book" for different purposes and I wanna ask you if it's possible to add a button or something which can ... Read More
I got a warning message. Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. ... Read More
I think you are using one of PHP v3.x series. It seems some PHP distributor accidentally injected a bug in php.ini file and that's causing the warning message in any PHP scripts that use the date() ... Read More
Dima, Its pretty easy to add extra pages is you make copies of the type of page you want (Search, Detail, Login etc.) I have several tables and copied the search page to create different search ... Read More
Thank you Tom, but in html not workin, they do it in one vertical line, but i need in 3-4 vertical column. Twenty entries per page, i need 4 vertical and five horizontal lines, but with simple html ... Read More
Sorry I can't. Your request is out of the scope of this feedback box. Anyway, I think you first need a good HTML coder. In your case, it's important to write correct HTML code before editing the ... Read More
Thank you dear Tom, for fast reply, but your example: ?_sc=address/&rs:def:_lv:ob=cls_rlog_date_time%20ASC not working (i change address to my db name). The script write this: "Invalid Order By : ... Read More
Hello again dear Tom. This time please help me with links. I wanna do a sorting by date creating or date editing strings like: <a href="?_sc=customers/&sr:def:rlog_edit_date_time=19.01.16; ... Read More
Hello dear Tom. Please can you tell me what I must to do that in search form i can place a checbox not simple selectfield. For example, I have some checkbox to check in adding new adress form, but ... Read More
Sorry, there isn't an easy way to convert the select to a checkbox. The reason why <select> is used is because a select can offer three choices: (1) Checked (2) Unchecked (3) All. If you change the ... Read More
Thanks so much for the information on what to put in the URL to alter the search string. It works perfectly. I'll look at the multi-column search ability when I get some time. This a great script ... Read More
Hi Is there some way to set one or more search criteria before accessing the main page in order for the search results to be updated when the page opens. For example, presetting a default entry into ... Read More
In strings file I see User Types Guest, Member and Staff. It seems to me only Staff is fully implemented. I'd like non staff users to be restricted so they can only view the contacts (i.e. cannot ... Read More
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.
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.
define( 'SEL_STATE', "
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.
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
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.
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:
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."
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`;
Find the following code in web/codelib/asc/df.fl.address.inc.php.
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! )
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.