| Re: PHP form generator [message #181756 is a reply to message #181755] |
Wed, 29 May 2013 16:29   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
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(at)googlegroups(dot)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(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]