Re: forms and databases usinh PHP

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.