Is there a good forms generator (my sql, php) ?

Looking for a forms generator that will work with mySQL database, and preferably be in php.

I have looked at a few forms generators, but have not found one that can
create forms (including dropdowns, filled from tables)
work with single column primary keys
work with multi-column primary keys

bonus:
allow easy CSS formatting

and extra bonus:
would be great if it creates validation code
would be extra great if it creates both server side and client side validation code

Your assistance in finding a good forms generator will be greatly appreciated. Free (open source) is great, but I'd be willing to pay a moderate fee.

Dennis
dtleahyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dtleahyAuthor Commented:
Note:  If the criteria is too strict, maybe just a good forms generator that will do SOME of the forms for me, and where I would have to supply code to do the forms and dropdowns that have multi-column primary keys.

-Dennis
0
GaryCommented:
I think you would have a hard time finding one that fills your criteria especially multi-column primary keys. Those form generators are really basic stuff to quickly build an add/edit/delete function quickly.
A few questions here and you could have you form built in no time.
0
dtleahyAuthor Commented:
This is for a new website and I am just designing the database now as well. I have always used composite (multi-column) primary keys on databases, where appropriate. I hate to think of designing the database without composite keys - just to make it easy for a forms generator to work easily.

I think I'll try the "FPMG" forms generator, and see how tedious it is to modify the SQL behind a form to properly work with a composite key.
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

GaryCommented:
modify the SQL behind
That was one solution I was going to offer, but as I said the multi key is the problem
If you start trying to modify the code it produces you may end up spending more time trying to fix it than if you just started from scratch
What you are asking to build is not really that difficult and could be accomplished in a few hours, after which add some styling.
0
dtleahyAuthor Commented:
...still looking...
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
dtleahyAuthor Commented:
Experts-exchange is asking me:  "Are you sure you would like to cancel the request to delete this question?"

Um, what? What are you actually trying to say?

I didn't ask for the question to be deleted. Maybe at some point, someone will come back to this and make a recommendation that is useful. Creating forms for a database with 17 tables (2 are programatically added to/edited, 15 need forms for add/edit/delete functionality, and several other forms (one is complex) need to be created to complete this project.

So, a form-generator would certainly be a huge time saver. I can see where this would seem trivial if just a single form is needed. This isn't a trivial project.
0
dtleahyAuthor Commented:
So, yes, I object to this being closed, and ask that it stay open indefinitely (waiting for a solution), or will be closed when a solution is found.
0
RobOwner (Aidellio)Commented:
Would an MVC based approach work for you?  like cakePHP (http://cakephp.org/).  You can create a view for each table etc.
0
dtleahyAuthor Commented:
Let's do this process the way it was meant to be done.

Please post that you'd like to continue the question and click the "object" button.

eenookami

I am running NoScript Facebook add-on. I have allowed all the scripts on experts-exchange except for google analytics and newrelic - neither of which should stop the site from working.

However, when I hit the "Object" button, nothing happens. Nothing gets posted.

Yes, I object to this being closed.
0
dtleahyAuthor Commented:
OK, let's forget the "indefinitely", and just say that I'd like to keep this question open. Still looking for a solution.

I tried allowing ALL scripts to run in this site (including google analytics and newrelic), and the "Object" button still does nothing. Mods, please hit the "Object" button for me.
0
dtleahyAuthor Commented:
What happened to Experts-Exchange? It now runs extremely slowly, and this "Object" functionality doesn't work at all. I closed and reopened my browser, with only one tab open (just EE) and no script blocking.

Mods, please hit the "Object" button for me, and then delete all of these extraneous posts regarding the "Object" functionality.
0
dtleahyAuthor Commented:
Thank you, Guy.

Thank you Rob jurd, for the CakePHP suggestion. I have downloaded it and I'm looking at it.
0
RobOwner (Aidellio)Commented:
No problem. It can take a while to get your head around the mvc methodology (unless you're already they're of course! ) so ask questions and I'll do my best to answer then for you.
0
dtleahyAuthor Commented:
The answer that I found is from StarSoft and is called MySQL Form Maker. http://mysqlreports.com/mysql-reporting-tools/php-mysql-form-generator/

It was not a free solution, but affordable.

I am going to mark this answer as "the answer", but award points to Gary and Rob for their efforts.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dtleahyAuthor Commented:
"Please state your reason for accepting your own comment as the solution."
Well, I find it to be the solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.