Page 1 of 1

update MYsql Database once results return from payment centr

Posted: Wed Feb 06, 2013 6:01 am
by jonnyfortis
I am working on the final part to a shopping cart, i have the return values coming through from the payment centre. But what i need to do now is pass the relevent information to my database to show the transaction status ...then in turn update the stock ( i know how to do this part)

the main variable i need is the $StatusCode ( for the particular payment system "0" means passed )

if this is successful this is

Code: Select all

if ($StatusCode == "0")

any other values has failed and i just need to display a failed notification

I have a table in my database called Orders with a collumn called fullfilled this i where i want to update the $StatusCode value in to.

I can then make an if statement with the results based on the value of the column "fullfilled"

so i need to know how to update the table based on the results


thanks in advance

Re: update MYsql Database once results return from payment c

Posted: Wed Feb 06, 2013 11:04 am
by Weirdan
What's the problem though? I fail to see it.

Re: update MYsql Database once results return from payment c

Posted: Wed Feb 06, 2013 11:07 am
by jonnyfortis
What's the problem though? I fail to see it.
I need to know the code to pass the information

the update statement and what it need to contain

Re: update MYsql Database once results return from payment c

Posted: Wed Feb 06, 2013 11:25 am
by Weirdan

Re: update MYsql Database once results return from payment c

Posted: Wed Feb 06, 2013 12:10 pm
by jonnyfortis