DaDaBIK Administration Site
Have you created a php-mysql site from the scratch and now you have to develop the admin site?
A great solution for a quick and dirty admin front end site is the DaDaBIK (DaDaBIK database front-end for MySQL SQLite PostgreSQL Oracle SQL Server - Create a PHP database application in a minute without coding - |\.-./| DaDaBIK is a DataBase Interfaces Kreator)
Easy to install, supporting the most popular databases, secure, quick on loading and mainly plug and play it is for me the best solution for a medium scale project.
Hints!
1. Error [08]
Sometimes you want to create alias names for your tables or columns.
For that you should go to the Admin Area of dadabik and make your changes. Apart from saving them you should go to the Refresh Installation Button (at the Step3 on the bottom) in order to make the changes.
Otherwise you will see a very nice "Error [08] Error during execution"
2. UTF-8
In order to have utf suuport you have to do the following things.
- for database utf retrieval (mysql especially) go to common_start.php file, find the line:
$conn = connect_db($host, $user, $pass, $db_name);
and add the following 2 commands:
@mysql_query('SET NAMES utf8');
@mysql_query('SET CHARACTER SET utf8');
- As for the page utf support go to header.php
and just before the end of header
add the following line
3. Debugging
For those that make changes to the code or something goes wrong with their dadabik installation you can enable the debugging option and learn exactly what is the problem so that you can fix it.
To enable the debugging mode go to config.php and change the $debug_mode to 1.
For those that prefer to display the sql during the development process do the $display_sql = 1.
More on this.... later!
Easy to install, supporting the most popular databases, secure, quick on loading and mainly plug and play it is for me the best solution for a medium scale project.
Hints!
1. Error [08]
Sometimes you want to create alias names for your tables or columns.
For that you should go to the Admin Area of dadabik and make your changes. Apart from saving them you should go to the Refresh Installation Button (at the Step3 on the bottom) in order to make the changes.
Otherwise you will see a very nice "Error [08] Error during execution"
2. UTF-8
In order to have utf suuport you have to do the following things.
- for database utf retrieval (mysql especially) go to common_start.php file, find the line:
$conn = connect_db($host, $user, $pass, $db_name);
and add the following 2 commands:
@mysql_query('SET NAMES utf8');
@mysql_query('SET CHARACTER SET utf8');
- As for the page utf support go to header.php
and just before the end of header
add the following line
3. Debugging
For those that make changes to the code or something goes wrong with their dadabik installation you can enable the debugging option and learn exactly what is the problem so that you can fix it.
To enable the debugging mode go to config.php and change the $debug_mode to 1.
For those that prefer to display the sql during the development process do the $display_sql = 1.
More on this.... later!
Σχόλια