| Re: PHP form generator [message #181732 is a reply to message #181722] |
Tue, 28 May 2013 04:46   |
The Natural Philosoph
Messages: 993
Registered: September 2010
Karma:
|
Senior Member |
|
|
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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]