Results 1 to 5 of 5
Thread: Php question
-
02-10-2004, 03:40 PM #1webtechGuest
Php question
Hi,
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
Hi,
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.
Good LUCK.
-
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.
1=confirmed
0=unconfirmed
***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
0: confirmed
1: pending
3: denied.
The cron job will delete all denied rows....
hope it would be useful......
Bookmarks