Re: when to enter submitted in mysql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux