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 #177676 is a reply to message #177657]

Fri, 13 April 2012 03:43

Charles
Messages: 13
Registered: February 2011

Karma:

Junior Member

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

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: Sat Nov 23 05:28:14 GMT 2024

Total time taken to generate the page: 0.05290 seconds