Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #9667 > unrolled thread
| Started by | Charles <cchamb2@gmail.com> |
|---|---|
| First post | 2013-05-27 14:12 -0700 |
| Last post | 2013-06-24 05:28 +0000 |
| Articles | 18 — 11 participants |
Back to article view | Back to comp.lang.php
PHP form generator Charles <cchamb2@gmail.com> - 2013-05-27 14:12 -0700
Re: PHP form generator "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2013-05-27 23:45 +0200
Re: PHP form generator Charles <cchamb2@gmail.com> - 2013-05-27 15:34 -0700
Re: PHP form generator Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-05-28 02:14 +0200
Re: PHP form generator Charles <cchamb2@gmail.com> - 2013-05-28 08:17 -0700
Re: PHP form generator "Peter H. Coffin" <hellsop@ninehells.com> - 2013-05-27 20:01 -0500
Re: PHP form generator The Natural Philosopher <tnp@invalid.invalid> - 2013-05-28 05:46 +0100
Re: PHP form generator Michael Vilain <vilain@NOspamcop.net> - 2013-05-27 14:48 -0700
Re: PHP form generator Twayne <nobody@spamcop.net> - 2013-05-27 19:35 -0400
Re: PHP form generator "Tony Marston" <TonyMarston@hotmail.com> - 2013-05-28 07:25 +0100
Re: PHP form generator Jerry Stuckle <jstucklex@attglobal.net> - 2013-05-28 12:24 -0400
Re: PHP form generator "Tony Marston" <TonyMarston@hotmail.com> - 2013-05-29 07:08 +0100
Re: PHP form generator Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-05-29 12:26 +0200
Re: PHP form generator Jerry Stuckle <jstucklex@attglobal.net> - 2013-05-29 07:24 -0400
Re: PHP form generator Charles <cchamb2@gmail.com> - 2013-05-29 08:59 -0700
Re: PHP form generator Jerry Stuckle <jstucklex@attglobal.net> - 2013-05-29 12:29 -0400
Re: PHP form generator Jonathan Stein <jstein@image.dk> - 2013-05-29 13:00 +0200
Re: PHP form generator Mladen Gogala <gogala.mladen@gmail.com> - 2013-06-24 05:28 +0000
| From | Charles <cchamb2@gmail.com> |
|---|---|
| Date | 2013-05-27 14:12 -0700 |
| Subject | PHP form generator |
| Message-ID | <ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com> |
Does anyone have software they can suggest for generating an HTML input form and the php backend script for adding records to a database? I'm developing a web application, and I'm about half way through the MySQL end of it, but I'm daunted by the idea of hand coding 35'ish HTML and php files for data entry. Has anyone written software that takes the MySQL structure and generates both an HTML input page suitable for editing and the php script that links it to the MySQL table it's based upon?
[toc] | [next] | [standalone]
| From | "M. Strobel" <sorry_no_mail_here@nowhere.dee> |
|---|---|
| Date | 2013-05-27 23:45 +0200 |
| Message-ID | <b0i2gkFhhiaU1@mid.uni-berlin.de> |
| In reply to | #9667 |
Am 27.05.2013 23:12, schrieb Charles: > Does anyone have software they can suggest for generating an HTML input form and the php backend script for adding records to a database? > > I'm developing a web application, and I'm about half way through the MySQL end of it, but I'm daunted by the idea of hand coding 35'ish HTML and php files for data entry. > > Has anyone written software that takes the MySQL structure and generates both an HTML input page suitable for editing and the php script that links it to the MySQL table it's based upon? > Could you be more precise? The internet search for php form generator turns up a lot of hits. The problem has been solved many times, but every time with different dependencies. In this NG you will generally find people who prefer to code it themselves instead of trying to read, analyze and debug other people's code. /Str.
[toc] | [prev] | [next] | [standalone]
| From | Charles <cchamb2@gmail.com> |
|---|---|
| Date | 2013-05-27 15:34 -0700 |
| Message-ID | <2ca7c5bc-d7fb-4c55-a12d-129510dd2fd3@googlegroups.com> |
| In reply to | #9668 |
On Monday, May 27, 2013 2:45:56 PM UTC-7, M. Strobel wrote: > Am 27.05.2013 23:12, schrieb Charles: > > > Does anyone have software they can suggest for generating an HTML input form and the php backend script for adding records to a database? > > > > > > I'm developing a web application, and I'm about half way through the MySQL end of it, but I'm daunted by the idea of hand coding 35'ish HTML and php files for data entry. > > > > > > Has anyone written software that takes the MySQL structure and generates both an HTML input page suitable for editing and the php script that links it to the MySQL table it's based upon? > > > > > > > Could you be more precise? The internet search for php form generator turns up a lot > > of hits. > > > > The problem has been solved many times, but every time with different dependencies. > > In this NG you will generally find people who prefer to code it themselves instead of > > trying to read, analyze and debug other people's code. > > > > /Str. Sure. The database backend is second nature. I can create the tables and normalize them at the same time, and the interrelationship should be quite valid. What I'd like to find is use a software package that will retrieve the table structure and create both a generic input form in HTML, as well as the corresponding PHP script to go with it, for that table. That way, I can start cutting and pasting blocks of code instead of having to write it character by character, line by line.
[toc] | [prev] | [next] | [standalone]
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Date | 2013-05-28 02:14 +0200 |
| Message-ID | <4707383.X4mSQnUZjh@PointedEars.de> |
| In reply to | #9670 |
Charles wrote: > On Monday, May 27, 2013 2:45:56 PM UTC-7, M. Strobel wrote: >> Am 27.05.2013 23:12, schrieb Charles: >> > Has anyone written software that takes the MySQL structure and >> > generates both an HTML input page suitable for editing and the php >> > script that links it to the MySQL table it's based upon? >> >> Could you be more precise? The internet search for php form generator >> turns up a lot of hits. >> >> The problem has been solved many times, but every time with different >> dependencies. >> >> In this NG you will generally find people who prefer to code it >> themselves instead of trying to read, analyze and debug other people's >> code. > > Sure. > > The database backend is second nature. “Did you mean: ‘is secondary’?” > I can create the tables and normalize them at the same time, and the > interrelationship should be quite valid. > > What I'd like to find is use a software package that will retrieve the > table structure and create both a generic input form in HTML, as well as > the corresponding PHP script to go with it, for that table. That way, I > can start cutting and pasting blocks of code “Did you mean: ‘write loops’?” > instead of having to write it character by character, line by line. Good luck. Please trim your quotes to the relevant minimum, do not use Google Groups for posting (your quotes are not only full quotes, they are also badly formatted), and get a real name. PointedEars -- > If you get a bunch of authors […] that state the same "best practices" > in any programming language, then you can bet who is wrong or right... Not with javascript. Nonsense propagates like wildfire in this field. -- Richard Cornford, comp.lang.javascript, 2011-11-14
[toc] | [prev] | [next] | [standalone]
| From | Charles <cchamb2@gmail.com> |
|---|---|
| Date | 2013-05-28 08:17 -0700 |
| Message-ID | <21dc93f3-c3c0-41e4-822a-239d1d3175dd@googlegroups.com> |
| In reply to | #9676 |
On Monday, May 27, 2013 5:14:14 PM UTC-7, Thomas 'PointedEars' Lahn wrote: > Charles wrote: > > > The database backend is second nature. > > > > “Did you mean: ‘is secondary’?” No, the database back end has required little thought. The data entry forms and support php scripts are the subject of my query. > > can start cutting and pasting blocks of code > > > > “Did you mean: ‘write loops’?” > > > > > instead of having to write it character by character, line by line. No, I mean reusing the foundation code. > > Please trim your quotes to the relevant minimum, do not use Google Groups > > for posting (your quotes are not only full quotes, they are also badly > > formatted), and get a real name. What was quoted was relevant, just understated, and it is my real name.
[toc] | [prev] | [next] | [standalone]
| From | "Peter H. Coffin" <hellsop@ninehells.com> |
|---|---|
| Date | 2013-05-27 20:01 -0500 |
| Message-ID | <slrnkq80fi.msg.hellsop@nibelheim.ninehells.com> |
| In reply to | #9670 |
On Mon, 27 May 2013 15:34:07 -0700 (PDT), Charles wrote:
> The database backend is second nature. I can create the tables and
> normalize them at the same time, and the interrelationship should be
> quite valid.
>
> What I'd like to find is use a software package that will retrieve the
> table structure and create both a generic input form in HTML, as well
> as the corresponding PHP script to go with it, for that table. That
> way, I can start cutting and pasting blocks of code instead of having
> to write it character by character, line by line.
This is the kind of thing for which Ruby on Rails was designed for. It
is, however, not covered by this group, so I can't recommend more than
read up some, and find an accomodating Ruby venue. I got only so far as
a couple of experiments and concluding "Wow, this is pretty nifty if I
ever need to roll up entry pages in ten minutes." So I'm not even a good
resource either.
--
22. No matter how tempted I am with the prospect of unlimited power, I
will not consume any energy field bigger than my head.
--Peter Anspach's list of things to do as an Evil Overlord
[toc] | [prev] | [next] | [standalone]
| From | The Natural Philosopher <tnp@invalid.invalid> |
|---|---|
| Date | 2013-05-28 05:46 +0100 |
| Message-ID | <ko1cq3$53n$1@news.albasani.net> |
| In reply to | #9670 |
On 27/05/13 23:34, Charles wrote: > On Monday, May 27, 2013 2:45:56 PM UTC-7, M. Strobel wrote: >> Am 27.05.2013 23:12, schrieb Charles: >> >>> Does anyone have software they can suggest for generating an HTML input form and the php backend script for adding records to a database? >>> I'm developing a web application, and I'm about half way through the MySQL end of it, but I'm daunted by the idea of hand coding 35'ish HTML and php files for data entry. >>> Has anyone written software that takes the MySQL structure and generates both an HTML input page suitable for editing and the php script that links it to the MySQL table it's based upon? >> >> >> Could you be more precise? The internet search for php form generator turns up a lot >> >> of hits. >> >> >> >> The problem has been solved many times, but every time with different dependencies. >> >> In this NG you will generally find people who prefer to code it themselves instead of >> >> trying to read, analyze and debug other people's code. >> >> >> >> /Str. > Sure. > > The database backend is second nature. I can create the tables and normalize them at the same time, and the interrelationship should be quite valid. > > What I'd like to find is use a software package that will retrieve the table structure and create both a generic input form in HTML, as well as the corresponding PHP script to go with it, for that table. That way, I can start cutting and pasting blocks of code instead of having to write it character by character, line by line. well that of course is something you write a library for. e.g. supose you have a fueld that will take one on many values and you want to use aselect boix., write a function that takes as arguments the name of the post variable to be set, anda set of X y screen co-ordinates and an associative array of the name/value pairs of all thepossible values. There's a basic building block you can use. Same for text or numerical input (you can even have a bit of javascript for input validation) and/or radio buttons. Your database update is a one line sql statement. . All you have to do is write a series of arrays of name-value pairs and some name, x, y, type,vaklue statements somewhere, and build a little bit of code to scan them and call your form primitives. -- Ineptocracy (in-ep-toc’-ra-cy) – a system of government where the least capable to lead are elected by the least capable of producing, and where the members of society least likely to sustain themselves or succeed, are rewarded with goods and services paid for by the confiscated wealth of a diminishing number of producers.
[toc] | [prev] | [next] | [standalone]
| From | Michael Vilain <vilain@NOspamcop.net> |
|---|---|
| Date | 2013-05-27 14:48 -0700 |
| Message-ID | <vilain-E96B3F.14484527052013@news.individual.net> |
| In reply to | #9667 |
In article <ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com>, Charles <cchamb2@gmail.com> wrote: > Does anyone have software they can suggest for generating an HTML input form > and the php backend script for adding records to a database? > > I'm developing a web application, and I'm about half way through the MySQL > end of it, but I'm daunted by the idea of hand coding 35'ish HTML and php > files for data entry. > > Has anyone written software that takes the MySQL structure and generates both > an HTML input page suitable for editing and the php script that links it to > the MySQL table it's based upon? I haven't come across anything that does the form generation and the database update portion in a server-side php script. 'Fraid you're stuck doing the 35 forms and data entry by hand, just like the rest of us. That is, unless you use a CMS to manage your content and some sort of form plug-in to store the data. -- DeeDee, don't press that button! DeeDee! NO! Dee... [I filter all Goggle Groups posts, so any reply may be automatically ignored]
[toc] | [prev] | [next] | [standalone]
| From | Twayne <nobody@spamcop.net> |
|---|---|
| Date | 2013-05-27 19:35 -0400 |
| Message-ID | <ko0qj5$3t7$2@speranza.aioe.org> |
| In reply to | #9667 |
On 5/27/2013 5:12 PM, Charles wrote:
> Does anyone have software they can suggest for generating an HTML input
form and the php backend script for adding records to a database?
>
> I'm developing a web application, and I'm about half way through
the MySQL end of it, but I'm daunted by the idea of hand coding
35'ish HTML and php files for data entry.
>
> Has anyone written software that takes the MySQL structure and
generates both an HTML input page suitable for editing and the php
script that links it to the MySQL table it's based upon?
>
If you don't mind a short learning curve and this isn't a 1-time thing,
NoteTAB Pro can do an admirable job. It comes with a wealth of clips but
you can also create your own clip/s to use as templates.
It has a free and paid version, very reasonably priced and is a
proven application. Rolling your own is easily possible with it,
especially if you have several files that need a similar clip (template)
to work in.
Regards,
[toc] | [prev] | [next] | [standalone]
| From | "Tony Marston" <TonyMarston@hotmail.com> |
|---|---|
| Date | 2013-05-28 07:25 +0100 |
| Message-ID | <%5Yot.197338$a77.10316@fx18.fr7> |
| In reply to | #9667 |
"Charles" wrote in message news:ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com... > >Does anyone have software they can suggest for generating an HTML input >form and the php backend script for adding records to a database? > >I'm developing a web application, and I'm about half way through the MySQL >end of it, but I'm daunted by the idea of hand coding 35'ish HTML and php >files for data entry. > >Has anyone written software that takes the MySQL structure and generates >both an HTML input page suitable for editing and the php script that links >it to the MySQL table it's based upon? I suggest you take a look at Radicore (http://www.radicore.org) which was purpose built to do exactly what you want. You import your database schema into the data dictionary, then export each table definition to produce one class per table. Then you generate user transactions which create the scripts to create/read/update/delete each table. The whole import/export/generate process can be done in 5 minutes, and you don't have to write a single line of PHP, HTML or SQL. The generated transactions only perform the basic functions with default behaviour, but you can customise them to your heart's content. All scripts are controlled through the Role Based Access Control (RBAC) system, so you can easily control which user has access to which scripts. -- Tony Marston http://www.tonymarston.net http://www.radicore.org
[toc] | [prev] | [next] | [standalone]
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Date | 2013-05-28 12:24 -0400 |
| Message-ID | <ko2lgj$ftn$2@dont-email.me> |
| In reply to | #9681 |
On 5/28/2013 2:25 AM, Tony Marston wrote: > "Charles" wrote in message > news:ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com... >> >> Does anyone have software they can suggest for generating an HTML >> input form and the php backend script for adding records to a database? >> >> I'm developing a web application, and I'm about half way through the >> MySQL end of it, but I'm daunted by the idea of hand coding 35'ish >> HTML and php files for data entry. >> >> Has anyone written software that takes the MySQL structure and >> generates both an HTML input page suitable for editing and the php >> script that links it to the MySQL table it's based upon? > > I suggest you take a look at Radicore (http://www.radicore.org) which > was purpose built to do exactly what you want. You import your database > schema into the data dictionary, then export each table definition to > produce one class per table. Then you generate user transactions which > create the scripts to create/read/update/delete each table. The whole > import/export/generate process can be done in 5 minutes, and you don't > have to write a single line of PHP, HTML or SQL. The generated > transactions only perform the basic functions with default behaviour, > but you can customise them to your heart's content. > > All scripts are controlled through the Role Based Access Control (RBAC) > system, so you can easily control which user has access to which scripts. > Yes, if you want one of the biggest pieces of junk on the internet, Radicore is a good place to start. -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================
[toc] | [prev] | [next] | [standalone]
| From | "Tony Marston" <TonyMarston@hotmail.com> |
|---|---|
| Date | 2013-05-29 07:08 +0100 |
| Message-ID | <tXgpt.220949$Y_6.86080@fx32.fr7> |
| In reply to | #9684 |
"Jerry Stuckle" wrote in message news:ko2lgj$ftn$2@dont-email.me... > >On 5/28/2013 2:25 AM, Tony Marston wrote: >> "Charles" wrote in message >> news:ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com... >>> >>> Does anyone have software they can suggest for generating an HTML >>> input form and the php backend script for adding records to a database? >>> >>> I'm developing a web application, and I'm about half way through the >>> MySQL end of it, but I'm daunted by the idea of hand coding 35'ish >>> HTML and php files for data entry. >>> >>> Has anyone written software that takes the MySQL structure and >>> generates both an HTML input page suitable for editing and the php >>> script that links it to the MySQL table it's based upon? >> >> I suggest you take a look at Radicore (http://www.radicore.org) which >> was purpose built to do exactly what you want. You import your database >> schema into the data dictionary, then export each table definition to >> produce one class per table. Then you generate user transactions which >> create the scripts to create/read/update/delete each table. The whole >> import/export/generate process can be done in 5 minutes, and you don't >> have to write a single line of PHP, HTML or SQL. The generated >> transactions only perform the basic functions with default behaviour, >> but you can customise them to your heart's content. >> >> All scripts are controlled through the Role Based Access Control (RBAC) >> system, so you can easily control which user has access to which scripts. >> > >Yes, if you want one of the biggest pieces of junk on the internet, >Radicore is a good place to start. > > You wouldn't know quality if it crawled up your leg and bit you in the a*se. -- Tony Marston http://www.tonymarston.net http://www.radicore.org
[toc] | [prev] | [next] | [standalone]
| From | Thomas 'PointedEars' Lahn <PointedEars@web.de> |
|---|---|
| Date | 2013-05-29 12:26 +0200 |
| Message-ID | <7034027.RaaYcivmjm@PointedEars.de> |
| In reply to | #9691 |
Tony Marston wrote: > "Jerry Stuckle" wrote […] >> On 5/28/2013 2:25 AM, Tony Marston wrote: >>> "Charles" wrote […]: >>>> Does anyone have software they can suggest for generating an HTML >>>> input form and the php backend script for adding records to a database? >>>> >>>> I'm developing a web application, and I'm about half way through the >>>> MySQL end of it, but I'm daunted by the idea of hand coding 35'ish >>>> HTML and php files for data entry. >>>> >>>> Has anyone written software that takes the MySQL structure and >>>> generates both an HTML input page suitable for editing and the php >>>> script that links it to the MySQL table it's based upon? >>> >>> I suggest you take a look at Radicore (http://www.radicore.org) […] >> >> Yes, if you want one of the biggest pieces of junk on the internet, >> Radicore is a good place to start. > > You wouldn't know quality if it crawled up your leg and bit you in the > a*se. That may be so. However, that I have to register with personal information to just have a look at the source code of Radicore does not fill me with confidence that it would be good quality (yes, I have noticed your Privacy Policy). Never judge a book by its cover. Also, <http://www.tonymarston.net/>, as referred to by your signature and <http://www.radicore.org/about.php>, is 404-compliant here. Curiously enough, <http://www.tonymarston.net/php-mysql/back-to-front.html> and the like are not. And I would strongly suggest that you say explicitly when you are advertising your own software. PointedEars -- Danny Goodman's books are out of date and teach practices that are positively harmful for cross-browser scripting. -- Richard Cornford, cljs, <cife6q$253$1$8300dec7@news.demon.co.uk> (2004)
[toc] | [prev] | [next] | [standalone]
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Date | 2013-05-29 07:24 -0400 |
| Message-ID | <ko4o9o$tia$1@dont-email.me> |
| In reply to | #9691 |
On 5/29/2013 2:08 AM, Tony Marston wrote: > "Jerry Stuckle" wrote in message news:ko2lgj$ftn$2@dont-email.me... >> >> On 5/28/2013 2:25 AM, Tony Marston wrote: >>> "Charles" wrote in message >>> news:ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com... >>>> >>>> Does anyone have software they can suggest for generating an HTML >>>> input form and the php backend script for adding records to a database? >>>> >>>> I'm developing a web application, and I'm about half way through the >>>> MySQL end of it, but I'm daunted by the idea of hand coding 35'ish >>>> HTML and php files for data entry. >>>> >>>> Has anyone written software that takes the MySQL structure and >>>> generates both an HTML input page suitable for editing and the php >>>> script that links it to the MySQL table it's based upon? >>> >>> I suggest you take a look at Radicore (http://www.radicore.org) which >>> was purpose built to do exactly what you want. You import your database >>> schema into the data dictionary, then export each table definition to >>> produce one class per table. Then you generate user transactions which >>> create the scripts to create/read/update/delete each table. The whole >>> import/export/generate process can be done in 5 minutes, and you don't >>> have to write a single line of PHP, HTML or SQL. The generated >>> transactions only perform the basic functions with default behaviour, >>> but you can customise them to your heart's content. >>> >>> All scripts are controlled through the Role Based Access Control (RBAC) >>> system, so you can easily control which user has access to which >>> scripts. >>> >> >> Yes, if you want one of the biggest pieces of junk on the internet, >> Radicore is a good place to start. >> >> > > You wouldn't know quality if it crawled up your leg and bit you in the > a*se. > Oh, I do, Tony. And I know crap when I see it. This is one huge load. Even your tirade on OO shows how stoopid you are. My *real programmer* friends get a big laugh out of it. You don't even rate "Programmer wanna-be". -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================
[toc] | [prev] | [next] | [standalone]
| From | Charles <cchamb2@gmail.com> |
|---|---|
| Date | 2013-05-29 08:59 -0700 |
| Message-ID | <4979adcb-6bc3-4d3d-9273-1abb1818f586@googlegroups.com> |
| In reply to | #9684 |
On Tuesday, May 28, 2013 9:24:55 AM UTC-7, Jerry Stuckle wrote: > On 5/28/2013 2:25 AM, Tony Marston wrote: > > > "Charles" wrote in message > > > news:ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com... > > >> > > >> Does anyone have software they can suggest for generating an HTML > > >> input form and the php backend script for adding records to a database? > > >> > > >> I'm developing a web application, and I'm about half way through the > > >> MySQL end of it, but I'm daunted by the idea of hand coding 35'ish > > >> HTML and php files for data entry. > > >> > > >> Has anyone written software that takes the MySQL structure and > > >> generates both an HTML input page suitable for editing and the php > > >> script that links it to the MySQL table it's based upon? > > > > > > I suggest you take a look at Radicore (http://www.radicore.org) which > > > was purpose built to do exactly what you want. You import your database > > > schema into the data dictionary, then export each table definition to > > > produce one class per table. Then you generate user transactions which > > > create the scripts to create/read/update/delete each table. The whole > > > import/export/generate process can be done in 5 minutes, and you don't > > > have to write a single line of PHP, HTML or SQL. The generated > > > transactions only perform the basic functions with default behaviour, > > > but you can customise them to your heart's content. > > > > > > All scripts are controlled through the Role Based Access Control (RBAC) > > > system, so you can easily control which user has access to which scripts. > > > > > > > Yes, if you want one of the biggest pieces of junk on the internet, > > Radicore is a good place to start. > > > > > > -- > > ================== > > Remove the "x" from my email address > > Jerry Stuckle > > JDS Computer Training Corp. > > jstucklex@attglobal.net > > ================== Then how would you approach the problem? I'm just thinking back to the days of Paradox, where you hit a button from a query and Paradox generated a generic form, saved it, and you could then edit it at will.
[toc] | [prev] | [next] | [standalone]
| From | Jerry Stuckle <jstucklex@attglobal.net> |
|---|---|
| Date | 2013-05-29 12:29 -0400 |
| Message-ID | <ko5a5p$8db$1@dont-email.me> |
| In reply to | #9703 |
On 5/29/2013 11:59 AM, Charles wrote: > On Tuesday, May 28, 2013 9:24:55 AM UTC-7, Jerry Stuckle wrote: >> On 5/28/2013 2:25 AM, Tony Marston wrote: >> >>> "Charles" wrote in message >> >>> news:ede17d74-5f3d-46ad-acbb-03bb103dc09c@googlegroups.com... >> >>>> >> >>>> Does anyone have software they can suggest for generating an HTML >> >>>> input form and the php backend script for adding records to a database? >> >>>> >> >>>> I'm developing a web application, and I'm about half way through the >> >>>> MySQL end of it, but I'm daunted by the idea of hand coding 35'ish >> >>>> HTML and php files for data entry. >> >>>> >> >>>> Has anyone written software that takes the MySQL structure and >> >>>> generates both an HTML input page suitable for editing and the php >> >>>> script that links it to the MySQL table it's based upon? >> >>> >> >>> I suggest you take a look at Radicore (http://www.radicore.org) which >> >>> was purpose built to do exactly what you want. You import your database >> >>> schema into the data dictionary, then export each table definition to >> >>> produce one class per table. Then you generate user transactions which >> >>> create the scripts to create/read/update/delete each table. The whole >> >>> import/export/generate process can be done in 5 minutes, and you don't >> >>> have to write a single line of PHP, HTML or SQL. The generated >> >>> transactions only perform the basic functions with default behaviour, >> >>> but you can customise them to your heart's content. >> >>> >> >>> All scripts are controlled through the Role Based Access Control (RBAC) >> >>> system, so you can easily control which user has access to which scripts. >> >>> >> >> >> >> Yes, if you want one of the biggest pieces of junk on the internet, >> >> Radicore is a good place to start. >> >> >> > > Then how would you approach the problem? > > I'm just thinking back to the days of Paradox, where you hit a button from a query and Paradox generated a generic form, saved it, and you could then edit it at will. > I have my own set of scripts I've developed and modified over the years. It works fine for me. However, I think CakePHP is a good solution. Of course, if you're just looking for an easy way to add a few rows to a database as an admin, PHPMyAdmin is a good way to go. But it's not for casual users - it gives complete control over the database(s). -- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstucklex@attglobal.net ==================
[toc] | [prev] | [next] | [standalone]
| From | Jonathan Stein <jstein@image.dk> |
|---|---|
| Date | 2013-05-29 13:00 +0200 |
| Message-ID | <51a5dfe8$0$32107$14726298@news.sunsite.dk> |
| In reply to | #9667 |
Den 27-05-2013 23:12, Charles wrote:
> Does anyone have software they can suggest for generating an HTML input form and the php backend script for adding records to a database?
I often prefer CakePHP for projects with complex datamodels. It is
inspired by Ruby on Rails and if you stick to some naming conventions,
it can generate a complete application with create, read, update and
delete functionality just by reading your database layout.
Of course there are both pros and cons of different frameworks, but
let's not repeat these discussions. Have a look at CakePHP and judge for
yourself.
Regards
Jonathan
[toc] | [prev] | [next] | [standalone]
| From | Mladen Gogala <gogala.mladen@gmail.com> |
|---|---|
| Date | 2013-06-24 05:28 +0000 |
| Message-ID | <pan.2013.06.24.05.28.23@gmail.com> |
| In reply to | #9667 |
On Mon, 27 May 2013 14:12:41 -0700, Charles wrote: > Does anyone have software they can suggest for generating an HTML input > form and the php backend script for adding records to a database? > > I'm developing a web application, and I'm about half way through the > MySQL end of it, but I'm daunted by the idea of hand coding 35'ish HTML > and php files for data entry. > > Has anyone written software that takes the MySQL structure and generates > both an HTML input page suitable for editing and the php script that > links it to the MySQL table it's based upon? Sounds like a job for MVC generators, like Cake or Symfony. I used Symfony at one time and it was pretty good. Cake is probably more popular, due to better accessibility of the literature. There is also something called "project Laravel" which uses Symfony components. I am not particularly interested in Laravel because the databases that I usually work with, Oracle and DB2, are not among the supported ones. MySQL is, so you may find it quite useful. -- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.com
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.php
csiph-web