ASP/PHP Web Database Interface
Builder (AWDIB) is a Rapid Application Development (RAD) tool
to create a secure interface to your online database, which
will allow you to add/search/edit and delete data.
Now there is no need to download/modify/upload your database
(which causes downtime and sometimes even data corruption),
or wrestle with DAP (nice in theory, but complex to get
working, and slow with big tables) AWDIB code requires no
external DLLs or plug-ins, so you can use it even if your
ISP doesn't allow installation of components.
Without writing a single line of code AWDIB gives you security,
advanced data validation and searching capabilities. However,
if you are an ASP/PHP software developer (or you take advantage
of our development services) then there is nothing to stop
you taking the code further. For example we use it ourselves
to slash development time when building intranets. AWDIB
generates pure ASP/PHP code which can be tailored to your
exact requirements.
In addition, you can set it up to allow anonymous users
to search your database - you choose which tables/fields
they get to see.
ASP/PHP Web Database Interface Builder Suggested Uses
Online Content Database Management
Publicly Searchable Database
Members Only Searchable Database
Basis of Intranet System
In fact, any web application where you need to interact
with a database.
ASP/PHP Web Database Interface Builder Main Features
Security
Authenticate users against a database table or authorization
list
Administrator can control table/field level view/edit access
for each group of users.
Data Entry
Prevents users from accidentally entering text in a numeric
field.
Facility to restrict allowable characters in a text field
(e.g. Y/N).
Drop down Calendar component makes date entry easier.
Search
Administrator decides which fields should be searchable
and which should appear on the results grid.
Flexible Search Options: "Equals", "Like"
(wildcard search), and "Between" (Range).
Allows complex multi-field searches.
Paged Result grid.
Compatibility
Windows Host (ASP)
Microsoft Access
SQL Server
Oracle (Coming Soon)
mySQL
Linux/Unix Host (PHP)
mySQL