Features Requirements Testimonials Download FAQs Manual Contact

Table of Contents

  1. Introduction
  2. Features
  3. Requirements
  4. Installation
  5. Defining Your Tables

1. Introduction
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.

2. Features
Please click here to view phpFriendlyAdmin's features.

3. Requirements
Please click here to view phpFriendlyAdmin's requirements.

4. Installation
Follow these steps to successfully install phpFriendlyAdmin:

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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, phpMyAdmin 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 table.

Now that your tables are defined, the fields for each of your tables comes next...

News Logo