> Don wrote:
>
> > Hello,
> >
> > Has anyone run into problems using PHP to access a database (MySQL) and
> > build a form. I am trying to build a form that contains anywhere from
> > 10 to 20 tables. Each table will contain drop down menus, text boxes
> > and text areas. As you may envision, this form can be quite lengthy.
> >
> > I populate the form by creating a loop and accessing the MySQL
> > database. Each iteration returns data (24 fields) from a record in my
> > Database table).
> >
> > My problem is that after loading the page, my browser appears to lock up
> > and any attempt to run other programs gives me a Windows Low Memory
> > error (and that I should close other programs).
> >
> > Note: Third may not be a PHP problem but as I am unsure, I have to start
> > somewhere.
> > Note2: I have already queried the HTML newsgroup and the feedback I
> > received was that large forms should not cause this problem.
>
> Then I'd have to say that the HTML newsgroup people don't know
> what they're talking about, because it's quite simple to make a form
> so large as to cause browser issues/crashes/low memory warnings.
> Let's see - if you have 32 megs in your system, assume a lot is taken
> up by the OS and browser itself. So creating a 10 meg form
> could easily crash your system.
>
> Not suggesting you have a 10 meg form, but it's hard to know how things
> are calculated. Just because you have 30k of HTML doesn't mean it takes
> up 30k in your browser's memory, as it has to create internal structures
> from your HTML to know how to render stuff, then there's the actual graphic
> displaying of what your form is.
>
> We had a client who wanted an inventory form. They have ~200 items - creating
> a form with all 200 items, each with a pulldown option box with 6 options, was
> causing problems on Windows machines using Netscape with less than 64 megs of
> RAM. This was only 6 months ago with Win98 and netscape 4.7, so I think it's
> safe to say it's definitely possible. (we had to break the form up into their
> separate product categories - about 7 - so each page only has 20-30 items on
> it)
>
> Now, is this what's happening to you? Could be - could you send a URL for
> others to hit to see if we experience the same problem? If I hit it with 128
> megs of RAM with no problem, and you crash with 32 megs, there's your problem.
> BUT... it might be something more than that.
I agree with your analysis. As I've thought about it more, I realize that I
have no control over the exact number of tables that will exist in my form and
hence, the total number items on the form. Reason being that this is dynamic
and based on vales returned from a database.
Expecting my clients to have the necessary hardware / memory in order to use it
is ridiculous. So, I am logically breaking it into two screen, one with the
subject of each table linked that the client can 'click'. The other, a generic
form that will retrieve values based on the subject clicked on the previous
page. I guess you can call it "normalizing" my form.
By the way, say that each subject link is a numeric string, will my second page
have access to that string, i.e., can I pass it as a parameter in my <A HREF=>
tag? The first page will be PHP generated while the second will be HTML with a
PHP script to access the database and build my form. I have not found any
documentation on how to do this on the HTML docs so I was wondering if there is
a trick to this.
Thanks,
Don
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
