Gary Fuqua, CISSP
asked on
Recommendation for application builder
I have a three table normalized MySQL database. I am not up for writing an a PHP application from scratch.
I need to find an easy to use application/page generator program to allow me to create the following PHP pages:
Add/Edit/remove records from two stand alone tables
Add/Edit/remove records from a table join of two tables
Create queries using all three tables.
Any suggestions for a cheap (under $100) but good tool?
I was hoping to find something as simple to use as MS Access.
I need to find an easy to use application/page generator program to allow me to create the following PHP pages:
Add/Edit/remove records from two stand alone tables
Add/Edit/remove records from a table join of two tables
Create queries using all three tables.
Any suggestions for a cheap (under $100) but good tool?
I was hoping to find something as simple to use as MS Access.
ASKER
Thanks for the suggestion. This is not quite what i am looking for. This will work for my admin stuff, but not for users.
I need to generate a few queries that are requested by users from a website. I don't want to give users full access to the database.
I need to generate a few queries that are requested by users from a website. I don't want to give users full access to the database.
Dear GaryFuqua,
As far as I know you can create users and grant them access. You can grant only "select" access for a certain user on a certain database.
I have never done it since I always work as root.
Good luck.
As far as I know you can create users and grant them access. You can grant only "select" access for a certain user on a certain database.
I have never done it since I always work as root.
Good luck.
ASKER
Thanks Icenick, but this isn't going to work. I need to restrict access more than is allowed with this tool as well as create screens with specific purpose.
There has to be something out there that can help with rapid app development.
There has to be something out there that can help with rapid app development.
Wish you good luck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with logudotcom - CakePHP could be a solution. You might also consider one of the CMS systems - Joomla, Drupal or Wordpress. They have very attractive use interfaces and lots of plugins available in open source.
In the end, what you need are called "table maintenance scripts" and they are easy for an experienced developer, so if you choose to hire someone instead of using one of the free tools, you will not find a big cost in front of you.
Good luck, ~Ray
In the end, what you need are called "table maintenance scripts" and they are easy for an experienced developer, so if you choose to hire someone instead of using one of the free tools, you will not find a big cost in front of you.
Good luck, ~Ray
http://www.phpmyadmin.net/
I hope it's what you are looking for?