Table of Contents
- Defining Your Tables
phpFriendlyAdmin is an easy to use database management tool. Even in the midst of this,
we still recommend that all new users thoroughly review this manual. This is
to insure correct installation and comprehension of features so as to maximize the possibility
of success when integrating phpFriendlyAdmin into your systems.
Please click here to view
Please click here to view
Follow these steps to successfully install phpFriendlyAdmin:
- Correctly fill out three configuration files in phpfriendly/admin/.
Configure regdb.php with databases to be used, regftp.php with ftp locations to be used and
regloc.php with absolute path data pertaining to phpFriendlyAdmin's location. Carefully
read the comments in each of these files if any questions arise.
- Upload phpfriendly to a location of your choice. If the information you are planning
to manage is in any way sensitive, it is advised that you upload the phpfriendly directory to an SSL encrypted location
for maximum security.
- Create an .htaccess password for the phpfriendly/admin/ directory. As this holds the sensitive
data you configured in step 1, for security's sake it is very IMPORTANT not to skip this step.
- Open a web browser and point it to phpfriendly/admin/install/index.php. If you did step
3 correctly, the web server will ask you for the .htaccess password you just made. The page will
open and ask you to create a User Name and Password for a phpFriendlyAdmin Administrator.
- Follow the directions and cruise to phpfriendly/logon.php to start using phpFriendlyAdmin.
If for some reason the phpfriendly/admin/install/index.php script doesn't work to set up
database tables at the location you specified in phpfriendly/admin/regdb.php use the SQL
files in phpfriendly/admin/install/sql/ to create the necessary tables manually.
5. Defining Your Tables
Before defining your tables in phpFriendlyAdmin, make sure that
your table structure is set in your database. If you are using MySQL,
is a popular tool you may wish to consider for this task.
Once this bare-bones database structure is in place, as per your project's needs,
please log in as an Administrator to PFA and click on the "Admin" link in the left
navigation menu. From the submenu choose "Tables" and click on the "Add Record" link.
At this point please provide the following information for all of your tables:
- Table Alias - An alias, or common name you would like to use to refer to
the table being defined.
- DB Table Name - This is the name of the table exactly as it
appears in your database.
- Database - Here you should see a drop down list of your
various databases you have defined for use with PFA. Please choose the
database that contains the table that is currently being defined.
- Description Width - Later on, you may provide descriptions
for each of the fields in your table. Please enter an integer to specify the width
of the popup window that will hold this description.
- Description Height - This field is for the same purpose as the
field above, but indicates height of the popup.
- Results Per Page - When a database gets large it is usually
convenient to break up the records into smaller display sets. This field calls for
an integer that will be used to break up your records (example: 25, would
then display 25 records per page).
- Search Option - The search option is a flag that allows or
disallows searching within the table being defined. (Later, when defining fields, this option may be
refined further on a field-by-field basis).
- Notes - The notes for this table will appear in the table
summary page and generally alert your PFA users as to the purpose of the
Now that your tables are defined, the fields for each of your tables comes next...