Link to home
Create AccountLog in
Avatar of dtleahy
dtleahyFlag for United States of America

asked on

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
Avatar of dtleahy
dtleahy
Flag of United States of America image

ASKER

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
Avatar of Gary
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.
Avatar of dtleahy

ASKER

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.
SOLUTION
Avatar of Gary
Gary
Flag of Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of dtleahy

ASKER

...still looking...
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
Avatar of dtleahy

ASKER

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.
Avatar of dtleahy

ASKER

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.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of dtleahy

ASKER

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.
Avatar of dtleahy

ASKER

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.
Avatar of dtleahy

ASKER

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.
Avatar of dtleahy

ASKER

Thank you, Guy.

Thank you Rob jurd, for the CakePHP suggestion. I have downloaded it and I'm looking at it.
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of dtleahy

ASKER

"Please state your reason for accepting your own comment as the solution."
Well, I find it to be the solution.