Generated PHP Web Database forms

[JaZz]

Greetings fellow coders,

I'm still gaining experiance in developing PHP applications, and have completed
a couple of projects already.

This has prompted me to look for ways to reduce the development time for web
enabled database applications. Every web database has basic operations such as
add,delete,upda te and search. I have been creating HTML forms and processing
the results with php code. I have managed to reduce the number of forms required
by using the smarty template engine.

I want to go a stage further and be able to produce the forms and the processing
code purely by looking at some sort of schema file , or using
"mysql_list_fie lds()" and "mysql_list_dbs ()".

Before I start my quest of many late nights of coding. Can any of you guys
give me a head start by pointing me at a solution/hint.

You will save me from RSI and my wife can see me again ;-)

many thanks

JaZz

[Jochen Daum]

Re: Generated PHP Web Database forms

Hi JAZz!
On Sun, 21 Sep 2003 19:16:07 +0000 (UTC), JaZz
<Jazz@labrat.so ho.local> wrote:
[color=blue]
>Greetings fellow coders,
>
>I'm still gaining experiance in developing PHP applications, and have completed
>a couple of projects already.
>
>This has prompted me to look for ways to reduce the development time for web
>enabled database applications. Every web database has basic operations such as
>add,delete,upd ate and search. I have been creating HTML forms and processing
>the results with php code. I have managed to reduce the number of forms required
>by using the smarty template engine.
>
>I want to go a stage further and be able to produce the forms and the processing
>code purely by looking at some sort of schema file , or using
>"mysql_list_fi elds()" and "mysql_list_dbs ()".
>
>Before I start my quest of many late nights of coding. Can any of you guys
>give me a head start by pointing me at a solution/hint.[/color]

I produced such a solution myself, have a look at the signature. I'm
using my own tenplate engine and would have to have a look how to do
it with Smarty.

HTH, Jochen

--
Jochen Daum - CANS Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.

http://sourceforge.net/projects/phpdbedittk/

[Iky]

Re: Generated PHP Web Database forms

JaZz wrote:[color=blue]
> I want to go a stage further and be able to produce the forms and the processing
> code purely by looking at some sort of schema file , or using
> "mysql_list_fie lds()" and "mysql_list_dbs ()".
>
> Before I start my quest of many late nights of coding. Can any of you guys
> give me a head start by pointing me at a solution/hint.
>
> You will save me from RSI and my wife can see me again ;-)[/color]

How about this as a timesaver:

http://dbform.sourceforge.net/

[Pio Clemente]

Re: Generated PHP Web Database forms

Hi, you can try this: http://www.phpio.com
It's my project, called Zas, whith Zas Admin you can quicly build a web
interface for you DB, just Write a xml file, for insert, delete, etc.
And Zas develop the application for you ;)

try Zas and send my feedback.
Pio

Il Sun, 21 Sep 2003 23:54:33 +0200, Iky ha scritto:
[color=blue]
> JaZz wrote:[color=green]
>> I want to go a stage further and be able to produce the forms and the processing
>> code purely by looking at some sort of schema file , or using
>> "mysql_list_fie lds()" and "mysql_list_dbs ()".
>>
>> Before I start my quest of many late nights of coding. Can any of you guys
>> give me a head start by pointing me at a solution/hint.
>>
>> You will save me from RSI and my wife can see me again ;-)[/color]
>
> How about this as a timesaver:
> http://dbform.sourceforge.net/[/color]

[JaZz]

Re: Generated PHP Web Database forms

Excellent! ,

I think you have hit the nail on the head.

I shall have a look at your project.

Thanks for posting a reply Jochen.

I will let you know how I get on

In article <882smvk0gv6mj4 86inqt9oslike22 bejh1@4ax.com>, Jochen Daum wrote:[color=blue]
> Hi JAZz!
> On Sun, 21 Sep 2003 19:16:07 +0000 (UTC), JaZz
> <Jazz@labrat.so ho.local> wrote:
>[color=green]
>>Greetings fellow coders,
>>
>>I'm still gaining experiance in developing PHP applications, and have completed
>>a couple of projects already.
>>
>>This has prompted me to look for ways to reduce the development time for web
>>enabled database applications. Every web database has basic operations such as
>>add,delete,up date and search. I have been creating HTML forms and processing
>>the results with php code. I have managed to reduce the number of forms required
>>by using the smarty template engine.
>>
>>I want to go a stage further and be able to produce the forms and the processing
>>code purely by looking at some sort of schema file , or using
>>"mysql_list_f ields()" and "mysql_list_dbs ()".
>>
>>Before I start my quest of many late nights of coding. Can any of you guys
>>give me a head start by pointing me at a solution/hint.[/color]
>
> I produced such a solution myself, have a look at the signature. I'm
> using my own tenplate engine and would have to have a look how to do
> it with Smarty.
>
> HTH, Jochen
>[/color]

[Jochen Daum]

Re: Generated PHP Web Database forms

Hi JaZZ!

On Sun, 21 Sep 2003 22:24:38 +0000 (UTC), JaZz
<Jazz@labrat.so ho.local> wrote:
[color=blue]
>Excellent! ,
>
>I think you have hit the nail on the head.
>
>I shall have a look at your project.
>
>Thanks for posting a reply Jochen.
>
>I will let you know how I get on
>[/color]

I should point out that there are spelling mistakes in my example
application which let them not work on a linux server.

Give me an email when you download it, I want to release a fix tonight
(NZDT)

Jochen

[color=blue]
>In article <882smvk0gv6mj4 86inqt9oslike22 bejh1@4ax.com>, Jochen Daum wrote:[color=green]
>> Hi JAZz!
>> On Sun, 21 Sep 2003 19:16:07 +0000 (UTC), JaZz
>> <Jazz@labrat.so ho.local> wrote:
>>[color=darkred]
>>>Greetings fellow coders,
>>>
>>>I'm still gaining experiance in developing PHP applications, and have completed
>>>a couple of projects already.
>>>
>>>This has prompted me to look for ways to reduce the development time for web
>>>enabled database applications. Every web database has basic operations such as
>>>add,delete,u pdate and search. I have been creating HTML forms and processing
>>>the results with php code. I have managed to reduce the number of forms required
>>>by using the smarty template engine.
>>>
>>>I want to go a stage further and be able to produce the forms and the processing
>>>code purely by looking at some sort of schema file , or using
>>>"mysql_list_ fields()" and "mysql_list_dbs ()".
>>>
>>>Before I start my quest of many late nights of coding. Can any of you guys
>>>give me a head start by pointing me at a solution/hint.[/color]
>>
>> I produced such a solution myself, have a look at the signature. I'm
>> using my own tenplate engine and would have to have a look how to do
>> it with Smarty.
>>
>> HTH, Jochen
>>[/color][/color]

--
Jochen Daum - CANS Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.

http://sourceforge.net/projects/phpdbedittk/

[JaZz]

Re: Generated PHP Web Database forms

In article <3f6e1e16$0$577 2$edd6591c@news .versatel.net>, Iky wrote:[color=blue]
>
> How about this as a timesaver:
> http://dbform.sourceforge.net/
>[/color]

Iky. I have just downloaded this can tried the demo1.tpl. It worked first time.
Fantastic bit of code.

I'm just playing with it at the moment so I can learn to use it.

Thanks highlighting it to me.