Getting Started with DbFacePHP

[box_info] on demand version beta soon: Appreciate any comments. [/box_info]


[box_info] Creative mysql web interface, application builder and sql reporting tool. [/box_info] DbFacePHP helps you talking with MySQL by some clicks without coding PHP. You are never so easy querying, updating data, building applications and reports from databases with DbFacePHP. DbFacePHP also integrate many database tools including table navigating, database structure manager, backup and restore etc.

DbfacePHP application has two basic concepts: form and application script.

Form means user interface, people input data in forms.
application script means how to operate with databases (may using form data).

All DbFacePHP applications composes the two componements(form is optional). After applications created, you can talking with MySQL with these applications. i.e. You type “12345” in the form, and click the Submit button, application scripts executed and the resultset returned.


[box_info] DbFacePHP is a drop-to-use application! Easy Installing[/box_info]. Please follow the following instructure to install:

Step 1. Uncompressing downloaded file.

Please create a empty directory (“dbfacephp” i.e.) and uncompress the dbfacephp script archive.

Step 2. Uploading files.

Upload content of this folder (all files and directories it includes) to your document root (public_html, www, httpdocs etc.) using FTP. Pay attention to DON’T use the capital letters in the name of the folder (for Linux users). For example: public_html/your_site/dbfacephp Rename default.htaccess into .htaccess if you need to add PHP5 handler.

Step 3. Running install.php file.

Now you can run install.php file. To do this, open a browser and type in Address Bar http://{}/install.php or http://{}/{dbfacephp directory}/install.php Start Installing DbFacePHP for MySQL Check that you have write access to the config file directory (see {dbfacephp_directory}/application/config.php). Follow instructions on the screen. You will be asked to enter: database host, database name, username and password. Also you need to enter admin username and admin password, then you will be ready for starting dbfacephp.

Step 4. Deleting installation files.

After successful installation you will get an appropriate message and warning to remove install.php file. For security reasons, please delete them immediately.

Connecting to your first database

After dbfacephp installed successfully, databases connections that you want dbfacephp to manage should be told to dbfacephp. A connection always be specified for entering the dashboard(main screen). Congratulations! You have make dbfacephp work for you now.

Manual Installation or Upgrade

If you already have a DbFacePHP installing, you can upgrade or reinstall int manually (You do not need recreate configuration database etc.).

  • Step1. Create a database named “dbfacephp” if not exists
  • Step2. Run the “schema.sql” file on the “dbfacephp” database
  • Step3. Edit application/config/database.php file
  • Set the correct values for the following fields.
    $db[‘default’][‘hostname’] = ‘localhost';
    $db[‘default’][‘username’] = ‘root';
    $db[‘default’][‘password’] = ”;
    $db[‘default’][‘database’] = ‘dbfacephp';
  • Step4. Edit application/config/config.php

    $config['installed'] = '0';


    $config['installed'] = '1';
[/check_list] NOTE: Please make sure the application/cache directory has write permission.