Today, we have released RenownedDatabase, an easily integrated MySQL Database manager. Please click here for a live demo, no authentication required.
RenownedDatabase is an easy to integrate database manager. What this means is you, as a developer, can simplify the creation of your sites admin panel by simply installing RenownedDatabase in the backend.
RenownedDatabase handles all your CRUD needs (CReation, Updating, Deleting of records) for your database tables. Don’t want your users browsing certain databases or tables? We have included a blacklisting feature which allows you to specify an array of un-approved databases or database tables.
This script also handles one to many relationships. By editing an employee table with a field named “business_id”, it will go to a table named “business” where the Primary Key field equals the value of the “business_id” field, and build a dropdown with all the businesses from that table. This prevents your end user from having to temporarily memorize a businesses “id” and putting it into to employee table.
RenownedDatabase does require some standardized naming conventions (nomenclature) to work properly. Every table this app works with will need a Primary Key, and for the one-to-many relationships, the table will also need a field named “name” for the dropdown selection. Tables without a PK can only be browsed and have fields added to it.
Features:
- Easily integrated into any web application (live demo required no modifications)
- Simplifies building admin panels for web developers
- Handles one-to-many relationships with a dropdown select menu
- Features a blacklist for both databases and database tables
- You can either leave all databases open or specify only one database
- Handles Creation, Updating, and Deleting (CRUD)
- Works with tables the developer defines (user cannot create or modify)
- All PHP is included in one single file and URLs do not require a specific filename
RenownedDatabase is available for purchase at ThemeForest for $5.00 per domain. If you would like to integrate this script into re-distributable applications, please contact us and we can work out a smaller price and contract.
I need to provide client access to a MySQL database which contains a variety of user statistics. Each client will login and have access to only those users associated with each client.
I couldn’t tell if RenownedDatabase will work for us in this situation.
Pls advise. Looks like a very nice product and we’d like to find a way to use it.
John Fox
Venture Marketing
You could purchase this, and add something to your MySQL queries along the lines of this:
“WHERE client_id = {$_SESSION['client_id']}”
That could be a quick way to modify the application to work in your environment, however if you are working with tables where the ownerships isn’t immediately obvious (e.g. you’d have to run a join to see who the parent is) it may be a bit more hard to integrate in the way you would like.
Otherwise, no, this application doesn’t work that way out of the box as there is no way to know everyone’s database constraints.