php one to many form(s)?

[Frank]

I am in the process of evaluating PHP for use in a web based database
application but I have not seen any examples for one of my
requirements.

The requirement is a form (or a form and sub-form) that will display
both header data and detail data. An example of such a form might be
for an invoice.

It is necessary to be able to search for the header information of the
invoice (at the top of the invoice) and add/change/delete the detail
records that represent the items ordered.

This ability to display records from one table(header data table) and
tie it to the detail records(detail data table), and display the
appropriate data, should not be a difficult thing. Unfortunately, I
have not seen any examples of such.

Is this difficult to do with PHP?
Anyone have any examples that I can "pick a part"?
Thanks.

[Frank]

Re: php one to many form(s)?

Bruno[color=blue][color=green]
> > It is necessary to be able to search for the header information of the
> > invoice (at the top of the invoice) and add/change/delete the detail
> > records that represent the items ordered.
> >
> > This ability to display records from one table(header data table) and
> > tie it to the detail records(detail data table), and display the
> > appropriate data, should not be a difficult thing. Unfortunately, I
> > have not seen any examples of such.[/color]
>
> Where is your problem ?[/color]
It is in the UI. Although the data can be queried as you have stated
in SQL, the display of the data and the ability to add/change/delete
the detail records is not so clear to me.

I have seen examples of single records displayed and modified, but not
detail records associated with header record.

I have seen this done in Cold Fusion with two frames, where the upper
frame represented the header and the lower frame represented the
detail. This type of solution would work but you need to keep the two
frames in sync. Personally, I don't think it is a very elegant
solution, but it worked.

I was trying to determine if there was another way of creating the UI
other than frames or if frames is the only way to go, then how are the
frames kept in sync.

Please remember, the detail records must be added/changed/deleted, not
just displayed.

[Bruno Desthuilliers]

Re: php one to many form(s)?

Frank wrote:[color=blue]
> Bruno
>[color=green][color=darkred]
>>>It is necessary to be able to search for the header information of the
>>>invoice (at the top of the invoice) and add/change/delete the detail
>>>records that represent the items ordered.
>>>
>>>This ability to display records from one table(header data table) and
>>>tie it to the detail records(detail data table), and display the
>>>appropriat e data, should not be a difficult thing. Unfortunately, I
>>>have not seen any examples of such.[/color]
>>
>>Where is your problem ?[/color]
>
> It is in the UI.[/color]

Well... Seems I didn't guess right :(


Bruno