|
Put a Face to your Database
Here's a simple solution for you to give a frontend to your database with all the functionalities that you would like to have
Rakesh Sharma
Friday, June 29, 2007
Dataface is an Open Source application for developers, which is used for
creating frontend in PHP for MySQL in minutes with all those functionalities. It
automatically generates a webpage with appropriates forms, lists and menus,
which helps users to interact with the database without having to remember any
SQL command.
You can configure its features and behavior by modifying its configuration
file. If in future you have the requirement to modify the database, for eg,
adding one more column to it, you don't have to care about the frontend part.
This is because the page associated to it will automatically get updated as they
are dynamically generated using the database schema. This will reduce the effort
of maintaining the website. Let's see how you can make data driven applications
using Dataface.
| Direct Hit! |
|
Applies To: Developers
USP: Creating front-end for your
database
Primary Link:
http://fas.sfu.ca/ dataface
Google Keywords: dataface
|
Setup
Before starting you need to have PHP 4.3 and MySQL 3.2.3 or higher version
installed on your Linux system. If you do not have these packages installed on
the system, then you can simply download XAMPP package and install it. Download
'dataface-0.7.1.tar' file from the Dataface website, unpack this file and place
it in Web server root directory. Make the 'templates_c' directory writable by
the Web server which you will find inside Dataface directory. You can do so by
the following command:
# chmod 777 Dataface/templates_c
Now, check if the installation is successfully done. You can do it by simply
writing the following path on your Web browser:
http://your-web-server-ipaddress/path-of-dataface-directory/dataface_info.php
If it is successfully installed on the system, then you will see installation
status as 'INSTALLED CORRECTLY.' It also provides you with some additional
information. It shows you the path to template directory and the path to
template compile directory.
 |
 |
| Use myPHPAdim to create a sample
database for testing purpose |
Whenever a table is created in
myPHPAdim, it also creates the SQL codes simultaneously |
Page(s) 1 2
|
