You don't need PostgreSQL for transactions. InnoDB tables in MySQL will work just fine. I do agree that this begs for a transaction setup. The transactions will confirm the transfer of everything from the temp to regular table. Then use a timestamp in conjunction with a "sweeper" script to remove all entries in the temp table more than 7 days old. I think that's a fair time for someone to confirm their information and it allows easily a scheduled operation. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Boa Constructor" <mickel@ntlworld.com> To: <php-db@lists.php.net>; <xueh@lycos.com> Sent: Tuesday, 03 June, 2003 00:00 Subject: Re: Reserve Username while Confirming Signup Sounds like ya wanna use a database that supports transactions, PostgreSQL supports it. I'm kinda new to this so I'd check it out but I think this could be what yer after. Cheers, Graeme :) ----- Original Message ----- From: "Dewi Wahyuni" <xueh@lycos.com> To: <php-db@lists.php.net> Sent: Tuesday, June 03, 2003 4:47 AM Subject: Reserve Username while Confirming Signup > Hi All, > > I have a sign up page and when the user submit, it goes to a confirmation page, before the person actually submits. > > The confirmation page stores the username and password in the Session variable and the submit page stores it into the database by getting it from the session. The rest of the information (eg. address) is resubmited via hidden input type. > > The question is : I want to reserve the username for the person(say A) while he/she is in the confirmation page and perhaps going back to edit some stuff. What is the best way to do that? > > > I tried putting it in my database in a Logintemp table. With the same fields as the Login table. When the user submits, the Logintemp contents is moved to the Login table. > > The problem is what if while A is staring at the screen the computer hangs. How do I know if he/she closes the page altogether. I need to delete the contents of Logintemp since it was not moved to Login. > > Is there any other better way to do this? > > > ____________________________________________________________ > Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! > http://login.mail.lycos.com/r/referral?aid=27005 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
