• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

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.


0
Gary Fuqua, CISSP
Asked:
Gary Fuqua, CISSP
1 Solution
 
icenickCommented:
Why don't you try the free PHPMyAdmin?

http://www.phpmyadmin.net/

I hope it's what you are looking for?
0
 
Gary Fuqua, CISSPOwnerAuthor Commented:
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.    
0
 
icenickCommented:
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.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
Gary Fuqua, CISSPOwnerAuthor Commented:
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.  
0
 
icenickCommented:
Wish you good luck.
0
 
Loganathan NatarajanLAMP DeveloperCommented:
Hi,

Try with CakePHP... you can easily develop this application.. but you need PHP & MySQL

ref.

http://cakephp.org/
http://net.tutsplus.com/tutorials/php/getting-started-with-cakephp/
0
 
Ray PaseurCommented:
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
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now