Temporary MySQL Tables

From: Date: Thu, 21 Mar 2002 20:09:25 +0000
Subject: Temporary MySQL Tables
Groups: php.db php.general 
Request: Send a blank email to php-db+get-17820@lists.php.net to get a copy of this message
Hi, On my site now, there's a lengthy register process where the user has to fill in 5 forms, one after the another. I get the PHP script to echo the values from the previous into the next form by using <?php echo "<input type=\"hidden\" name=\"name\" value=\"" . $name . "\">"; ?> for example. Then I keep carrying the information over to each extra form until the user reaches the last page and I insert all the info into a table called "tempmembers" with an extra timestamp field which I use to verify email addresses. The user gets an email saying click here to verify your membership with the username and timestamp in the URL. The users clicks it, and I run a SQL command that copies the row from "tempmembers" into the "members" table. This process worked well for a while until I discovered if users enter a single or double quote into any of the fields, it fecks everything up. So I added an addslashes command but it's all getting a bit hairy so I was looking for some advice on MySQL temporary tables for either using after every form or at the end of all the forms. Or does anyone have any other method I could use??? Thanks for any help you might have.

« previous php.db (#17820) next »