Page 1 of 1

md5 hash files.

Posted: Thu May 31, 2007 8:42 am
by aredden
Howdy. Been searching this for a couple days now. I need a way to retrieve information stored in one of my tables after a user has left my site and come back without having any variables to go by(leaving site by means of payment redirection). is there someway to detect session or something similiar so the server will know what information was inputted by who and to retrieve it and move it to a new table within the same db. from a temporary table to a record keeping table.? if this isnt possible, is there a way to create the ability to recall certain elements from a table with minimal user input? I was thinking give the user a record number and have them input it after they complete the transaction.

Any help would be fantastic. Thanks a ton.! :)

Posted: Thu May 31, 2007 8:47 am
by superdezign
Sessions don't expire until they close the browser. They should last long enough for them to finish their payment and return.

Posted: Thu May 31, 2007 8:47 am
by feyd
Their session shouldn't have terminated, but even then, many payment gateways will thump a URL with some (encrypted) data telling you about the (successful) transaction completion.

Posted: Thu May 31, 2007 8:55 am
by aredden
so, i hate be a bothersome prat who knows nothing. but where would I start looking for the help on this one? As in what function i need to research and whatnot! :)

Thanks a ton.

,and if thats true about them thumping the redirection url with a completion status that would be fantastic. I should contact paypal again today and find out! :)

Posted: Thu May 31, 2007 9:04 am
by superdezign
Function...? Just look into sessions.

I assumed that, since you've gotten this far, you were already using them.

Posted: Thu May 31, 2007 9:27 am
by aredden
I'm not currently using sessions as i havent heard of them until moments ago.

but is this how they operate?

startsession > gather information > store session ?via ip? >
(in my case) payment > checksession > if same session=true > run this function?

thx again!:)

Posted: Thu May 31, 2007 9:30 am
by superdezign
Umm... kind of, but nearly so specific.

A session is a way to keep data from page to page.

Posted: Thu May 31, 2007 9:38 am
by aredden
perhaps this is the best way to ask my question:

ClientForm -> temptable
-> PaymentPage
payment success -> move record in temp table and store record in maintable + issue email /w attachment

what I need to figure out is the moving of the information part.

Posted: Thu May 31, 2007 9:50 am
by aredden
hmmm...came up with this.

Client Form to temptable > mysql query id num > store id num in session data > payment page > confirm page.

where confirm page runs this

INSERT INTO newtable (var1, var2, var3, ...) SELECT var1, var2, var3, ... FROM oldtable WHERE oldtable.id = '123456'

and i grab the oldtable id from the user's session data.


Look legit.?

Posted: Thu May 31, 2007 10:04 am
by volka
aredden wrote:ClientForm -> temptable
-> PaymentPage
payment success -> move record in temp table and store record in maintable + issue email /w attachment
Can you be more specific on this "PaymentPage"? Which service is it?

Posted: Thu May 31, 2007 10:59 am
by feyd
Contact your payment service provider. They should be able to direct you to the information they are able to send to your server once a transaction is completed.