Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #5812
| From | Charles <cchamb2@gmail.com> |
|---|---|
| Newsgroups | comp.lang.php |
| Subject | Re: Dynamic form generation |
| Date | 2012-05-03 15:23 -0700 |
| Organization | http://groups.google.com |
| Message-ID | <10862707.26.1336083819692.JavaMail.geo-discussion-forums@ynbq3> (permalink) |
| References | <7262665.439.1334202496427.JavaMail.geo-discussion-forums@vbgx21> <vilain-8CE047.21522911042012@news.individual.net> <4f86cda7$0$2912$a8266bb1@newsreader.readnews.com> <6651622.883.1334288601914.JavaMail.geo-discussion-forums@vbbfj25> <bWRhr.125797$Js7.110892@fx16.am4> |
Actually, phpmyedit has removed the back end support problems. It wrote a php script that works with a php class to create custom data entry forms usable from a support perspective. Now all I need is the front facing (customer/end user) forms, and they change a lot easier. On to multitable data entry! On Friday, April 13, 2012 1:59:52 AM UTC-7, Tony Marston wrote: > "Charles" <cchamb2@gmail.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 wII found the answer to this one. I can rite 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 On Friday, April 13, 2012 1:59:52 AM UTC-7, Tony Marston wrote: > "Charles" <cchamb2@gmail.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 On Friday, April 13, 2012 1:59:52 AM UTC-7, Tony Marston wrote: > "Charles" <cchamb2@gmail.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 On Friday, April 13, 2012 1:59:52 AM UTC-7, Tony Marston wrote: > "Charles" <cchamb2@gmail.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 On Friday, April 13, 2012 1:59:52 AM UTC-7, Tony Marston wrote: > "Charles" <cchamb2@gmail.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
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Dynamic form generation Charles <cchamb2@gmail.com> - 2012-04-11 20:48 -0700
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 00:03 -0400
Re: Dynamic form generation The Natural Philosopher <tnp@invalid.invalid> - 2012-04-12 05:46 +0100
Re: Dynamic form generation Michael Vilain <vilain@NOspamcop.net> - 2012-04-11 21:52 -0700
Re: Dynamic form generation Denis McMahon <denismfmcmahon@gmail.com> - 2012-04-12 12:42 +0000
Re: Dynamic form generation Charles <cchamb2@gmail.com> - 2012-04-12 20:43 -0700
Re: Dynamic form generation Michael Vilain <vilain@NOspamcop.net> - 2012-04-12 21:55 -0700
Re: Dynamic form generation Denis McMahon <denismfmcmahon@gmail.com> - 2012-04-13 13:19 +0000
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-13 09:59 +0100
Re: Dynamic form generation Denis McMahon <denismfmcmahon@gmail.com> - 2012-04-13 13:22 +0000
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-17 14:49 +0200
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-17 11:36 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-18 09:33 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-18 07:59 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-19 09:56 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-19 08:29 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-20 09:27 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-20 07:47 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-21 12:22 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-21 10:19 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-22 11:45 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-22 10:09 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-24 18:21 +0100
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-24 20:56 +0200
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-25 09:23 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-24 16:20 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-25 10:04 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-25 08:29 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-26 12:45 +0100
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-22 19:21 +0200
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-23 13:50 +0100
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-24 11:10 +0200
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-24 17:11 +0100
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-24 18:54 +0200
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-24 18:55 +0100
[OT] Was: Dynamic form generation Erwin Moller <erwinmollerusenet@xs4all.nl> - 2012-04-25 13:22 +0200
Re: [OT] Was: Dynamic form generation The Natural Philosopher <tnp@invalid.invalid> - 2012-04-25 12:46 +0100
Re: [OT] Was: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-26 12:51 +0100
Re: [OT] Was: Dynamic form generation Erwin Moller <erwinmollerusenet@xs4all.nl> - 2012-04-27 10:26 +0200
[OT] Yes-or-no questions (was: [OT] Was: Dynamic form generation) Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-28 07:56 +0200
Re: Dynamic form generation "Peter H. Coffin" <hellsop@ninehells.com> - 2012-04-14 08:53 -0500
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-15 08:33 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-15 08:51 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-16 09:31 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-16 08:33 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-16 15:11 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-16 11:18 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-17 09:18 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-17 06:07 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-18 09:10 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-18 08:09 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-19 09:27 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-19 08:41 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-20 10:10 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-20 08:09 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-21 10:35 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-21 06:21 -0400
Re: Dynamic form generation "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-22 10:27 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-22 10:43 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-23 15:23 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-23 12:24 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-26 17:29 +0100
Re: Dynamic form generation The Natural Philosopher <tnp@invalid.invalid> - 2012-04-23 20:37 +0100
What Jerry Stuckle thinks of PHP programmers "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-23 14:10 +0100
Re: What Jerry Stuckle thinks of PHP programmers Paul Herber <paul@pherber.com> - 2012-04-23 14:22 +0100
Re: What Jerry Stuckle thinks of PHP programmers "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-04-23 15:27 +0200
Re: What Jerry Stuckle thinks of PHP programmers Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-23 09:33 -0400
Re: What Jerry Stuckle thinks of PHP programmers "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-23 15:26 +0100
Re: What Jerry Stuckle thinks of PHP programmers Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-23 12:25 -0400
Re: What Jerry Stuckle thinks of PHP programmers Luuk <luuk@invalid.lan> - 2012-04-23 19:45 +0200
Re: What Jerry Stuckle thinks of PHP programmers The Natural Philosopher <tnp@invalid.invalid> - 2012-04-23 20:35 +0100
Re: What Jerry Stuckle thinks of PHP programmers Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-24 19:45 +0200
Re: What Jerry Stuckle thinks of PHP programmers "Tony Marston" <TonyMarston@hotmail.com> - 2012-04-28 08:48 +0100
Re: What Jerry Stuckle thinks of PHP programmers The Natural Philosopher <tnp@invalid.invalid> - 2012-04-28 09:23 +0100
Re: What Jerry Stuckle thinks of PHP programmers Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-28 08:37 -0400
Re: What Jerry Stuckle thinks of PHP programmers Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-28 14:46 +0200
Re: What Jerry Stuckle thinks of PHP programmers The Natural Philosopher <tnp@invalid.invalid> - 2012-04-23 20:31 +0100
Re: What Jerry Stuckle thinks of PHP programmers Ross McKay <au.org.zeta.at.rosko@invalid.invalid> - 2012-04-24 12:32 +1000
Re: What Jerry Stuckle thinks of PHP programmers Tim Streater <timstreater@greenbee.net> - 2012-04-24 19:32 +0100
Re: What Jerry Stuckle thinks of PHP programmers Ross McKay <au.org.zeta.at.rosko@invalid.invalid> - 2012-04-25 19:02 +1000
Re: What Jerry Stuckle thinks of PHP programmers The Natural Philosopher <tnp@invalid.invalid> - 2012-04-25 12:20 +0100
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-22 23:59 +0200
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-23 14:05 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-23 09:35 -0400
Re: Dynamic form generation Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-23 15:41 +0200
Re: Dynamic form generation The Natural Philosopher <tnp@invalid.invalid> - 2012-04-23 20:39 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-23 09:47 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-25 08:52 +0100
Re: Dynamic form generation Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-25 08:34 -0400
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-27 09:52 +0100
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-27 14:16 +0100
Re: Dynamic form generation Charles <cchamb2@gmail.com> - 2012-05-03 15:23 -0700
Re: Dynamic form generation "Tony Marston" <tony@NOSPAM.demon.co.uk> - 2012-04-12 10:52 +0100
Re: Dynamic form generation Erwin Moller <erwinmollerusenet@xs4all.nl> - 2012-04-13 11:39 +0200
Re: Dynamic form generation Jonathan Stein <jstein@image.dk> - 2012-04-13 15:27 +0200
csiph-web