473,320 Members | 1,863 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 Mysql Creating a Subform

Hi,
I need help developing an expanding form
I've decided that a use of PHP, Mysql and Javascript is the best platform
for creating a selection of database interfaces which I'm trying to build
for my company. I had been using Microsoft Access, but obviously this
requires licenses for every machine. BUT.....
I'm look for an easy way of recreating subforms. I'm trying to create a
Purchase Order system and in Access I did this by using a subform (listing
the items on order) on a form (detailing the order information). In this
environment whenever you added a new item into the items section a new set
of dialog boxes woud appear for you to put another item in should you
require it, i.e. you could enter infinite items!
Whilst I've seen scripts that make forms dynamic they seem to wipe the
information already entered onto the form in order to update how many dialog
boxes are displayed.

Any ideas on this one would be greatly appreciated, any similar systems out
there?

Many Thanks
Matthew
Jul 17 '05 #1
1 9839
You will probably find that writing a PHP / MySQL application is very
different process than working in access. What you need to bear in mind
is that the client with a web application does not maintain a persistent
connection to the server. Doing the sort of thing (i think) you are
describing is in fact quite impossible. You will not be able to save
state between page loads with fields that are not submitted to the
server side scripting.

I can't solve your design issue in a short message, especially not
without seeing what you are doing, but in general, here's some tips to
designing a web application.

1. Think about your data dependencies. Figure out what data needs to be
entered before other data can be entered.

2. Build multiple forms across different pages to enter data. Usually
this means one form to one database table. Not always, but usually.

3. Develop your interface so that users enter data in an order that is
consistent with data dependencies. If an order, for instance, needs a
company record, have the application display the form to enter the
company record first.

4. Think out of the box. Web applications are weird critters and do not
always lend themselves to the most intuitive ways of doing things. The
technology is in fact limited.

You may do better trying to write a more conventional client/server
application. A Java, Visual Basic, or even PHP GTK-based client might be
a more approprate way to interface with your MySQL server to what you
want to do. Since you're doing this yourself, you may want to stick with
what you already know. There are also ways to use Flash to build
portable browser-based clients that interface with PHP scripts. Don't
get me wrong. I make my living building browser-based PHP web apps, but
not everything can be solved with a web app.

Best of luck!
Matthew Clubb wrote:
Hi,
I need help developing an expanding form
I've decided that a use of PHP, Mysql and Javascript is the best platform
for creating a selection of database interfaces which I'm trying to build
for my company. I had been using Microsoft Access, but obviously this
requires licenses for every machine. BUT.....
I'm look for an easy way of recreating subforms. I'm trying to create a
Purchase Order system and in Access I did this by using a subform (listing
the items on order) on a form (detailing the order information). In this
environment whenever you added a new item into the items section a new set
of dialog boxes woud appear for you to put another item in should you
require it, i.e. you could enter infinite items!
Whilst I've seen scripts that make forms dynamic they seem to wipe the
information already entered onto the form in order to update how many dialog
boxes are displayed.

Any ideas on this one would be greatly appreciated, any similar systems out
there?

Many Thanks
Matthew

Jul 17 '05 #2

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

Similar topics

0
by: Russ | last post by:
Hi, I'm doing some web development and have mysql (3.23.x) installed to test with (win2k, but I don't think this question is particularly platform specific). I have a reasonably complex query...
1
by: Paul K. McKneely | last post by:
Hi, I just installed mySQL on MS NT 4.0 workstation and applied Service Pack 6a. When trying to add a new user using the Control Center I get an info message that say that user was added but...
2
by: Matthew Clubb | last post by:
Hi, I need help developing an expanding form I've decided that a use of PHP, Mysql and Javascript is the best platform for creating a selection of database interfaces which I'm trying to build...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
12
by: MLH | last post by:
I have created two forms: frmBrowseNegsMainform and frmBrowseNegsSubform. I put a subform control on the first of these. The SourceObject property for the subform control is, of course,...
5
by: Lyn | last post by:
Hi, this has been driving me nuts. I'm on Office 2003 SP1, Win XP SP1. I am opening a form with a number of subforms based on various tables. The subforms are populated via the main form's...
3
by: solargovind | last post by:
Hi, I am New to this forum. I need steps that i do in creating subform. In main form, i have one table fields like vendor,account,due amount,balance amount and Requisition_id which is...
0
by: FrozenDude | last post by:
Hello and thanks in advance. I've read through the threads but can't seem to make this work. I have a form with a combo box (named DateCode) that provides a table column name and a subform...
3
by: RAG2007 | last post by:
Hi, I'm creating a backend for my Access front end in MySQL, and am running tests. I am coming across the infamous "Write Error". Here's an instance: I open a form with a subform, and when I...
0
by: Gordon Padwick | last post by:
A form contains controls, one or more of which can be other forms. A form that contains another form is known as a main form. A form contained by a main form is known as a subform. A subform itself...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
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

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.