|
Database software to design web databases that provides
all the power and features you would expect from a
professional database application.
If your web host or current server supports PHP MySQL and
you want to publish a web database right away you should take
a serious look at our database software. If you are somewhat
familiar with MS Access or MS Excel than building your database
with PHPMagic Plus will be very easy. Our database
software provides an intuitive user interface for easy database
design. With PHPMagic plus if you can name a table
and add some fields, the software does the rest.
Database software that creates the installation
script to build the mysql database and all the php forms to
interface with the database. |
|
PHPMagic Plus is software that runs on your windows pc. It is used to build/design a php/mysql database. The possibilities on how to use a database are endless. PHPMagic Plus offers you the ability to quickly create MySQL tables & fields, structure, foreign keys with no prior knowledge of PHP or MySQL coding. You simply create the database tables and fields and the software generates the scripts to upload to your website to setup the MySQL tables and the scripts to manage the tables.
| |
You do not need to have any php/mysql programming experience
at all. With our database software you do not have to
write one line of code! |
| |
Instantly publish PHP MySQL database applications ready
for uploading to your website. |
| |
Manage your database and member access with ease. |
| |
Automatic generation of php forms to display and browse
data content of tables, with the ability to edit, delete
and add records. |
| |
Data navigation, sorting, searching, search filtering,
modification, addition, deletion, file uploads, generate reports.. |
|
Database Software features of PHPMagic Plus
The system allows an admin to log into an admin area where he can define groups, group members, and group permissions. The security system is group-based. This means that each group is assigned some permissions to some tables. And any member of a group automatically inherits those permissions. Admin interface Screenshot
For example, let's say we have an "articles" table, and an "article categories" table. We define an "editors" group, and allow this group to add, delete and edit records of the "articles" table, but only view records of "article categories". On the other hand, an "employees" group is allowed to add and edit "article categories", but not "articles".
This group-based security system makes it very easy to define users. Instead of assigning permissions of each user individually, all that an admin needs to do is define groups and group permissions, and add users to the appropriate groups. Users can sign up using a sign-up form, or can be manually added by the admin.
Permissions that can be assigned to groups:
The admin interface allows assigning some or all of the following permissions to each group per table:
- Allow insert (group members can add records to the table)
- Allow editing by owner (each member of the group can edit his own records)
- Allow editing by group (each member of the group can edit any record created by any member of the group)
- Allow editing of any record (each member of the group can edit any record in the table)
- Allow deleting by owner
- Allow deleting by group
- Allow deleting of any record
- Allow viewing by owner
- Allow viewing by group
- Allow viewing of any record
To explain what the admin interface can do.
The admin interface is accessed using an admin username and password.
The homepage, after successful admin login, displays the following items:
Add new group page:
This page asks for the following data about the new group: group name, description, whether to allow visitors to sign up to join the group, or only add them through the admin interface, and finally the permissions assigned to the group for each table.
View groups page:
Lists groups, and provides a link for: adding members to each, viewing data entered by group members, view members, delete group (must be empty of members and data records to delete), and send an email message to group members. A search box on top of the page makes it easy to search for a group by name or description. Clicking on a group name opens the group for editing in a page similar to the "Add new group" page.
Add new user page:
Asks for username, password, confirm password, email, group, and up to 4 custom-defined fields (could be defined as "job title", "city", "state", "zip", "country" ... etc from the admin options page)
View users page:
Lists registered users, and allows filtering them by group and other criteria, and allows searching them. The admin can select a user for viewing/editing his details, or check multiple users for banning, deleting, unbanning, sending an email message, or approve new member registrations.
View records:
Lists data records entered by one or more users/groups. Can be filtered by group, by user, or by entry/modification date.
Admin options:
Allows admin to change his username/password, define the titles of the 4 custom fields allowed for users, define a default sender name and email to be used when sending messages to groups or users, run reports.. etc.
The admin can control what anonymous users can do by assigning the appropriate permissions to a group named "anonymous". |
