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.
If it's the staff table, then the EncryptPassword function in web/staff/app/cls_ps_addresses.inc.php does encryption. But it won't do anything for you because you want to encrypt a field in a ... Read More
Here is my theory. There is an error in your select configuration file and the script couldn't start the session properly. That's why you get kicked out. Remove the content from the select ... Read More
Thanks Tom, my drop down is working but now I have a very perplexing problem. When ever I do a search or try to add or edit a new record it kicks me back out to the login in page asking for my user ... Read More
"cls_password_encrypt" could be used for the buit-in staff table but cannot be used for the one you created. I assume you are going to write code to authenticate for your Member table, right?. Then ... Read More
No i don't want to display username in search page)))) I have another questions about how i can add types to input field like "number" or "tel" or another... for example <input type=number ..... ... Read More
Thank you for fast reply on my previous question. I think you don't understand me because of my bad english. Your address book have record create date/time, record edit date/time and who did it ... Read More
Hello dear Tom. I need to create a checkbox with date/time parameters like parameters that has in record "last date edit/date create". For example, when i checked the checkbox the script write ... Read More
Maybe you would consider supporting a procedure or function the same way you support tables. I person would define the procedure or function with in field list and out field list. Then they would be ... Read More
Thanks for suggestion! Address book script is an old script. The first version was written 7 years ago and have been used for a single table database since then. Many things happened to other series ... Read More
Hi, It's a very nice scripting. But after a few minutes it seems like that i'm automatic logout from the adressbook? Is it possible to set this option to be in the adressbook for more time without ... Read More
There are two options. (1) You can copy the "staff" folder and put it in side by side. ( You need to rename the new folder to something like "guest" ) Modify the "guest" folder so that the users ... Read More
Hi, I understand that you can specify the code that you want to disable in the templates. Can you tell me specificaly what code I would disable to turn off editing, deleting and adding new entries? ... Read More
If you mean you want to change the output foramt of a date fileld, you can do so by editing web/staff/codelib/df.fl.(table-name).inc.php. Open the file and find the date field you want the change the ... Read More
I followed the instruction how to disable the edit, delete button. After the staff tries to edit, they can't edit or delete (that's good), they dont get an error message they just get a blank ... Read More
Hi, it's better you remove the edit/add-new/delete buttons from the template, web/staff/tpl.(table-name).search.inc.php Or you can hide it from staff. To hide code in a template, enclose it with ... Read More
Hi Tom. Thanks for your answers. Just one question: when i login as admin, in header i see four menus: Address, Staff, About and Log Off. When i login with a staff password, i dont see in header a ... 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.