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.
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
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
Hi, You can disable editing for non-admin. To do so, please take a look at this page: http://www.phpkobo.com/article--m2756
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.