473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

php one to many form(s)?

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.
Jul 16 '05 #1
2 2373
Bruno
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.


Where is your problem ?

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.
Jul 16 '05 #2
Frank wrote:
Bruno
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.


Where is your problem ?


It is in the UI.


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

Jul 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Yaron C. | last post by:
Hello, I would like to ask for your help. I am trying to create a page with table of many form elements. The size of the table is 84x10 (84 rows, 10 columns) and each cell contains 1 form...
4
by: JSMiami | last post by:
I have a form that is fed by a certain table. This table connects to an intermeddiate table and then a look up table. All of this is done to accomplish a many-to-many relationship. Imagine that the...
2
by: Megan | last post by:
hello everybody, i know this is a very long post, but i wanted to provide as much detail as possible. quick overview- i want to create a couple of many to many relationships and am wondering...
2
by: Steve | last post by:
A main form contains ten textboxes and ten subforms. All ten subforms have the same query (Query2) for their recordsource. Query2 is based on a query (Query1). Each subform is linked to a different...
3
by: Carmela | last post by:
Hello Readers, I am trying to update data on a form that is based on a query having a many-to-one-to-many relationship. I found this exciting link that seemed to have the solution for me: ...
5
by: Don Sealer | last post by:
I have a database that I need to track certain measurements numerous times per day. I need to record several aspects like, length, width, thickness, plus a few other things. I've been recording...
10
by: Thelma Lubkin | last post by:
My form/subform combination that allows user to display 'ColorSet' records, move to other records via a selector, to add,delete, and edit them, and to manage the related 'Color' records from the...
5
by: Robert | last post by:
I am very new to .net and asp.net. I am trying to design an intranet page that has a SQL Server 2000 database. I understand how to connect to the data but am getting very confused on how to...
4
by: bobg.rjservices | last post by:
running access 2k; adp w/ linked tables to SQL server; I am absolutely stymied, and ticked off beyond belief - I can not believe how much time I've wasted trying to do something that should be...
11
by: RobertJohn | last post by:
Hi all I am using Access 2007 to start a small home library application, and so far it has two tables. 1. Books, with fields Book_ID (Primary Key) and Title, and 2. Authors, with fields...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.