What is DbFacePHP?

DbFacePHP is a report and dashboard builder tool for SQL databases like MySQL, PostgreSQL, SQLite3 (MS SQL Server etc.) written by PHP.

What is the system requirements?

You need a PHP5.3+ webserver (apache, nginx, etc) with SQLite3, Zend Guard Loader extensions supported to run DbFacePHP.

  • PHP5.3 or PH5.4 supported webserver
  • SQLite3 PHP extension
  • Zend Guard Loader 3.3.0 or later extension

All modern brownsers(desktop or mobile device) are cool, IE10+, Firefox, Chrome, Safari.

If you want the PHP source code to do your own customization,  or do not want to use Zend Guard Loader extension, consider to get DbFace Server.

How is the product licensed?

A single website require one license. A website is defined as a single domain including sub-domains that operate as a single entity. Additional software licenses must be purchased in order to install and use the software on additional websites.

Can you help me to install it on my server freely?

Yes, we can help you to install DbFacePHP on your server freely after the order received. Please make sure your webserver fits the system requirements.

How do I leave my feedback?

We appreciate any suggestions, questions and bug reports regarding our software.Click here to leave us a message.

Is this security in real production environment?

DbFacePHP does not apply any special security methods to the MySQL database server. It is still the system administrator’s job to grant permissions on the MySQL databases properly.

In most cases, you just want to allow accessing the DbFacePHP service at some ips(at home or at work), in this case, please configure the whitelist. All ip addresses not in the whitelist will be denied to access the service. Login in DbFacePHP with the administrator account and edit the ip whitelist in System Settings Page;

you may have known, only ~ and allowed to access the service.

i update the db an not refresh the changes in the reports, why?

DbFacePHP caches all the report data by default.

You can click the icon at bottom-right corner at a report widget to flush report.

If you do not want the cache feature, open the config/config.php and change the app cache time value.

Affiliate Program

If you have a website, newsletter or other means of promotion, you can help us promote DbFacePHP product and be guaranteed a generous 30% commission on all sales you help generate. You can choose following affiliate program to start selling our product. Please feel free to contact us with any questions you may have.

Join DbFacePHP Affiliate Program, click here.

How to enable PostgreSQL in PHP?

open php.ini and find


remove the ; to enable the postgresql PDO driver.

then open httpd.conf file in your apache directory:
LoadFile "C:/xampp/php/libpq.dll"

Restart your apache, you can connection with PostgreSQL by PHP now.

Do not have SQLite3 extension?

If you do not have SQLite3 extension or want to use MySQL to save the configuration data. You can open application/config/database.php and input your MySQL configuration.

Remove the config/.install file, then the DbFacePHP configuration data will be saved in MySQL.

How to use MySQL to store the configuration data?

Please rename application/config/database.php to application/config/database.php and create a new file named database.php and input

$active_group = 'production';

$query_builder = TRUE;

$db['production'] = array(
'dsn' => '',
'hostname'=> '',
'username'=> 'root',
'password'=> 'yourpassword',
'database'=> 'dbfacebuilder',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => TRUE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set'=> 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'autoinit' => TRUE,
'stricton' => FALSE,
'failover' => array()

You can delete the config/.install file, so that the default account should saved to the new configuration database.