FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Dynamic form generation
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Dynamic form generation [message #177677 is a reply to message #177676] Fri, 13 April 2012 04:55 Go to previous messageGo to previous message
Michael Vilain is currently offline  Michael Vilain
Messages: 88
Registered: September 2010
Karma:
Member
In article
<6651622.883.1334288601914.JavaMail.geo-discussion-forums@vbbfj25>,
Charles <cchamb2(at)gmail(dot)com> wrote:

> Absolutely correct. The database has 34 active and 34 historical tables so
> far, and my guess is that about another dozen or so of each to create.
> I can visualize the relationships between the tables, and I'm normalizing
> as I go on table structure, but having to write and maintain somewhere
> around 150 scripts each and every time I so much as sneeze (add/remove a
> field or change a field type in any of the 100 tables) is daunting.
>
> I'm just as comfortable with calling a script to do crate each form as I need
> it.
>
> Any suggestions?
>
> On Thursday, April 12, 2012 5:42:15 AM UTC-7, Denis McMahon wrote:
>> On Wed, 11 Apr 2012 21:52:31 -0700, Michael Vilain wrote:
>>
>>> You'll have to read up on how to use php to access mysql (or
>>> whatever database you're using as a backend), display forms, and process
>>> them via get or post.
>>
>> I think he knows that much, what he's asking for is a bit more complex
>> than the very basic "how do I use php and mysql to generate web pages"
>> that you seem to not be answering.
>>
>> What he's talking about, specifically, is code that takes the output of
>> the sql query "describe <tablename>;" or "show columns from <tablename>"
>> and generates forms to enter, update or display the data in that table
>> based on the table structure.
>>
>> i.e. first of all taking the output of the describe <tablename> / show
>> columns from <tablename> query, generating a list of fieldnames and
>> datatypes, and then generating suitable forms / tables etc to display /
>> enter / update those values and insert into / update the tables as
>> appropriate.
>>
>> Rgds
>>
>> Denis McMahon

I don't know of any php tools that will automatically generate
display/modify/delete forms for specific tables if you just give them
the table layout. I think you're stuck coding and maintaining each form
by hand.

I've heard Java does this sort of thing automatically. Seriously. When
you change the class in Java, apparently there are libraries that will
change the forms automatically.

There's no real short cut. If there was, a lot of php developers would
be out of work.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Data injection problems
Next Topic: Do you want to develop PHP for the Web and make money
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 19:29:28 GMT 2024

Total time taken to generate the page: 0.04205 seconds