Re: when to enter submitted in mysql?

On Tue, Nov 29, 2005 at 11:57:49AM -0500, Jim Moseby wrote: > > Hi to all! > > I have form made on 4 pages (by groups of questions). Right > > now my code > > works this way: once somebody submit the first page of the > > form his/her > > submitted info is entered in database with status=temp. I > > store the ID > > (insert_id()) in session and then every time visitor submit the next > > page I do update of the current record using ID. > > But, I heard once that "the best" solution is store all > > entered info in > > session (array) and insert all info at once. > > Or, instead in sessions, move submitted info with serialized array. > > > > Opinions? > > > > The upside to storing the data in session variables is that you make only ne > DB call at the end, saving processor, bandwidth, etc. The downside is, that > if your user cannot complete the form, his data is lost and he has to start > all over again. Another upside is that you dont have to maintain old session data, it is done for you. If the user comes to your site and just does 3 of the 4 pages, you dont have to worry about cleaning up any extra dead information. Curt. -- cat .signature: No such file or directory