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.
Hello Tom Thank you for getting back to me on this. As I need to use multiple choice with your script (which fits perfectly for my use), could you guide me with regard the alterations Which files ... Read More
Hi, If I were you, I would start with CVSelection in web/codelib/sys/CVField.inc.php. The conversion from CVSelection to multiple choice input wouldn't be straightforward but I think it's still the ... Read More
Dear: Tom I have 6 Column in Edit Option and I need to disable the Keyboard in 3 of then, How can I Do that. ------------------------------------------------------------------------------------- but ... Read More
Hi, You can disable saving a particular field. In the following example, I'll show you how to disable saving the "first_name" field. Open web/staff/app/cls_ps_(table-name).inc.php and find the ... Read More
One way to do it is to add the "disabled" attribute to the input fields you want to disable. To do so, open the template web/staff/tpl.(tablename).detail.inc.php and find a field you want to disable. ... Read More
hi, thanks for the previous answer! now i want a field to be validiated for example if the user enters alphabets in a number field it should not submit the form and gives error. hope u will get my ... Read More
in Address Book Script I custom a php data entry, I create 10 Row, I put 5 for user-1, user-2 can see the 5 entries with data and user-2 has to respond with the other 5 Row, how can I make User 2 ... Read More
It's possible to customize like that but it's byond the scope of this feedback box. I recommend you play with $username = $this->sys->AuthSession->GetV( "username" );. Identifying the username is the ... Read More
Thanks for your lovely script. i want a little customization if the user adds a record in a field like (mobile) and the record already exists in db. i want the system to show a popup that ... Read More
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
There is a commercial product for it. It doesn't really put pictures to the database, though. It allows you to upload pictures to a folder and link it with a field in Address Book. ... 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.
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.