Results 1 to 5 of 5
Thread: Php question
02-10-2004, 03:40 PM #1webtechGuest
I am dedigning a online form and when they click submit it has to added to the database, before that I will have to get the notification from email and I have to approve it.
Whre do I have to store the data temprorly?
02-11-2004, 11:56 AM #2michalGuest
You can copy into another table, after you verify the data then copy into original table.
I guess this is the easy way to do it.
02-11-2004, 12:59 PM #3LippyGuest
Another method to do this is to have a field called "Confirmed" or something similar. This is either a 1 or 0. Then you could set a cron job up that every X amount of day/month/weeks all records set to 0 will be delete, while the ones that have a 1 will be untouched.
***Whoops, thanks for pointing out my #2 error***
Last edited by Lippy; 02-11-2004 at 03:49 PM.
02-11-2004, 02:51 PM #4longplayGuest
Where'd the 2 come into it?
Anyway, this is the method I use for my newsletter script, simple enough to code and use and saves having two tables and the copying between.
02-29-2004, 06:04 PM #5dmoraGuest
Hi everybody.. i'm new in this forum... and i would like to have great experiences here.. sharing knowledge...
Well about this issue..... i agree with lippy.. but my only suggestion is to add another status... like pending.... bc if you set up a cron job to delete all those uncorfimed fields.... what would happen if you needed one of then...
so, the status table would look like this
The cron job will delete all denied rows....
hope it would be useful......