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.
Thanks for your lovely script. It's working like a charm. I was just wondering if it's possible to give "Staff" users specific "rights" to add entries into database. For example, I want to ... Read More
Hello, This is an amazing script that has literally saved my life and lots of headache. It is have a quick question though: Is there a way I can import the addresses from excel spreadsheet or export ... Read More
I use AddressBook for registration customers of the food bank. Now I want an extra table for date. Per customer, I want to see when they the food bank have visited. Is there a module for an extra ... Read More
What you did is the correct first step. The second step is to remove '(fd)' for those fields. To do so, open web/codelib/asc/df.fl.(table-name).inc.php. You will find a line like this for most of ... Read More
Thank you but i meen another. In tpl.... search.php i have a table with some info. When i click "edit" opening tpl.....search.detail.php with editing info, right. But all this info are in "inputs ... Read More
I have made the tables in responsive using the code from http://codepen.io/geoffyuen/pen/FCBEg Just add table class and td data-th and add the css to page.css. I have hidden 'Add New' and 'Delete' ... Read More
Yes, I had a redirect for the home page in htaccess, I temporarily disabled this and all is well. Please delete refernce in your post to actual site, this was only incuded in an email, not for public ... Read More
First of all, thanks for the great scripts! .. I'm just starting to discover php and this is a big help. Do you think it's possible to make the email addresses and URLs "clickable" ? So you ... Read More
Here is a thought, providing a multi drop down menu to select categories of address lists. For example first select members - then from that the members group like firestone - then the list of ... Read More
Great script! I could use it and customize everything. The only thing I have some problems with its the date format. I want to change the date into (only) date (no time) and dit is as below. I also ... Read More
I have a problem with exporting the database. For some reason the database exports not the text from a lookup list but a number. For example if I select at the field "gender" the option Male, then ... Read More
I know what you mean. That's one of problems I have to fix in a future version. A currently availabel option is make a SQL join statement in the database. But then it requires a good SQL knowledge. ... Read More
Hi, thx for awesome script. Can you tell how can I change search results font size and / or increase or decrease tables cell and font inside ? I would like to modify for smaller fonts and cells for ... Read More
Tom, Once the login function has been modified so that visitors can look but not edit, is there a way to remove the login screen for those visitors but have it for the staff? I have duplicated the ... Read More
The recommended procedure for creating guest pages is copy staff folder and rename it to guest or something. Keep the original staff folder for administration and modify guest folder for your ... Read More
Hello Tom. What a super service you're offering. Sadly, when I set up the script, I accidentally entered a field twice. Is there any way to edit after the fact or do I need to start over. The world ... Read More
Hi Tom! I merged two database in one and i using it with two different instance of ADB script. I've done it in order to have a unique user login, adding in the top bar a link to connect each other ... Read More
hi. Tks for sharing your work. Q: I want to know if there is a possibility to make a contact from the address book to be visible for all (public), only for specific groups (family& friends), and ... Read More
Hi Tom! Great work. Thank you for share that usefull script. I have a problem. When i try to add new record or new staff, there is "403 Forbidden Access to this resource on the server is denied!" ... Read More
Hi, it sounds like there is some problem outside of the script. Someone who had a similar problem said that he got wrong information from his ISP. I don't know exactly what information he was ... Read More
Hi, would you tell me which post you are referring to? I need to refresh my memory...
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.
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.