FUDforum: comp.lang.php » Dynamic form generation

Home » Imported messages » comp.lang.php » Dynamic form generation

Show: Today's Messages :: Polls :: Message Navigator

Re: Dynamic form generation [message #177679 is a reply to message #177676]

Fri, 13 April 2012 08:59

Tony Marston
Messages: 57
Registered: November 2010

Karma:

Member

"Charles" <cchamb2(at)gmail(dot)com> wrote in message
news:6651622.883.1334288601914.JavaMail.geo-discussion-forums@vbbfj25...
> 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?

If you used a proper framework then you wouldn't have to do so much work for
a minor database change. If you used radicore all you would have to do is
re-import the table's structure into the data dictionary and then export the
updated structure to replace the table's structure file. The only time you
would need to modify another script would be if you needed to change the
screen structure (by modifying a small screen structure file) or a business
rule (by modifying that table's class file).

A lot of simple changes, such as a field's size, can be achieved with a
simple import/export without having to modify any scripts at all.

Tony Marston

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

Report message to a moderator

[Message index]

		Dynamic form generation By: Charles on Thu, 12 April 2012 03:48
		Re: Dynamic form generation By: Jerry Stuckle on Thu, 12 April 2012 04:03
		Re: Dynamic form generation By: The Natural Philosoph on Thu, 12 April 2012 04:46
		Re: Dynamic form generation By: Michael Vilain on Thu, 12 April 2012 04:52
		Re: Dynamic form generation By: Denis McMahon on Thu, 12 April 2012 12:42
		Re: Dynamic form generation By: Charles on Fri, 13 April 2012 03:43
		Re: Dynamic form generation By: Michael Vilain on Fri, 13 April 2012 04:55
		Re: Dynamic form generation By: Denis McMahon on Fri, 13 April 2012 13:19
		Re: Dynamic form generation By: Tony Marston on Fri, 13 April 2012 08:59
		Re: Dynamic form generation By: Denis McMahon on Fri, 13 April 2012 13:22
		Re: Dynamic form generation By: Thomas 'PointedEars' on Tue, 17 April 2012 12:49
		Re: Dynamic form generation By: Jerry Stuckle on Tue, 17 April 2012 15:36
		Re: Dynamic form generation By: Tony Marston on Wed, 18 April 2012 08:33
		Re: Dynamic form generation By: Jerry Stuckle on Wed, 18 April 2012 11:59
		Re: Dynamic form generation By: Tony Marston on Thu, 19 April 2012 08:56
		Re: Dynamic form generation By: Jerry Stuckle on Thu, 19 April 2012 12:29
		Re: Dynamic form generation By: Tony Marston on Fri, 20 April 2012 08:27
		Re: Dynamic form generation By: Jerry Stuckle on Fri, 20 April 2012 11:47
		Re: Dynamic form generation By: Tony Marston on Sat, 21 April 2012 11:22
		Re: Dynamic form generation By: Jerry Stuckle on Sat, 21 April 2012 14:19
		Re: Dynamic form generation By: Tony Marston on Sun, 22 April 2012 10:45
		Re: Dynamic form generation By: Jerry Stuckle on Sun, 22 April 2012 14:09
		Re: Dynamic form generation By: Tony Marston on Tue, 24 April 2012 17:21
		Re: Dynamic form generation By: Thomas 'PointedEars' on Tue, 24 April 2012 18:56
		Re: Dynamic form generation By: Tony Marston on Wed, 25 April 2012 08:23
		Re: Dynamic form generation By: Jerry Stuckle on Tue, 24 April 2012 20:20
		Re: Dynamic form generation By: Tony Marston on Wed, 25 April 2012 09:04
		Re: Dynamic form generation By: Jerry Stuckle on Wed, 25 April 2012 12:29
		Re: Dynamic form generation By: Tony Marston on Thu, 26 April 2012 11:45
		Re: Dynamic form generation By: Thomas 'PointedEars' on Sun, 22 April 2012 17:21
		Re: Dynamic form generation By: Tony Marston on Mon, 23 April 2012 12:50
		Re: Dynamic form generation By: Thomas 'PointedEars' on Tue, 24 April 2012 09:10
		Re: Dynamic form generation By: Tony Marston on Tue, 24 April 2012 16:11
		Re: Dynamic form generation By: Thomas 'PointedEars' on Tue, 24 April 2012 16:54
		Re: Dynamic form generation By: Tony Marston on Tue, 24 April 2012 17:55
		[OT] Was: Dynamic form generation By: Erwin Moller on Wed, 25 April 2012 11:22
		Re: [OT] Was: Dynamic form generation By: The Natural Philosoph on Wed, 25 April 2012 11:46
		Re: [OT] Was: Dynamic form generation By: Tony Marston on Thu, 26 April 2012 11:51
		Re: [OT] Was: Dynamic form generation By: Erwin Moller on Fri, 27 April 2012 08:26
		[OT] Yes-or-no questions (was: [OT] Was: Dynamic form generation) By: Thomas 'PointedEars' on Sat, 28 April 2012 05:56
		Re: Dynamic form generation By: Peter H. Coffin on Sat, 14 April 2012 13:53
		Re: Dynamic form generation By: Tony Marston on Sun, 15 April 2012 07:33
		Re: Dynamic form generation By: Jerry Stuckle on Sun, 15 April 2012 12:51
		Re: Dynamic form generation By: Tony Marston on Mon, 16 April 2012 08:31
		Re: Dynamic form generation By: Jerry Stuckle on Mon, 16 April 2012 12:33
		Re: Dynamic form generation By: Tony Marston on Mon, 16 April 2012 14:11
		Re: Dynamic form generation By: Jerry Stuckle on Mon, 16 April 2012 15:18
		Re: Dynamic form generation By: Tony Marston on Tue, 17 April 2012 08:18
		Re: Dynamic form generation By: Jerry Stuckle on Tue, 17 April 2012 10:07
		Re: Dynamic form generation By: Tony Marston on Wed, 18 April 2012 08:10
		Re: Dynamic form generation By: Jerry Stuckle on Wed, 18 April 2012 12:09
		Re: Dynamic form generation By: Tony Marston on Thu, 19 April 2012 08:27
		Re: Dynamic form generation By: Jerry Stuckle on Thu, 19 April 2012 12:41
		Re: Dynamic form generation By: Tony Marston on Fri, 20 April 2012 09:10
		Re: Dynamic form generation By: Jerry Stuckle on Fri, 20 April 2012 12:09
		Re: Dynamic form generation By: Tony Marston on Sat, 21 April 2012 09:35
		Re: Dynamic form generation By: Jerry Stuckle on Sat, 21 April 2012 10:21
		Re: Dynamic form generation By: Tony Marston on Sun, 22 April 2012 09:27
		Re: Dynamic form generation By: Jerry Stuckle on Sun, 22 April 2012 14:43
		Re: Dynamic form generation By: Tony Marston on Mon, 23 April 2012 14:23
		Re: Dynamic form generation By: Jerry Stuckle on Mon, 23 April 2012 16:24
		Re: Dynamic form generation By: Tony Marston on Thu, 26 April 2012 16:29
		Re: Dynamic form generation By: The Natural Philosoph on Mon, 23 April 2012 19:37
		What Jerry Stuckle thinks of PHP programmers By: Tony Marston on Mon, 23 April 2012 13:10
		Re: What Jerry Stuckle thinks of PHP programmers By: Paul Herber on Mon, 23 April 2012 13:22
		Re: What Jerry Stuckle thinks of PHP programmers By: M. Strobel on Mon, 23 April 2012 13:27
		Re: What Jerry Stuckle thinks of PHP programmers By: Jerry Stuckle on Mon, 23 April 2012 13:33
		Re: What Jerry Stuckle thinks of PHP programmers By: Tony Marston on Mon, 23 April 2012 14:26
		Re: What Jerry Stuckle thinks of PHP programmers By: Jerry Stuckle on Mon, 23 April 2012 16:25
		Re: What Jerry Stuckle thinks of PHP programmers By: Luuk on Mon, 23 April 2012 17:45
		Re: What Jerry Stuckle thinks of PHP programmers By: The Natural Philosoph on Mon, 23 April 2012 19:35
		Re: What Jerry Stuckle thinks of PHP programmers By: Thomas 'PointedEars' on Tue, 24 April 2012 17:45
		Re: What Jerry Stuckle thinks of PHP programmers By: Tony Marston on Sat, 28 April 2012 07:48
		Re: What Jerry Stuckle thinks of PHP programmers By: The Natural Philosoph on Sat, 28 April 2012 08:23
		Re: What Jerry Stuckle thinks of PHP programmers By: Jerry Stuckle on Sat, 28 April 2012 12:37
		Re: What Jerry Stuckle thinks of PHP programmers By: Thomas 'PointedEars' on Sat, 28 April 2012 12:46
		Re: What Jerry Stuckle thinks of PHP programmers By: The Natural Philosoph on Mon, 23 April 2012 19:31
		Re: What Jerry Stuckle thinks of PHP programmers By: Ross McKay on Tue, 24 April 2012 02:32
		Re: What Jerry Stuckle thinks of PHP programmers By: Tim Streater on Tue, 24 April 2012 18:32
		Re: What Jerry Stuckle thinks of PHP programmers By: Ross McKay on Wed, 25 April 2012 09:02
		Re: What Jerry Stuckle thinks of PHP programmers By: The Natural Philosoph on Wed, 25 April 2012 11:20
		Re: Dynamic form generation By: Thomas 'PointedEars' on Sun, 22 April 2012 21:59
		Re: Dynamic form generation By: Tony Marston on Mon, 23 April 2012 13:05
		Re: Dynamic form generation By: Jerry Stuckle on Mon, 23 April 2012 13:35
		Re: Dynamic form generation By: Thomas 'PointedEars' on Mon, 23 April 2012 13:41
		Re: Dynamic form generation By: The Natural Philosoph on Mon, 23 April 2012 19:39
		Re: Dynamic form generation By: Jerry Stuckle on Mon, 23 April 2012 13:47
		Re: Dynamic form generation By: Tony Marston on Wed, 25 April 2012 07:52
		Re: Dynamic form generation By: Jerry Stuckle on Wed, 25 April 2012 12:34
		Re: Dynamic form generation By: Tony Marston on Fri, 27 April 2012 08:52
		Re: Dynamic form generation By: Tony Marston on Fri, 27 April 2012 13:16
		Re: Dynamic form generation By: Tony Marston on Thu, 12 April 2012 09:52
		Re: Dynamic form generation By: Erwin Moller on Fri, 13 April 2012 09:39
		Re: Dynamic form generation By: Jonathan Stein on Fri, 13 April 2012 13:27

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) ] [

]

Current Time: Fri Nov 22 19:43:04 GMT 2024

Total time taken to generate the page: 0.05080 seconds