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.
I Like you addr. book script very easy to use and set up. Once i have added my list of contacts I would like to display on my web page. Is this possible do you have a solution? using a php echo to ... Read More
OK, so you want to display raw html instead of encoded html. Then you need this helper function. Open web/staff/common.inc.php in a text editor, and put the following line on the top. The function ... Read More
Thanks for the quick reply Tom! I guess my quick fix would be to iframe the app on Joomla. Having said that, I will need to remove the Menu and Breadcrumbs bars. Which line and template file ... Read More
Hi! This script is exactly what I am looking for. However, I need to put in a Joomla environment along with all the other applications that we currently have. Is there a way to remove the login ... Read More
Tom. Thanks for the prompt reply. The changes to the guest folder fixed it so that guest could not add,edit and delete. Didn't understand which top menu and which template to remove. The logout ... Read More
I like the multi delete capability and want to add to this menu bar if possible. Do you have any code allowing for updating fields in selected records from this bar using a field with a Submit button ... Read More
OK then probably some other php files in the same web site are overwriting php session files. You can have a separete session folder for the script so other scripts won't overwrite it. To do so, ... Read More
Hi Tahmidul, The first step is copy the staff folder and rename it as something like "guest" The "guest" folder now works exactly the same way as "staff" folder does. Feel free to remove anything you ... Read More
Hi, you can convert an text input box to a dropdown but it's not multiple choice. To have a multiple choice list box, you need to write new code & add it to the script, which takes some effort. If ... Read More
Hi Tom sorry to bother you again . I would like to help me in this : I connect to my base and it goes grate but if I don't make a "movement" for a while the session close and I must reconnect. Is ... Read More
You can remove any buttons from the template, web/staff/tpl.(table-name).search.inc.php but some people know how to execute the backend code without buttons. So, you should first disable the backend ... Read More
Hi Tom your work is totally assume. I have one seemly dumb question. To give my form a little more pizzazz I would like to change the background colour to a jpg file. I've look in the css file but I ... Read More
I have a number of users (staff) that I've added and as you know each of these have staff_Id. I would like the search form for customers to automatically use the staff_Id as a search parameter when ... Read More
First, create a search input box for staff_id and make sure you can select the customer records with a particular staff_id. Then assign the staff_id of the logged user to the search input box, so the ... Read More
I didn't change any code for the IDs but it's even weirder than I thought. I clicked through roughly 200 pages and it's not consistent. I have screenshots and will send them to your email that you ... Read More
I just did a derive of Address Book Mini 1.18, updated the database info and uploaded to my Apache server, did the install script and BAM! Instant app and working app. Thank you so much. What you ... Read More
I imported 58000 records into the database. confirmed the ID field is unique for each record. While the app shows there are 58000 unique records the ID field resets to 1101 once you get to 153xx ... Read More
Separate question on image upload to address book. I have created a field as blob in my table. I don'd find a class anywhere that defines a field to handle bitmaps and such. CVxxxx in the Sys folder? ... Read More
You are right, I haven't written the blob class. Never thought there was a demand for it. You are the first person who mentioned it. Do you really need to put images in a database? Maybe you are ... 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.