update MYsql Database once results return from payment centr

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
jonnyfortis
Forum Contributor
Posts: 462
Joined: Tue Jan 10, 2012 6:05 am

update MYsql Database once results return from payment centr

Post 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
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Re: update MYsql Database once results return from payment c

Post by Weirdan »

What's the problem though? I fail to see it.
jonnyfortis
Forum Contributor
Posts: 462
Joined: Tue Jan 10, 2012 6:05 am

Re: update MYsql Database once results return from payment c

Post 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
jonnyfortis
Forum Contributor
Posts: 462
Joined: Tue Jan 10, 2012 6:05 am

Re: update MYsql Database once results return from payment c

Post by jonnyfortis »

Post Reply